Re: [fpc-other] PostgreSQL index tuning

2021-09-25 Thread Martin via fpc-other
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

Re: [fpc-other] PostgreSQL index tuning

2021-09-25 Thread Martin Frb via fpc-other
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

Re: [fpc-other] PostgreSQL index tuning

2021-09-25 Thread Marco van de Voort via fpc-other
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

[fpc-other] PostgreSQL index tuning

2021-09-25 Thread Graeme Geldenhuys via fpc-other
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,