Home > mailing lists

Re: Slow query when the select list is big - Mailing list pgsql-general

From	Victor Yegorov
Subject	Re: Slow query when the select list is big
Date	May 9, 2016 11:14:25
Msg-id	CAGnEbogW_RtiZ_n6oA8TMRjPWrx6S8YXdsUpgZecE5Qx70pPPA@mail.gmail.com Whole thread Raw
In response to	Re: Slow query when the select list is big ("Sterpu Victor" <victor@caido.ro>)
List	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

From: "Sterpu Victor"
Date: 09 May 2016, 11:02:20
Subject: Re: Slow query when the select list is big

From: "Sterpu Victor"
Date: 09 May 2016, 11:15:25
Subject: Re: Slow query when the select list is big