Search Postgresql Archives
Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Fri, 19 Feb 2021 17:38:39 -0700
Cc
: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to
: <
CAADeyWihs2wwUmyUJmEav20sXUanp8P9BpJMQVUApoBQV-HMgg@mail.gmail.com
>
References
: <
CAADeyWihs2wwUmyUJmEav20sXUanp8P9BpJMQVUApoBQV-HMgg@mail.gmail.com
>
Your explain analyze is showing an example that runs in less than 15ms, and your logs indicate queries taking 2-3 seconds. I am missing part of the picture here. Can you clarify?
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
From:
Alexander Farber
References
:
Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
From:
Alexander Farber
Prev by Date:
Re: Error with pg_dump (of data), with --role
Next by Date:
Re: Error with pg_dump (of data), with --role
Previous by thread:
Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
Next by thread:
Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
