{"id":39458,"date":"2026-03-07T15:27:07","date_gmt":"2026-03-07T14:27:07","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/building-a-db-tool-to-automatically-detect-fix-toxic-queries-i-need-some-anonymized-pg_stat_statements-data-to-test-it\/"},"modified":"2026-03-07T15:27:07","modified_gmt":"2026-03-07T14:27:07","slug":"building-a-db-tool-to-automatically-detect-fix-toxic-queries-i-need-some-anonymized-pg_stat_statements-data-to-test-it","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/building-a-db-tool-to-automatically-detect-fix-toxic-queries-i-need-some-anonymized-pg_stat_statements-data-to-test-it\/","title":{"rendered":"Building A DB Tool To Automatically Detect &amp; Fix Toxic Queries. I Need Some Anonymized Pg_stat_statements Data To Test It!"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Hi everyone,<\/p>\n<p>I&#8217;m a computer science student at EPFL (Switzerland), and I&#8217;m currently working on a side project: an automated database analyzer that detects toxic\/expensive SQL queries and uses AI to actively rewrite them into optimized code.<\/p>\n<p>I&#8217;ve built the local MVP in Python, but testing it against my own &#8220;fake&#8221; mock data isn&#8217;t enough anymore. I need real-world chaos.<\/p>\n<p>Would anyone be willing to share an <strong>anonymized<\/strong> export of their <\/p>\n<p>pg_stat_statements (CSV) and the basic DDL Schema of their database?<\/p>\n<ul>\n<li>No PII or customer data needed.<\/li>\n<li>I just need the query structure, execution time, calls, and I\/O blocks.<\/li>\n<\/ul>\n<p>In exchange, I will run your data through my engine and send you the generated &#8220;Optimization &amp; Cost-Saving Audit&#8221; report for free. It might actually help you spot a bottleneck!<\/p>\n<p>Let me know if you are open to helping a student out, send me a DM! Thanks!<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/Foreign-Bison-7826\"> \/u\/Foreign-Bison-7826 <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1rnb0kd\/building_a_db_tool_to_automatically_detect_fix\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1rnb0kd\/building_a_db_tool_to_automatically_detect_fix\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-39458 jlk' href='javascript:void(0)' data-task='like' data-post_id='39458' data-nonce='bc39e8310e' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-39458 lc'>0<\/span><\/a><\/div><\/div> <div class='status-39458 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Hi everyone, I&#8217;m a computer science student at EPFL (Switzerland), and I&#8217;m currently working on a side&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-39458","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/39458","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=39458"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/39458\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=39458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=39458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=39458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}