| From: | Nabil Sayegh <nsmail(at)sayegh(dot)de> |
|---|---|
| To: | Mohammed A <mjalha(at)essex(dot)ac(dot)uk> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: monitoring |
| Date: | 2001-06-03 06:36:19 |
| Message-ID: | 20010603003123.7BB0014EE63@gerstung3.net-lab.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On 02 Jun 2001 23:21:42 +0100, Mohammed A wrote:
> 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?
Not quite monitoring, but you can extimate it using EXPLAIN <QUERY>
cu
--
Nabil Sayegh
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric Naujock | 2001-06-04 14:05:41 | Looking for a way to get my time format. |
| Previous Message | Giles Lean | 2001-06-02 23:17:05 | Re: Creating table columns from ??? |