Postgres Pro
Downloads
Home   >   mailing lists

Re: Transaction Steps!! - Mailing list pgsql-general

From Simon Riggs
Subject Re: Transaction Steps!!
Date
Msg-id 1190641994.4181.183.camel@ebony.site
Whole thread Raw
In response to Transaction Steps!!  (Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>)
List pgsql-general
Tree view 
On Mon, 2007-09-24 at 10:35 +0100, Farhan Mughal wrote:
>
> Can someone please tell How a simple transaction goes through various
> steps for completion in PostgreSQL. Thanks.
>

You might mean the execution steps. You can view these using EXPLAIN.

http://developer.postgresql.org/pgdocs/postgres/sql-explain.html

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: DELETE FROM pg_class
Next
From: Alvaro Herrera
Date:
Subject: Re: SRF called with optional NULL input runs 7x slower