Here some number from a mine old pgfouine report:
- query peak: 378 queries/s
- select: 53,1%, insert 3,8%, update 2,2 %, delete 2,8 %
Actually the percentages are wrong (I think pgfouine counts also other types of query like ET SESSION CHARACTERISTICS AS TRANSACTION READ WRITE;):
These are the right ones:
SELECT num: 658,5 perc: 85,7 %
INSERT num: 47,66 perc: 6,2 %
UPDATE num: 27,49 perc: 3,6 %
DELETE num: 34,56 perc: 4,5 %
ste