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
