From: | bruno da silva <brunogiovs(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries |
Date: | 2022-08-02 17:58:02 |
Message-ID: | CAB+Nuk-ELR1r3T5-mL4M_J3Ci-A2oorzV8haiofDbHLAJ+FEFA@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hello.
Are you quite sure this is a 9.5.21 version of the pg_stat_statements
extension? *I got version 1.3 from SELECT * FROM pg_extension;*
Is it possible that the pg_stat_tmp directory has been made non-writable? *hard
to tell if it was made non-writable during the outage. but now it is
writable.*
Thanks
On Tue, Aug 2, 2022 at 1:25 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> bruno da silva <brunogiovs(at)gmail(dot)com> writes:
> > 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.*
> > * but looking on pgss_query_texts.stat there are very large sql
> > statements, of around ~ 400kb, multiple thousands. *
>
> Hm. We try to recover from such failures by (a) resetting all the view's
> query text fields to null and (b) truncating the file --- well, unlinking
> it and creating it as empty. It seems like (a) happened and (b) didn't.
> It's pretty hard to explain that from the code though. Are you quite
> sure this is a 9.5.21 version of the pg_stat_statements extension?
> Is it possible that the pg_stat_tmp directory has been made non-writable?
>
> regards, tom lane
>
>
>
>
> > 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. *
>
> > Thanks
>
> > On Tue, Aug 2, 2022 at 11:59 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> >> bruno da silva <brunogiovs(at)gmail(dot)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
>
>
--
Bruno da Silva
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2022-08-02 19:14:39 | Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries |
Previous Message | Tom Lane | 2022-08-02 17:25:33 | Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries |