[fpc-other] PostgreSQL index tuning

Martin Frb lazarus at mfriebe.de
Sat Sep 25 16:21:39 CEST 2021

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

To watch a running server (via logfile)

and I think pgAdmin has some nice visualization

More information about the fpc-other mailing list