Dave Owens <dave@xxxxxxxxxxxxx> wrote: > On Tue, Aug 19, 2014 at 11:01 AM, Kevin Grittner <kgrittn@xxxxxxxxx> wrote: >> CREATE TABLE activity_snap_1 AS SELECT * FROM pg_stat_activity; > Would the you or the list be interested in snapshots of pg_locks as well? Most definitely! I'm sorry that copied/pasted the pg_stat_activity example, I was playing with both. pg_locks is definitely the more important one, but it might be useful to try to match some of these locks up against process information as we drill down from the summary to see examples of what makes up those numbers. > I can take a restart tonight and get this going on a half-hourly basis > (unless you think more frequent snaps would be useful). Each half-hour should be fine as long as that gives at least three or four samples before you are unable to query pg_locks. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
