Postgres Pro
Downloads
Home   >   mailing lists

Re: something similar to explain - Mailing list pgsql-admin

From Tom Lane
Subject Re: something similar to explain
Date
Msg-id 6916.1015267618@sss.pgh.pa.us
Whole thread Raw
In response to something similar to explain  (Lucas Rockwell <lr@socrates.Berkeley.EDU>)
List pgsql-admin
Tree view 
Lucas Rockwell <lr@socrates.Berkeley.EDU> writes:
> i am running some tests and i would like to see how long it takes to run a
> query. "explain" gives me query plan info, but i want to actually run the
> query and then find out how long it took.

Update to 7.2 and use EXPLAIN ANALYZE.

            regards, tom lane

pgsql-admin by date:

Previous
From: Joe Conway
Date:
Subject: Re: [GENERAL] Which trigger execute which function?
Next
From: "Fouad Fezzi"
Date:
Subject: don't see table of database with psql