Re: Slow query when the select list is big

Поиск

Список

Период

Сортировка

От	Victor Yegorov
Тема	Re: Slow query when the select list is big
Дата	9 мая 2016 г. 11:14:25
Msg-id	CAGnEbogW_RtiZ_n6oA8TMRjPWrx6S8YXdsUpgZecE5Qx70pPPA@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Slow query when the select list is big ("Sterpu Victor" <victor@caido.ro>)
Список	pgsql-general

2016-05-09 11:01 GMT+03:00 Sterpu Victor <victor@caido.ro>:

I went to 2.4 seconds by joining first the tables that produce many rows.

As you're changing your query quite often, it'd be handy, if you could post both:

- new query version

- it's `EXECUTE (analyze, buffers)` output

If you provide either one or another, but not both, it is difficult to comment on your case.

You can use http://explain.depesz.com/ to post a link to your execution plan here.

Victor Y. Yegorov

В списке pgsql-general по дате отправления:

От: "Sterpu Victor"
Дата: 09 мая 2016 г., 11:02:20
Сообщение: Re: Slow query when the select list is big

От: "Sterpu Victor"
Дата: 09 мая 2016 г., 11:15:25
Сообщение: Re: Slow query when the select list is big