https://ardentperf.com/2022/02/10/a-hairy-postgresql-incident/
Unlike some other relational databases, PostgreSQL does not give much visibility into execution plans used at runtime. There’s auto_explain which can log actual plans for SQL that successfully completes with a runtime above some threshold. (View Highlight)
Joshua left a comment reminding me about Cybertec and Hironobu Suzuki’s extension pg_show_plans. (View Highlight)
We have a script of our own which is very similar to Tanel Poder’s run_xcpu.sh in his 0x.tools collection. (View Highlight)
Note: `run_xcpu.sh` in his [0x.tools collection](https://0x.tools/)
ian's Highlights 