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 по дате отправления:

Предыдущее
От: Bzzzz
Дата:
Сообщение: Re: Slow response to my query
Следующее
От: Goke Aruna
Дата:
Сообщение: Re: Slow response to my query