On Sun, Oct 16, 2011 at 5:24 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
>> On Sat, Oct 15, 2011 at 2:20 PM, Thomas Kellerer <spam_eater(at)gmx(dot)net> 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.