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 Yau||Date: 2001-04-28 01:46:44|
|Subject: function with multi-values|
|Previous:||From: Mikheev, Vadim||Date: 2001-04-27 22:03:42|
|Subject: RE: WAL Log using all my disk space!|