explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kbkf

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 2,784.499 ↑ 1.0 20 1

Limit (cost=213,624.74..213,624.79 rows=20 width=640) (actual time=2,784.495..2,784.499 rows=20 loops=1)

2. 13.909 2,784.496 ↑ 1,306.2 20 1

Sort (cost=213,624.74..213,690.05 rows=26,123 width=640) (actual time=2,784.494..2,784.496 rows=20 loops=1)

  • Sort Key: (count(*)) DESC
  • Sort Method: top-N heapsort Memory: 2965kB
3. 1,680.448 2,770.587 ↓ 1.5 40,150 1

GroupAggregate (cost=207,861.93..212,929.62 rows=26,123 width=640) (actual time=855.990..2,770.587 rows=40,150 loops=1)

  • Group Key: project_id, finish_domain, (COALESCE(webmaster, btag))
4. 923.471 1,090.139 ↓ 1.0 230,957 1

Sort (cost=207,861.93..208,438.24 rows=230,527 width=742) (actual time=854.061..1,090.139 rows=230,957 loops=1)

  • Sort Key: project_id, finish_domain, (COALESCE(webmaster, btag))
  • Sort Method: external merge Disk: 57544kB
5. 166.668 166.668 ↓ 1.0 230,957 1

Seq Scan on links (cost=0.00..36,044.22 rows=230,527 width=742) (actual time=0.033..166.668 rows=230,957 loops=1)

  • Filter: ((created_at >= '2019-02-08 00:00:00'::timestamp without time zone) AND (created_at <= '2019-03-09 23:59:59'::timestamp without time zone) AND (project_id = ANY ('{5,4,2,3,1}'::integer[])))
  • Rows Removed by Filter: 30260