Date: Thu, 10 Jun 2021 09:33:46 -0500
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
Message-ID: <20210610143346.GF16435@telsasoft.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>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAC6p5nf1XCiDw7hz9jK1L=nYy+jmC6OVrscxcgt=S0nqg9E8gg@mail.gmail.com>
User-Agent: Mutt/1.9.4 (2018-02-28)
Archived-At: 
 <https://www.postgresql.org/message-id/20210610143346.GF16435%40telsasoft.com>
Precedence: bulk

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