Mailing lists [pgsql-performance]

4 April 2023

• 09:21   Explain plan shows fewer shared blocks when index+table compared to index alone? Amin Jaffer
• 10:51   Re:Explain plan shows fewer shared blocks when index+table compared to index alone? Sergei Kornilov
• 17:46   Why are commits consuming most of the database time? Tim Slechta
• 17:57   Re: Why are commits consuming most of the database time? Tom Lane
• 23:24   Re: Why are commits consuming most of the database time? Tim Slechta

6 April 2023

• 13:23   Query unable to utilize index without typecast to fixed length character ahi
• 17:50   Re: Query unable to utilize index without typecast to fixed length character Tom Lane

7 April 2023

• 10:09   Re: Query unable to utilize index without typecast to fixed length character ahi
• 20:57   Is there any tool which will help me run and explain analyze about 150 queries? kunwar singh
• 21:19   Re: Is there any tool which will help me run and explain analyze about 150 queries? Achilleas Mantzios
• 21:40   Re: Is there any tool which will help me run and explain analyze about 150 queries? kyle Hailey
• 23:48   Re: Is there any tool which will help me run and explain analyze about 150 queries? kunwar singh

8 April 2023

• 07:40   Re: Is there any tool which will help me run and explain analyze about 150 queries? Jerry Sievers
• 20:58   RE: Query unable to utilize index without typecast to fixed length character 

9 April 2023

• 00:44   Re: Is there any tool which will help me run and explain analyze about 150 queries? kyle Hailey

10 April 2023

• 01:15   Re: Is there any tool which will help me run and explain analyze about 150 queries? kunwar singh

11 April 2023

• 06:39   Re: Replication lag due to lagging restart_lsn milist ujang

12 April 2023

• 12:17   Re: Is there any tool which will help me run and explain analyze about 150 queries? Michael Christofides

15 April 2023

• 13:41   Re: Replication lag due to lagging restart_lsn milist ujang
• 14:04   Postgres Metrics André Rodrigues
• 17:53   Re: Postgres Metrics Joe Conway

16 April 2023

• 20:00   speeding up grafana sensor-data query on raspberry pi 3 Clemens Eisserer
• 20:15   Re: speeding up grafana sensor-data query on raspberry pi 3 Justin Pryzby
• 23:50   Re: speeding up grafana sensor-data query on raspberry pi 3 David Rowley

17 April 2023

• 01:10   Re: speeding up grafana sensor-data query on raspberry pi 3 Andres Freund
• 22:06   Re: speeding up grafana sensor-data query on raspberry pi 3 Luiz Felipph

18 April 2023

• 03:25   Re: time sorted UUIDs peter plachta
• 03:35   High QPS, random index writes and vacuum peter plachta
• 03:38   Re: High QPS, random index writes and vacuum Peter Geoghegan
• 05:01   Re: High QPS, random index writes and vacuum Tom Lane
• 05:40   Re: High QPS, random index writes and vacuum David Rowley
• 05:43   Re: High QPS, random index writes and vacuum peter plachta
• 05:44   Re: High QPS, random index writes and vacuum peter plachta
• 05:49   Re: High QPS, random index writes and vacuum Thomas Munro
• 05:52   Re: High QPS, random index writes and vacuum Peter Geoghegan
• 15:14   Re: speeding up grafana sensor-data query on raspberry pi 3 Clemens Eisserer

20 April 2023

• 16:37   What is equivalent of v$sesstat and v$sql_plan in postgres? kunwar singh
• 16:40   Re: What is equivalent of v$sesstat and v$sql_plan in postgres? MichaelDBA
• 19:39   Re: speeding up grafana sensor-data query on raspberry pi 3 Clemens Eisserer

22 April 2023

• 18:28   How do Monitoring tools capture explain plan of a query kunwar singh
• 19:17   Re: How do Monitoring tools capture explain plan of a query kyle Hailey

23 April 2023

• 22:28   Re: How do Monitoring tools capture explain plan of a query kunwar singh

24 April 2023

• 11:23   Re: Postgres Metrics Jesper Pedersen

28 April 2023

• 15:19   Performance issues in query with multiple joins Παρασκευη Πασσαρη
• 16:03   Performance issues in query with multiple joins David G. Johnston
• 17:07   Re: Performance issues in query with multiple joins Tom Lane