Optimization of SQL queries

[egorsmkv]

I should have ability to:

1. See executing queries to PgSQL - Telescope::Queries
2. Be able to EXPLAIN them - pgweb
3. Have tools to help me to optimize them in the app - https://github.com/postgres-ai/joe

[egorsmkv]

Read these:

• https://postgres.ai/blog/20230722-10-postgres-tips-for-beginners
• https://medium.com/@shaileshkumarmishra/find-slow-queries-in-postgresql-42dddafc8a0e
• https://www.cybertec-postgresql.com/en/3-ways-to-detect-slow-queries-in-postgresql/
• https://www.crunchydata.com/blog/get-started-with-explain-analyze
• https://medium.com/geekculture/how-to-read-and-understand-explain-query-plans-in-postgresql-8179299fd613

[egorsmkv]

File location in the container: /var/lib/postgresql/data/postgresql.conf

[egorsmkv]

Idea: I can export SQL queries from Telescope and then apply EXPLAIN command to them and sort results

[egorsmkv]

Dalibo’s EXPLAIN ANALYZE visualizer: https://explain.dalibo.com/

[egorsmkv]

temboard:

• https://raw.githubusercontent.com/dalibo/temboard/master/docker/docker-compose.yml
• https://github.com/dalibo/temboard/issues/1327