Re: Slow response to my query
| От | Steven Pousty |
|---|---|
| Тема | Re: Slow response to my query |
| Дата | |
| Msg-id | CAKmB1PGVTk=mEoLA2O4ZqsbmW3RDDriYXJhKsk75+BpvcLSDdw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Slow response to my query (Bzzzz <lazyvirus@gmx.com>) |
| Ответы |
Re: Slow response to my query
|
| Список | pgsql-novice |
Sounds like you should do an
EXPLAIN
in front of your query and see what the query planner is thinking. If you can spare the 1.5 hours do an EXPLAIN ANALYZE. It should be safe as long as you are only doing a select query.
Thanks
Steve
On Thu, Nov 28, 2019 at 7:13 AM Bzzzz <lazyvirus@gmx.com> wrote:
On Thu, 28 Nov 2019 10:38:22 +0100
Goke Aruna <goksie@gmail.com> wrote:
> however, do you have ant specific test to run with the pgbench?
Nope, I don't have the man in mind - read it and adapt your test to your
problem.
BTW, you did not say it, but I suppose you're using rust not SSDz?
> I have about 6 of my columns indexed.
Are they involved in your query?
> I will share the test query once i got the queries from the UI man.
? Without the table and it's indexes structures plus the query, it's like
a car without an engine (or a chauffeur)…
Also, read this:
https://hakibenita.com/be-careful-with-cte-in-postgre-sql
and that:
https://www.2ndquadrant.com/en/blog/on-rocks-and-sand/
Jean-Yves
В списке pgsql-novice по дате отправления: