{"repo":"dcgadmin/pg_sqltxplain","free":true,"listed":false,"github":"https://github.com/dcgadmin/pg_sqltxplain","clone":"git clone https://github.com/dcgadmin/pg_sqltxplain.git","description":"pg_sqltxplain - Simplifying PostgreSQL Execution Plan Analysis by curating underlying stats in a single html report.","language":"PLpgSQL","stars":31,"topics":["analyze","execution","explain","performance","plan","postgres","statistics","report","perv2","analysis"],"license":null,"category":"databases-storage","readme_excerpt":"pg sqltxplain - Simplifying PostgreSQL Execution Plan Analysis. Analyzing execution plans is made easier with curating execution plan, statistics of database objects such as tables, indexes, or columns involved in the actual runtime execution plan, all within a single report. This makes it easier to share among team members or external forum and reduces the need for additional information requests. This tool automates the curation of object statistics when analyzing problematic execution plans in PostgreSQL using an HTML template embded in sql file and the psql command line. It also includes an Expert Recommendations engine that automatically analyzes the execution plan and cross-references table/index/column statistics to produce prioritized, actionable tuning advice. How it Works? Execution plan is generated either by Explain Analyze Buffers or only with Explain and stored in a plantable. Using the psql command line, the current statistics of all database objects involved in Execution plan are fetched and included in the HTML output. The output can also be integrated with the PEV2 visualiser. Installation Setup Databases with necessary wrappers code that generate execution plan and stored it in plantable. Extension Dependency This tool uses the pg stat statements view to extract runtime information of problematic SQL using queryid . It can also be used as filters to gather Generic Plan from pg stat statements . The pgstattuple extension is used to extract bloat-related info","default_branch":null,"files":null,"tree":[],"storefront":"/r/dcgadmin","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/dcgadmin/pg_sqltxplain/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}