Re: proposal for 9.5: monitoring lock time for slow queries - Mailing list pgsql-hackers

From MauMau
Subject Re: proposal for 9.5: monitoring lock time for slow queries
Date
Msg-id 5655F5E79C8E46D7AA89C9DA003A1FD3@maumau
Whole thread Raw
In response to Re: proposal for 9.5: monitoring lock time for slow queries  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
From: "Alvaro Herrera" <alvherre@2ndquadrant.com>
> Is this supposed to be session-local data, or is it visible from remote
> sessions too?  How durable is it supposed to be?  Keep in mind that in
> case of a crash, all pgstats data is erased.

I want it to be visible from other sessions.  I'm okay about the data 
erasure during recovery.  We can probably extend pg_statsinfo to save the 
new info for long-term trend analysis.  TBH, I want a feature like 
pg_statsinfo in core.

Regards
MauMau




pgsql-hackers by date:

Previous
From: "MauMau"
Date:
Subject: Re: [patch] pg_copy - a command for reliable WAL archiving
Next
From: Craig Ringer
Date:
Subject: Re: Reporting the commit LSN at commit time