Slide 33
Slide 33 text
paperless@[local]/paperless-production=> SELECT query, calls, total_time, rows, 100.0 * shared_blks_hit /
nullif(shared_blks_hit + shared_blks_read, 0) AS hit_percent
FROM pg_stat_statements ORDER BY total_time DESC LIMIT 5;
-[ RECORD
1 ]---------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------
query | SELECT * FROM "email_addresses" WHERE (LOWER(email_addresses.email_address) = LOWER(?)) LIMIT ?
calls | 744384675
total_time | 189703962.235031
rows | 721856740
hit_percent | 82.6364412412666404
-[ RECORD
2 ]---------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------
query | SELECT "discount_redemptions".id FROM "discount_redemptions" WHERE ("discount_redemptions".cart_id = ?)
LIMIT ? /*uuid:http-5458c26d50bf0042c4c5007fa02c2d80*/
calls | 26472909
total_time | 136787447.010999
rows | 124208
hit_percent | 99.9999962924170858
-[ RECORD
3 ]---------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------
query | SELECT count(*) AS count_all FROM "discount_redemptions" WHERE ("discount_redemptions".cart_id = ?) /
*uuid:http-19854d4f87d507488eb92de7e3d18d12*/
calls | 25914050
total_time | 127617483.302989
rows | 25914050
hit_percent | 100.0000000000000000
-[ RECORD
4 ]---------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------
query | SELECT * FROM "events" WHERE ("events"."id" = ?) /*uuid:resque-8262bba6d8bfba15871083236792e93b*/
calls | 2006362390
total_time | 110051869.950854
rows | 2002901227
hit_percent | 96.8441002881508271
-[ RECORD
5 ]---------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------
query | SELECT * FROM "discount_redemptions" WHERE ("discount_redemptions".account_id = ?) AND
("discount_redemptions"."complete" = ?) /*uuid:http-f90e03d33cfd0fa541cc87d5a7038157*/
calls | 26336287
total_time | 108405954.313974
rows | 1189818
hit_percent | 100.0000000000000000