why postgres using sec scan isntead of index - SERP Analysis

https://www.postgresql.org/message-id/5FE1E177-BFDB-4386-8DDC-02A652E71C86%40thebuild.com

https://stackoverflow.com/questions/66820661/index-scan-vs-sequential-scan-in-postgres

https://www.reddit.com/r/PostgreSQL/comments/1dvj9zc/index_scan_vs_seq_scan/

https://dba.stackexchange.com/questions/323343/postgresql-perform-sequential-scan-instead-of-index-scan-for-indexed-column

https://medium.com/towardsdev/why-postgresql-uses-sequential-scan-even-if-index-exists-19b439bb7c7f

https://www.pgmustard.com/blog/why-isnt-postgres-using-my-index

https://www.cybertec-postgresql.com/en/postgresql-indexing-index-scan-vs-bitmap-scan-vs-sequential-scan-basics/

https://www.gojek.io/blog/the-case-s-of-postgres-not-using-index

https://use-the-index-luke.com/sql/explain-plan/postgresql/operations

https://www.postgrespro.com/list/thread-id/2124766

https://pganalyze.com/blog/5mins-postgres-large-integers-causing-sequential-scan-instead-of-using-index

https://www.postgresql.org/docs/8.1/performance-tips.html

https://pgsql-performance.postgresql.narkive.com/bAn1fJbW/seq-scan-used-instead-of-index-scan

https://www.percona.com/blog/decoding-sequential-scans-in-postgresql/

https://postgrespro.com/list/thread-id/2357775

https://www.quora.com/How-do-you-handle-PostgreSQL-ignoring-index-which-runs-a-sequence-scan-PostgreSQL-index-PostgreSQL-performance-datatypes-DBA

https://severalnines.com/blog/overview-various-scan-methods-postgresql/

https://pgsql-performance.postgresql.narkive.com/Bbe7Jtb5/slow-delete-seq-scan-instead-of-index-scan

https://thoughtbot.com/blog/why-postgres-wont-always-use-an-index

https://github.com/pgvector/pgvector/issues/216

https://www.pgmustard.com/docs/explain/seq-scan

https://airbyte.com/blog/postgresql-query-plans-for-reading-tables

https://medium.com/%40magda7817/will-postgres-use-my-index-or-not-64f48089e597

https://www.yugabyte.com/blog/postgresql-like-query-performance-variations/

https://www.youtube.com/watch?v=A0Z8igAwwdI

https://github.com/timescale/timescaledb/issues/2744

https://fadaiganjaliyev.com/six-ways-to-force-sequential-scan-in-postgres/

https://bugfactory.io/articles/force-index-usage-by-manipulating-the-query-planner/

https://dev.to/aws-heroes/postgresql-with-modern-storage-what-about-a-lower-randompagecost-5b7f

https://incident.io/blog/choosing-the-right-postgres-indexes

https://www.timescale.com/learn/postgresql-performance-tuning-optimizing-database-indexes

https://scalegrid.io/blog/postgres-explain-cost/

https://postgres.fm/episodes/why-isnt-postgres-using-my-index/transcript

https://code.jeremyevans.net/2022-11-01-forcing-sequential-scans-on-postgresql.html

https://www.crunchydata.com/blog/postgresql-brin-indexes-big-data-performance-with-minimal-storage

https://www.percona.com/blog/one-index-three-different-postgresql-scan-types-bitmap-index-and-index-only/

https://aaronoellis.com/articles/postgres-enable-seqscan-off

https://www.enterprisedb.com/blog/effective-postgresql-monitoring-utilizing-pg-stat-all-tables-and-indexes-postgresql-16?lang=en

https://x.com/gwenshap/status/1928139754287333641

https://www.dbrnd.com/2016/11/postgresql-force-on-planner-to-use-sequential-scan-or-index-scan-enable_seqscan-enable_indexscan/

https://pganalyze.com/blog/how-postgres-chooses-index

https://www.rockdata.net/tutorial/understand-cost-estimation-of-seqscan/

https://www.depesz.com/2010/09/09/why-is-my-index-not-being-used/

https://www.postgresql.org/docs/current/parallel-plans.html

https://devcenter.heroku.com/articles/postgresql-indexes

https://eliasdorneles.com/til/posts/about-bitmap-heap-scan-on-potgresql-query-plan/

https://bannister.me/blog/a-beginners-guide-to-basic-indexing

http://manojadinesh.blogspot.com/2011/12/seq-scan-vs-index-scan.html

https://helloworld957536278.wordpress.com/2021/06/02/find-tables-on-which-postgresql-doing-sequential-scan/

https://andyatkinson.com/blog/2024/01/25/PostgreSQL-rows-removed-by-filter-meaning

https://supabase.com/docs/guides/troubleshooting/understanding-postgresql-explain-output-Un9dqX

