Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries
| От | bruno da silva |
|---|---|
| Тема | Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries |
| Дата | |
| Msg-id | CAB+Nuk9_xmFc0js-JCOiUqQJL978FA4udD4yr4b9ha=3bUj59g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries
|
| Список | pgsql-performance |
Do you have a lot of especially long statements being tracked
in the pg_stat_statements view? well, the view was showing the query column null.
in the pg_stat_statements view? well, the view was showing the query column null.
but looking on pgss_query_texts.stat there are very large sql statements, of around ~ 400kb, multiple thousands.
Are there any other signs of distress
in the postmaster log, like complaints about being unable to write
pgss_query_texts.stat? no, just complaints for reading it.
in the postmaster log, like complaints about being unable to write
pgss_query_texts.stat? no, just complaints for reading it.
Thanks
On Tue, Aug 2, 2022 at 11:59 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
bruno da silva <brunogiovs@gmail.com> writes:
> After more investigation, we found that pgss_query_texts.stat of a size of
> 2.2GB. and this deployment has a 32bit pg.
Hm ... we've heard one previous report of pg_stat_statements' query text
file getting unreasonably large, but it's not clear how that can come
to be. Do you have a lot of especially long statements being tracked
in the pg_stat_statements view? Are there any other signs of distress
in the postmaster log, like complaints about being unable to write
pgss_query_texts.stat?
regards, tom lane
Bruno da Silva
В списке pgsql-performance по дате отправления: