{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"Under-indexing","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/b04e8d10\"></iframe>","width":"100%","height":180,"duration":2076,"description":"Nikolay and Michael discuss under-indexing — how to tell if this applies to you, some general and specific cases, as well as some tricky ones. \n \nHere are some links to things they mentioned:\nIndexes (docs) https://www.postgresql.org/docs/current/indexes.html \nrandom_page_cost https://postgresqlco.nf/doc/en/param/random_page_cost/\nSequential scans https://www.pgmustard.com/docs/explain/sequential-scan  \npg_stat_user_tables https://pgpedia.info/p/pg_stat_user_tables.html \npg_stat_statements https://www.postgresql.org/docs/current/pgstatstatements.html\nauto_explain https://www.postgresql.org/docs/current/auto-explain.html \nOur episode on slow queries https://postgres.fm/episodes/slow-queries-and-slow-transactions \nOur episode on query macro analysis https://postgres.fm/episodes/macro-query-analysis-intro\nRunning 10 Million PostgreSQL Indexes In Production (And Counting) https://www.heap.io/blog/running-10-million-postgresql-indexes-in-production \nFaceting large result sets in PostgreSQL https://www.cybertec-postgresql.com/en/faceting-large-result-sets/ \nOur episode on over-indexing https://postgres.fm/episodes/over-indexing \n\n~~~\nWhat did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!\n\n~~~\nPostgres FM is brought to you by:\nNikolay Samokhvalov, founder of Postgres.ai\nMichael Christofides, founder of pgMustard\nWith special thanks to:\nJessie Draws for the amazing artwork ","thumbnail_url":"https://img.transistorcdn.com/NFbJlGhGV5mzIU1kM0iZ823A69pjZUNX40LszVO5LKI/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}