Command statistics system (cmdstats) - Mailing list pgsql-hackers

From Mark Dilger
Subject Command statistics system (cmdstats)
Date
Msg-id 38F1CC20-2A86-4329-B691-22424980A28A@enterprisedb.com
Whole thread Raw
In response to Re: New SQL counter statistics view (pg_stat_sql)  (Mark Dilger <mark.dilger@enterprisedb.com>)
Responses Re: Command statistics system (cmdstats)  (Mark Dilger <mark.dilger@enterprisedb.com>)
Re: Command statistics system (cmdstats)  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Hackers,

as mentioned in [1], I have created an implementation of command counter statistics very similar in purpose to the one
alreadypending in the commitfest going by the name "pg_stat_sql".  I don't really care if this implementation is seen
asbuilding on that one or as separate, but I was worried about hijacking that thread, so I'm starting this thead.
Thereare elements of this patch that borrowed from that one, so if this is accepted, authorship should reflect that. 

See the work by Haribabu Kommi (haribabu) at https://commitfest.postgresql.org/27/790/

The two main differences are that

(1) This implementation is based on commandtags as enums, not strings and
(2) This implementation uses techniques to reduce lock contention

I think (2) is the more important part.

[1] https://www.postgresql.org/message-id/28F46159-3764-421B-904B-004DEA339310%40enterprisedb.com


—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company




Attachment

pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: Identifying user-created objects
Next
From: Suraj Kharage
Date:
Subject: Re: backup manifests