On Tue, Aug 23, 2016 at 3:59 AM, Andres Freund <and...@anarazel.de> wrote: >> Haribabu's categorization >> scheme seems to need some work, but the idea of categorizing >> statements by type and counting executions per type seems very >> reasonable. > > I'd consider instead using something like COALESCE(commandType, > nodeTag(Query->utilityStmt)) as the categories. Not sure if I'd even > pivot that.
CommandType means to use select, insert, update, delete and utility as the categorization to display the counters? I think I am not getting your point correctly. Apart from the above, here are the following list of command tags that are generated in the code, I took only the first word of the command tag just to see how many categories present. The number indicates the subset of operations or number of types it is used. Like create table, create function and etc. insert delete update select (6) transaction (10) declare close (2) move fetch create (37) drop (36) Alter (56) import truncate comment security copy grant revoke notify listen unlisten load cluster vacuum analyze explain refresh set (2) reset show discard (4) reassign lock checkpoint reindex prepare execute deallocate we can try to pick something from the above list also for main categories and rest will fall under other. Regards, Hari Babu Fujitsu Australia -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers