RE: sql execution time in pg_stat_statements

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Just to say that for PostgreSQL 13, total_time is replaced by “total_exec_time + total_plan_time”

 

Michel SALAIS

De : Michel SALAIS <msalais@xxxxxxx>
Envoyé : jeudi 9 septembre 2021 20:14
À : pgsql-performance@xxxxxxxxxxxxxx
Objet : sql execution time in pg_stat_statements

 

Hi all,

 

I think that total_time in pg_stat_statements is cpu time + possible waits. So, can I say that:

Total_sql_time = total_time + blk_read_time + blk_write_time

 

Documentation is not clear at all on that.

 

Thanks in advance

 

Michel SALAIS


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux