[fpc-other] PostgreSQL index tuning

[Martin]

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