From: Justin Pryzby <pryzby@telsasoft.com>
To: Haseeb Khan <khanhaseeb92@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Page File Size Reached Critical Threshold PostgreSQL V13
Date: Thu, 10 Jun 2021 09:33:46 -0500
Message-ID: <20210610143346.GF16435@telsasoft.com> (raw)
In-Reply-To: <CAC6p5nf1XCiDw7hz9jK1L=nYy+jmC6OVrscxcgt=S0nqg9E8gg@mail.gmail.com>
References: <20210610042853.GB16435@telsasoft.com>
<9B6997F1-1E68-41BD-9AB1-E7508CCB48B2@gmail.com>
<20210610085539.GC16435@telsasoft.com>
<CAC6p5nc5geLKe9Bq5OXdT7vDvit=PtFwFf+7WWLh1RLV-JWnmg@mail.gmail.com>
<20210610094850.GD16435@telsasoft.com>
<CAC6p5nf1XCiDw7hz9jK1L=nYy+jmC6OVrscxcgt=S0nqg9E8gg@mail.gmail.com>
Please work through the Slow Query wiki page and try to provide as much
information as possible. It's too hard to try to help if each communication
includes only a fraction of the requested information.
On Thu, Jun 10, 2021 at 04:33:51PM +0500, Haseeb Khan wrote:
> PFB the query and there are many other queries like these
>
> select
> pd.gender,
> count(1) as dispensation_counts
> from cdss_wasfaty.dispensation_fact df
> inner join cdss_wasfaty.patient_dim pd
> on df.patient_key = pd.patient_key
> inner join cdss_wasfaty.date_dim date_dim
> on df.dispensation_date_key = date_dim.date_key
> and date_dim.year IN (2020)
> group by pd.gender
>
> On Thu, Jun 10, 2021 at 2:48 PM Justin Pryzby <pryzby@telsasoft.com> wrote:
>
> > Can you give an example of a query that performed poorly?
> >
> > Send the query, and its explain (analyze,buffers,settings) for the query,
> > and schema for the relevant queries.
> >
> > > > https://wiki.postgresql.org/wiki/Slow_Query_Questions
--
Justin Pryzby
System Administrator
Telsasoft
+1-952-707-8581
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pryzby@telsasoft.com, khanhaseeb92@gmail.com, pgsql-performance@lists.postgresql.org
Subject: Re: Page File Size Reached Critical Threshold PostgreSQL V13
In-Reply-To: <20210610143346.GF16435@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox