[fpc-other] PostgreSQL index tuning

Marco van de Voort fpc at pascalprogramming.org
Sat Sep 25 16:19:25 CEST 2021

Op 25-9-2021 om 16:00 schreef Graeme Geldenhuys via fpc-other:
> 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


More information about the fpc-other mailing list