https://dev.to/aws-heroes/the-most-annoying-optimizer-fail-in-postgres-solved-469b

https://medium.easyread.co/today-i-learned-understanding-postgres-explain-query-5670dd042c99

https://www.zen8labs.com/insights/development/sql/postgresql-scan-types-what-are-they/

https://www.qwertee.io/blog/postgresql-b-tree-index-explained-part-1/

https://postgis.net/docs/manual-1.3/ch05.html

https://pawelurbanek.com/explain-analyze-indexes

https://minervadb.xyz/troubleshooting-postgresql-queries-not-using-indexes/

https://www.dbi-services.com/blog/postgres-vs-oracle-access-paths-i/

https://render.com/blog/postgresql-slow-query-to-fast-via-stats

https://www.wasteman.codes/blog/i-have-an-index-and-my-query-is-still-slow

https://www.highgo.ca/2021/01/15/how-postgresql-executes-sequential-scans-with-the-help-of-table-access-methods-apis/

https://www.cybertec-postgresql.com/en/postgresql-more-performance-for-like-and-ilike-statements/?gad_source=1&gclid=CjwKCAjw5PK_BhBBEiwAL7GTPQrxMOdyEMBtdttVLHlHDx4O3AIqnZm99XaI0a5CIf0-AoKglhto6hoC3JIQAvD_BwE

https://www.reddit.com/r/PostgreSQL/comments/1dvj9zc/index_scan_vs_seq_scan/?tl=fil

https://www.datadoghq.com/blog/postgresql-monitoring/

https://www.youtube.com/watch?v=GtgJQ0HdA7M

https://www.enterprisedb.com/docs/epas/latest/application_programming/optimizing_code/05_optimizer_hints/02_access_method_hints/

https://www.rockdata.net/tutorial/plan-index-scan-types/

http://blog.cleverelephant.ca/2016/08/pgsql-text-pattern-ops.html

https://airbyte.com/blog/postgresql-query-plans-for-aggregating-data

https://gis.stackexchange.com/questions/130856/postgis-doesnt-use-spatial-index-with-st-intersects

https://www.postgresql.org/docs/current/using-explain.html

https://cloud.google.com/blog/products/databases/postgresql-16-now-available-in-cloud-sql

https://www.freecodecamp.org/news/postgresql-indexing-strategies/

https://www.gojek.io/blog/the-postgres-performance-tuning-manual-query-plans

https://habr.com/en/companies/postgrespro/articles/666974/

https://aws.amazon.com/blogs/database/index-types-supported-in-amazon-aurora-postgresql-and-amazon-rds-for-postgresql-b-tree/

https://www.youtube.com/watch?v=ZxqfSDND5bg

http://rhaas.blogspot.com/2015/11/parallel-sequential-scan-is-committed.html

https://www.crunchydata.com/blog/why-covering-indexes-are-incredibly-helpful

https://www.postgresql.eu/events/fosdem2020/sessions/session/2863/slides/278/PostgreSQL%20Conf%20FODEM%202020%20-%20Deep%20Dive%20to%20PostgreSQL%20Indexes.pdf

https://yifan-online.com/en/km/article/detail/18116

https://niallburkley.com/blog/index-columns-for-like-in-postgres/

https://shinesolutions.com/2024/06/28/analysing-slow-query-performance-on-aurora-postgresql/

https://minervadb.xyz/decoding-disk-access-patterns-the-impact-of-random-vs-sequential-i-o-on-postgresql-performance/

http://postgis.net/workshops/postgis-intro/indexing.html

https://ask.use-the-index-luke.com/questions/148/why-is-this-postgres-query-doing-a-bitmap-heap-scan-after-the-index-scan

https://thoughtbot.com/blog/reading-an-explain-analyze-query-plan

https://habr.com/en/companies/postgrespro/articles/657833/

https://emplocity.com/en/about-us/blog/how_to_build_postgresql_full_text_search_engine_in_any_language/

https://www.postgresql.eu/events/pgconfeu2019/sessions/session/2741/slides/245/What

https://www.youtube.com/watch?v=6sm-_cqsOMs

https://www.depesz.com/2013/05/19/explaining-the-unexplainable-part-4/

https://www.prisma.io/blog/improving-query-performance-using-indexes-1-zuLNZwBkuL

https://www.postgresql.org/docs/current/indexes-index-only-scans.html

https://www.youtube.com/watch?v=6F8D3ReuGyI

https://blog.niclin.tw/2018/06/14/%E7%82%BA%E4%BB%80%E9%BA%BC-postgres-%E4%B8%8D%E9%81%B8%E6%93%87-index-scan-%E5%8D%BB%E9%81%B8%E6%93%87-seq-scan/

https://hvalls.dev/posts/optimize-query-sql

https://www.youtube.com/watch?v=QAYzWAlxCYc