Re: Query Tuning - Mailing list pgsql-general

From Michael Lewis
Subject Re: Query Tuning
Date
Msg-id CAHOFxGqHEMzCrtAwY2UZGBvmJL2PCkmw9agPAfcdZ4vpuJDF_A@mail.gmail.com
Whole thread Raw
In response to Query Tuning  (Sonam Sharma <sonams1209@gmail.com>)
List pgsql-general
Both of the below visualizers can help, but require some knowledge about comparing estimated vs actual row estimates, disk sorts vs in memory, etc. Drawing implications about whether your schema needs to change or just the query will take time to master as well.

http://tatiyants.com/pev/#/plans/new --data only stored locally on your computer, nice for security but not great for sharing with others and getting help, since you need to share full json output (and query ideally)

https://explain.depesz.com/ --URL is unique and sharable for help from others


Often you need to provide much more information to get good advice. What version of Postgres are you on? What are stats like for the involved tables? What other indexes are available or might you add? What is the use of this system-- single user or thousands? Heavy writes continually, or load & analysis? Can you share the full query text and output of EXPLAIN ANALYZE on it?

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Drop a primary
Next
From: "Enrico Thierbach"
Date:
Subject: partitions vs indexes