explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2kIx

Settings
# exclusive inclusive rows x rows loops node
1. 107.939 219.149 ↑ 1.3 12,603 1

HashAggregate (cost=178,589.37..178,753.21 rows=16,384 width=16) (actual time=214.569..219.149 rows=12,603 loops=1)

  • Group Key: image_id
2. 87.134 111.210 ↑ 1.7 229,380 1

Bitmap Heap Scan on page_matches (cost=15,257.35..176,665.08 rows=384,858 width=8) (actual time=27.191..111.210 rows=229,380 loops=1)

  • Recheck Cond: ((organisation_id = 8) AND (rematched IS NULL))
  • Heap Blocks: exact=18452
3. 24.076 24.076 ↑ 1.7 229,437 1

Bitmap Index Scan on index_page_matches_domain_counts (cost=0.00..15,161.14 rows=384,858 width=0) (actual time=24.076..24.076 rows=229,437 loops=1)

  • Index Cond: ((organisation_id = 8) AND (rematched IS NULL))
Planning time : 2.973 ms
Execution time : 221.589 ms