Postgres Pro
Downloads
Home   >   mailing lists

monitoring - Mailing list pgsql-novice

From Mohammed A
Subject monitoring
Date
Msg-id 001401c0ebb2$681e5be0$237ef59b@essex.ac.uk
Whole thread Raw
Responses Re: monitoring
List pgsql-novice
Tree view
Dear All,
 
Is any way to monitor the execution of the query, for example a query;
 
SELECT     L_ORDERKEY, L_EXTENDEDPRICE, L_DISCOUNT, O_ORDERDATE, O_SHIPPRIORITY FROM C_, O_, L_
FROM        L_, O_, C_
WHERE     C_MKTSEGMENT='BUILDING' AND C_CUSTKEY=O_CUSTKEY AND L_ORDERKEY=O_ORDERKEY
                    AND O_ORDERDATE  <'1995-03-15' AND L_SHIPDATE > '1995-03-15'
 
Is any command to monitor the time for joining...etc all the query activities?
 
please let me know as soon as possible.
 
 
thank you

pgsql-novice by date:

Previous
From: Chadwick Rolfs
Date:
Subject: Creating table columns from ???
Next
From: Giles Lean
Date:
Subject: Re: Creating table columns from ???