Postgres Pro
Downloads
Home   >   mailing lists

Re: Doubts after evaluating Xlogdump - Mailing list pgsql-general

From Jeff Janes
Subject Re: Doubts after evaluating Xlogdump
Date
Msg-id CAMkU=1w=ct0zZdGGBTiXdec9GKZjxFWjFEGchHOTozPneMHwjA@mail.gmail.com
Whole thread Raw
In response to Doubts after evaluating Xlogdump  (Vinay Gupta <vdadagupta@gmail.com>)
List pgsql-general
Tree view
On Thu, Feb 27, 2014 at 7:39 AM, Vinay Gupta <vdadagupta@gmail.com> wrote:
 
1078769 s/d/r:1663/1228184/5263108,insert_leaf:
1155642 s/d/r:1663/1228184/5263105,insert:
1181241 s/d/r:1663/1228184/5263107,insert_leaf:

Is dere any better way where i can analyse who is contributing most in my pgxlog file generation.

Also,  how can i link my insert_leaf statements to my tables/indexes ?

1078769 s/d/r:1663/1228184/5263108,insert_leaf:

Use the --oid2name flag for xlogdump, or just manually use oid2name.  You have to make sure to specify the correct port, etc., to use that.

Cheers,

Jeff

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Issue with default values and Rule
Next
From: James Harper
Date:
Subject: multiple results from a function