explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XWzJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=4,369.36..4,370.48 rows=112 width=320) (actual rows= loops=)

  • Group Key: mr.id, mr.job_id, mr.matched_compared_result_id, mr.trusted_rpc, mr.trusted_upc, cr.img_hash
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=97.55..4,367.68 rows=112 width=320) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on img_matched_results mr (cost=97.01..2,597.37 rows=147 width=312) (actual rows= loops=)

  • Recheck Cond: (job_id = '689260'::bigint)
  • Filter: (is_secondary AND (matched_compared_result_id IS NOT NULL) AND (s3_img_url IS NOT NULL) AND (img_checksum IS NOT NULL) AND (NOT is_img_unchanged) AND (NOT is_reviewed))
4. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (job_id = '689260'::bigint)
5. 0.000 0.000 ↓ 0.0

Index Scan using idx_img_compared_results_on_img_matched_results_id_s3_img_url on img_compared_results cr (cost=0.54..12.03 rows=1 width=24) (actual rows= loops=)

  • Index Cond: (img_matched_results_id = mr.id)
  • Filter: (img_hash IS NOT NULL)