explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jLjN

Settings
# exclusive inclusive rows x rows loops node
1. 30.261 55.540 ↓ 1.2 6,702 1

Hash Right Join (cost=2,639.29..6,410.37 rows=5,473 width=320) (actual time=5.832..55.540 rows=6,702 loops=1)

  • Hash Cond: (cr.img_matched_results_id = mr.id)
2. 21.162 21.162 ↓ 1.1 90,691 1

Seq Scan on img_compared_results cr (cost=0.00..3,395.80 rows=85,480 width=24) (actual time=0.002..21.162 rows=90,691 loops=1)

3. 1.753 4.117 ↓ 1.1 3,557 1

Hash (cost=2,598.16..2,598.16 rows=3,291 width=312) (actual time=4.117..4.117 rows=3,557 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 850kB
4. 2.113 2.364 ↓ 1.1 3,557 1

Bitmap Heap Scan on img_matched_results mr (cost=97.80..2,598.16 rows=3,291 width=312) (actual time=0.274..2.364 rows=3,557 loops=1)

  • Recheck Cond: (job_id = '689260'::bigint)
  • Filter: (is_secondary AND (matched_compared_result_id IS NOT NULL))
  • Heap Blocks: exact=199
5. 0.251 0.251 ↓ 1.2 3,926 1

Bitmap Index Scan on idx_img_matched_results_on_job_id (cost=0.00..96.97 rows=3,291 width=0) (actual time=0.251..0.251 rows=3,926 loops=1)

  • Index Cond: (job_id = '689260'::bigint)