Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / fpc-other / 2021-09

PostgreSQL index tuning

4 messages · 4 people ·

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Graeme Geldenhuys

Hi,

Does anybody know if there is a tool I could use to analyse queries to a PostgreSQL database, so I could tune it's performance. eg: detect table scans in the execution plan, suggest creating, dropping or altering indexes etc.

MS SQL server comes with loads of tools and options to do this, but I'm fairly new to using PostgreSQL as the data store, so not sure what tools are out there. Any suggestions would me much appreciated.

Regards,
Graeme

fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal http://fpgui.sourceforge.net/ My public PGP key: http://tinyurl.com/graeme-pgp

Reply by email

Marco van de Voort
to Graeme Geldenhuys

Op 25-9-2021 om 16:00 schreef Graeme Geldenhuys via fpc-other:

Show quoted text 9 lines
Does anybody know if there is a tool I could use to analyse queries to a PostgreSQL database, so I could tune it's performance. eg: detect table scans in the execution plan, suggest creating, dropping or altering indexes etc. MS SQL server comes with loads of tools and options to do this, but I'm fairly new to using PostgreSQL as the data store, so not sure what tools are out there. Any suggestions would me much appreciated.

The default postgres admin too "pgadmin" seems to have some query analysis that yields plan insights according to

https://www.pgadmin.org/docs/pgadmin4/5.2/query_tool.html

Reply by email

Martin Frb
to Graeme Geldenhuys: Does anybody know if there is a tool I could use to analyse queries to a PostgreSQL…
Graeme Geldenhuys wrote 11 lines
Hi, Does anybody know if there is a tool I could use to analyse queries to a PostgreSQL database, so I could tune it's performance. eg: detect table scans in the execution plan, suggest creating, dropping or altering indexes etc. MS SQL server comes with loads of tools and options to do this, but I'm fairly new to using PostgreSQL as the data store, so not sure what tools are out there. Any suggestions would me much appreciated.

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

To watch a running server (via logfile)
https://www.postgresql.org/docs/current/auto-explain.html

and I think pgAdmin has some nice visualization
https://www.pgadmin.org/
https://www.pgadmin.org/screenshots/#10

Reply by email

Martin
to Graeme Geldenhuys: Does anybody know if there is a tool I could use to analyse queries to a PostgreSQL…
Graeme Geldenhuys wrote 11 lines
Hi, Does anybody know if there is a tool I could use to analyse queries to a PostgreSQL database, so I could tune it's performance. eg: detect table scans in the execution plan, suggest creating, dropping or altering indexes etc. MS SQL server comes with loads of tools and options to do this, but I'm fairly new to using PostgreSQL as the data store, so not sure what tools are out there. Any suggestions would me much appreciated.

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

To watch a running server (via logfile)
https://www.postgresql.org/docs/current/auto-explain.html

and I think pgAdmin has some nice visualization
https://www.pgadmin.org/
https://www.pgadmin.org/screenshots/#10

Reply by email