Re: Query Tuning

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Query Tuning
Дата
Msg-id CAHOFxGqHEMzCrtAwY2UZGBvmJL2PCkmw9agPAfcdZ4vpuJDF_A@mail.gmail.com
обсуждение исходный текст
Ответ на Query Tuning  (Sonam Sharma <sonams1209@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Drop a primary
Следующее
От: "Enrico Thierbach"
Дата:
Сообщение: partitions vs indexes