On 25/09/2021 16:00, Graeme Geldenhuys via fpc-other wrote:
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
_______________________________________________
fpc-other maillist - fpc-other@lists.freepascal.org
https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-other
