Skip site navigation (1) Skip section navigation (2)


From: webb sprague <wsprague(at)o1(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Diagnostic
Date: 2001-04-27 22:47:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
I am trying to determine how many seconds a query takes, and I can't
figure it out.  I seem to remember some weird, mostly undocumented query
that went like:

foo# get diagnostics select processed into <int4 variable>;
foo# show <int4 variable>;

But this doesn't work, and I think it may only work in plpgsql function

I know how to use explain, but I want to see if postgres is correct
which query is fastest.

Does anybody know how to find this info out?


In response to

pgsql-general by date

Next:From: Harry YauDate: 2001-04-28 01:46:44
Subject: function with multi-values
Previous:From: Mikheev, VadimDate: 2001-04-27 22:03:42
Subject: RE: WAL Log using all my disk space!

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group