| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Vinay Gupta <vdadagupta(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Doubts after evaluating Xlogdump |
| Date: | 2014-02-27 18:46:28 |
| Message-ID: | CAMkU=1w=ct0zZdGGBTiXdec9GKZjxFWjFEGchHOTozPneMHwjA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Feb 27, 2014 at 7:39 AM, Vinay Gupta <vdadagupta(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brett Mc Bride | 2014-02-28 00:16:28 | Re: Josh's Comments on Hstore / Jsonb |
| Previous Message | Brent Wood | 2014-02-27 18:24:14 | Re: Multiple Schema in One DB |