Hi! I have pgBadger report with strange data about prepared queries I cannot interpret by myself. If anybody could help me with interpretation, would be greatly appreciated. In first half of the day pgBadger shows there is no prepare statements and all queries are binded - how is that possible if average duration of session is only 4m16s, not 15 hours?
Hour Prepare Bind Bind/Prepare Percentage of prepare 0 0 4,059 4,059.00 0.00% 1 0 341 341.00 0.00% 2 0 8 8.00 0.00% 3 0 16 16.00 0.00% 4 0 28 28.00 0.00% 5 0 6 6.00 0.00% 6 0 350 350.00 0.00% 7 0 2,35 2,350.00 0.00% 8 0 1,999 1,999.00 0.00% 9 0 2,383 2,383.00 0.00% 10 3 870 290.00 0.34% 11 0 1,941 1,941.00 0.00% 12 2 1,397 698.50 0.14% 13 0 798 798.00 0.00% 14 0 1,445 1,445.00 0.00% 15 1,707,090 1,707,503 1.00 99.93% 16 2,133,960 2,134,001 1.00 99.94% 17 1,793,804 1,793,851 1.00 99.93% 18 1,745,064 1,745,095 1.00 99.94% 19 1,067,248 1,067,288 1.00 99.90% 20 937,137 937,142 1.00 99.88% 21 596,606 596,603 1.00 34.43% 22 711,941 711,945 1.00 58.58% 23 816,353 816,37 1.00 99.86% -- View this message in context: http://postgresql.nabble.com/Strange-activity-of-prepared-queries-tp5932990.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
