Re: What is postgresql doing for "statement: commit;begin;"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nick Burch <nick(at)torchbox(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What is postgresql doing for "statement: commit;begin;"
Date: 2005-01-17 15:53:08
Message-ID: 1996.1105977188@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Nick Burch <nick(at)torchbox(dot)com> writes:
> Quite a lot, I'm seeing lines like:
> 2005-01-17 13:11:15 LOG: duration: 4688.108 ms statement: commit;begin;

> Is there any way to find out what exactly got executed here?

A whole lot of deferred-until-transaction-commit operations, evidently.
You got any deferred foreign keys in this database?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-01-17 15:59:56 Re: PQexecParams and CURSOR
Previous Message Frank D. Engel, Jr. 2005-01-17 15:51:40 Re: Index optimization ?