René's URL Explorer Experiment


Title: Slow Query Questions - PostgreSQL wiki

Generator: MediaWiki 1.39.17

direct link

Domain: wiki.postgresql.org

format-detectiontelephone=no

Links:

Want to edit, but don't see an edit button when logged in? Click here.https://wiki.postgresql.org/wiki/WikiEditing
SlowQueryQuestionshttps://wiki.postgresql.org/index.php?title=SlowQueryQuestions&redirect=no
Jump to navigationhttps://wiki.postgresql.org/wiki/SlowQueryQuestions#column-one
Jump to searchhttps://wiki.postgresql.org/wiki/SlowQueryQuestions#searchInput
1 Guide to Asking Slow Query Questionshttps://wiki.postgresql.org/wiki/SlowQueryQuestions#Guide_to_Asking_Slow_Query_Questions
2 Things to Try Before You Posthttps://wiki.postgresql.org/wiki/SlowQueryQuestions#Things_to_Try_Before_You_Post
3 Information You Need To Includehttps://wiki.postgresql.org/wiki/SlowQueryQuestions#Information_You_Need_To_Include
3.1 Postgres versionhttps://wiki.postgresql.org/wiki/SlowQueryQuestions#Postgres_version
3.2 Operating system+versionhttps://wiki.postgresql.org/wiki/SlowQueryQuestions#Operating_system+version
3.3 Full Table and Index Schemahttps://wiki.postgresql.org/wiki/SlowQueryQuestions#Full_Table_and_Index_Schema
3.4 Table Metadatahttps://wiki.postgresql.org/wiki/SlowQueryQuestions#Table_Metadata
3.5 EXPLAIN (ANALYZE, BUFFERS), not just EXPLAINhttps://wiki.postgresql.org/wiki/SlowQueryQuestions#EXPLAIN_(ANALYZE,_BUFFERS),_not_just_EXPLAIN
3.6 Historyhttps://wiki.postgresql.org/wiki/SlowQueryQuestions#History
3.7 Hardwarehttps://wiki.postgresql.org/wiki/SlowQueryQuestions#Hardware
3.8 Hardware benchmarkhttps://wiki.postgresql.org/wiki/SlowQueryQuestions#Hardware_benchmark
3.9 Maintenance Setuphttps://wiki.postgresql.org/wiki/SlowQueryQuestions#Maintenance_Setup
3.10 WAL Configurationhttps://wiki.postgresql.org/wiki/SlowQueryQuestions#WAL_Configuration
3.11 GUC Settingshttps://wiki.postgresql.org/wiki/SlowQueryQuestions#GUC_Settings
3.12 Statistics: n_distinct, MCV, histogramhttps://wiki.postgresql.org/wiki/SlowQueryQuestions#Statistics:_n_distinct,_MCV,_histogram
3.13 Enable Logginghttps://wiki.postgresql.org/wiki/SlowQueryQuestions#Enable_Logging
https://paste.depesz.com/https://paste.depesz.com/
Guide to reporting problemshttps://wiki.postgresql.org/wiki/Guide_to_reporting_problems
Using EXPLAINhttps://wiki.postgresql.org/wiki/Using_EXPLAIN
Tuning Your PostgreSQL Serverhttps://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
explain.depesz.comhttp://explain.depesz.com/
Server Configurationhttps://wiki.postgresql.org/wiki/Server_Configuration
Guide to reporting problemshttps://wiki.postgresql.org/wiki/Guide_to_reporting_problems
Server Configurationhttps://wiki.postgresql.org/wiki/Server_Configuration
https://wiki.postgresql.org/index.php?title=Slow_Query_Questions&oldid=37712https://wiki.postgresql.org/index.php?title=Slow_Query_Questions&oldid=37712
Categorieshttps://wiki.postgresql.org/wiki/Special:Categories
Performancehttps://wiki.postgresql.org/wiki/Category:Performance
FAQhttps://wiki.postgresql.org/wiki/Category:FAQ
Asking Questionshttps://wiki.postgresql.org/wiki/Category:Asking_Questions
Pagehttps://wiki.postgresql.org/wiki/Slow_Query_Questions
Discussionhttps://wiki.postgresql.org/index.php?title=Talk:Slow_Query_Questions&action=edit&redlink=1
Readhttps://wiki.postgresql.org/wiki/Slow_Query_Questions
View sourcehttps://wiki.postgresql.org/index.php?title=Slow_Query_Questions&action=edit
Historyhttps://wiki.postgresql.org/index.php?title=Slow_Query_Questions&action=history
Pagehttps://wiki.postgresql.org/wiki/Slow_Query_Questions
Discussionhttps://wiki.postgresql.org/index.php?title=Talk:Slow_Query_Questions&action=edit&redlink=1
Morehttps://wiki.postgresql.org/wiki/SlowQueryQuestions#p-cactions
Toolshttps://wiki.postgresql.org/wiki/SlowQueryQuestions#p-tb
Log inhttps://wiki.postgresql.org/index.php?title=Special:UserLogin&returnto=Slow+Query+Questions
https://wiki.postgresql.org/wiki/Main_Page
Main Pagehttps://wiki.postgresql.org/wiki/Main_Page
Random pagehttps://wiki.postgresql.org/wiki/Special:Random
Recent changeshttps://wiki.postgresql.org/wiki/Special:RecentChanges
Helphttps://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents
What links herehttps://wiki.postgresql.org/wiki/Special:WhatLinksHere/Slow_Query_Questions
Related changeshttps://wiki.postgresql.org/wiki/Special:RecentChangesLinked/Slow_Query_Questions
Special pageshttps://wiki.postgresql.org/wiki/Special:SpecialPages
Printable versionjavascript:print();
Permanent linkhttps://wiki.postgresql.org/index.php?title=Slow_Query_Questions&oldid=37712
Page informationhttps://wiki.postgresql.org/index.php?title=Slow_Query_Questions&action=info
https://wiki.postgresql.org/wiki/SlowQueryQuestions#sidebar
https://wiki.postgresql.org/wiki/SlowQueryQuestions#p-personal
https://wiki.postgresql.org/wiki/SlowQueryQuestions#globalWrapper
https://www.mediawiki.org/
Privacy policyhttps://wiki.postgresql.org/wiki/PostgreSQL_wiki:Privacy_policy
About PostgreSQL wikihttps://wiki.postgresql.org/wiki/PostgreSQL_wiki:About
Disclaimershttps://wiki.postgresql.org/wiki/PostgreSQL_wiki:General_disclaimer

Viewport: width=device-width, initial-scale=1.0, user-scalable=yes, minimum-scale=0.25, maximum-scale=5.0

URLs of crawlers that visited me.