On Sun, Oct 16, 2011 at 5:24 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Scott Marlowe <scott.marlowe@xxxxxxxxx> writes: >> On Sat, Oct 15, 2011 at 2:20 PM, Thomas Kellerer <spam_eater@xxxxxxx> wrote: >>> Total runtime: -2.368 ms <<==== this is amazing ;) > >> I get something similar when I do select now()-query_start from >> pg_stat_activity on my Ubuntu 10.04 / pg 8.3 servers. > > Within a transaction block that's not surprising, because now() is > defined as transaction start time not statement start time. No transaction block. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general