On Mon, 17 Jan 2005, Tom Lane wrote:
> Nick Burch <[EMAIL PROTECTED]> 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?
No, we don't. Because of this, I did some reading and discovered
"log_statement" and "log_pid", and turned them on.
It appears that ColdFusion is wrapping some of it's internal housekeeping
DB calls in transactions, and these are the ones that then show up as the
long running "statement: commit;begin;" entries. Mystery solved.
Thanks
Nick
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
