Re: Big variance in execution times of simple queries

2022-01-24 Thread Tom Lane
Hannes Erven writes: > I'm looking at a "SELECT * FROM pg_stat_statements" output and am > puzzled by the huge differences between min/max_exec_time even for > simple queries. > The most extreme example is probably the statement used by the > application's connection health check: > SELECT 1 >

Big variance in execution times of simple queries

2022-01-24 Thread Hannes Erven
Hi community, I'm looking at a "SELECT * FROM pg_stat_statements" output and am puzzled by the huge differences between min/max_exec_time even for simple queries. The most extreme example is probably the statement used by the application's connection health check: SELECT 1 min=0.001, mean