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

Diagnostic

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: 3AE9F702.76D428E5@o1.com (view raw or flat)
Thread:
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
anyway.

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?

Thx

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-2014 The PostgreSQL Global Development Group