Re: sql execution time in pg_stat_statements

2021-09-10 Thread Julien Rouhaud
On Sat, Sep 11, 2021 at 1:12 AM Michel SALAIS wrote: > > I thaught that total_time (total_exec_time + total_plan_time) included I/O > but when we have blk_read_time + blk_write_time equals several times > total_time it is difficult to continue to think that... Maybe not that difficult. If

Re: sql execution time in pg_stat_statements

2021-09-10 Thread Tom Lane
"Michel SALAIS" writes: > I thaught that total_time (total_exec_time + total_plan_time) included I/O > but when we have blk_read_time + blk_write_time equals several times > total_time it is difficult to continue to think that... That's an interesting report, but on the whole I'd be more

RE: sql execution time in pg_stat_statements

2021-09-10 Thread Michel SALAIS
-Message d'origine- De : Julien Rouhaud Envoyé : vendredi 10 septembre 2021 07:18 À : Michel SALAIS Cc : postgres performance list Objet : Re: sql execution time in pg_stat_statements On Fri, Sep 10, 2021 at 2:49 AM Michel SALAIS wrote: > > I think that total_time in

Re: PostgreSql 9.4 Database connection failure

2021-09-10 Thread Ranier Vilela
Em sex., 10 de set. de 2021 às 06:26, Lionel Napoleon < lionelnapol...@hotmail.com> escreveu: > Hi , > Hi, please when you post, choose to post to all. I was able to rectify most of the problems since they were from my > application side bugs. > Good to know. However the following entry