Postgres Pro
Downloads
Home   >   mailing lists

Re: What is postgresql doing for "statement: commit;begin;" - Mailing list pgsql-general

From Tom Lane
Subject Re: What is postgresql doing for "statement: commit;begin;"
Date
Msg-id 1996.1105977188@sss.pgh.pa.us
Whole thread Raw
In response to What is postgresql doing for "statement: commit;begin;"  (Nick Burch <nick@torchbox.com>)
Responses Re: What is postgresql doing for "statement: commit;begin;"  (Nick Burch <nick@torchbox.com>)
List pgsql-general
Tree view 
Nick Burch <nick@torchbox.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

pgsql-general by date:

Previous
From: Bo Lorentsen
Date:
Subject: Re: Index optimization ?
Next
From: "Frank D. Engel, Jr."
Date:
Subject: Re: Index optimization ?