Re: Slow query when the select list is big

From: Victor Yegorov <vyegorov(at)gmail(dot)com>
To: Sterpu Victor <victor(at)caido(dot)ro>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Slow query when the select list is big
Date: 2016-05-09 08:14:20
Message-ID: CAGnEbogW_RtiZ_n6oA8TMRjPWrx6S8YXdsUpgZecE5Qx70pPPA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2016-05-09 11:01 GMT+03:00 Sterpu Victor <victor(at)caido(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sterpu Victor 2016-05-09 08:15:09 Re: Slow query when the select list is big
Previous Message Sterpu Victor 2016-05-09 08:01:56 Re: Slow query when the select list is big