Re: Query takes around 15 to 20 min over 20Lakh rows

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Shubham Mittal <mittalshubham30(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Query takes around 15 to 20 min over 20Lakh rows
Date: 2021-09-02 22:27:14
Message-ID: CAHOFxGoQiwFLqTdwOebiL6dQZhgvUiV7MwbxK+JqZK8kht5HAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What is T and how many rows are in there? How many rows in task_history?
What indexes exist? Are you confident you want 2 million rows in that
result set? What version is this on? What pg_settings have been changed
from defaults?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-09-02 23:00:46 Re: dup(0) fails on Ubuntu 20.04 and macOS 10.15 with 13.0
Previous Message Shubham Mittal 2021-09-02 22:15:32 Query takes around 15 to 20 min over 20Lakh rows