Haribabu Kommi wrote: > 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.
Sounds about right. I suppose all those cases that you aggregated here would expand to full tags in the actual code. I furthermore suppose that some of these could be ignored, such as the transaction ones and things like load, lock, move, fetch, discard, deallocate (maybe lump them all together under "other", or some other rough categorization, as Tom suggests). Also, for many of these commands it's probably relevant whether they are acting on a temporary object or not; we should either count these separately, or not count the temp ones at all. > 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 -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers