explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Hw6C

Settings
# exclusive inclusive rows x rows loops node
1. 4,894.771 5,230.363 ↑ 2.5 6,277 1

Hash Join (cost=1,058,897.49..1,210,807.39 rows=15,536 width=32) (actual time=336.897..5,230.363 rows=6,277 loops=1)

  • Hash Cond: (pc.candidate_id = candidate_extension.candidate_id)
2. 7.364 9.375 ↓ 1.0 28,057 1

Bitmap Heap Scan on position_candidate pc (cost=528.11..3,106.42 rows=27,831 width=20) (actual time=2.263..9.375 rows=28,057 loops=1)

  • Recheck Cond: (rejected_date IS NOT NULL)
  • Heap Blocks: exact=1676
3. 2.011 2.011 ↓ 1.0 28,057 1

Bitmap Index Scan on position_candidate_rejected_timestamp__idx (cost=0.00..521.15 rows=27,831 width=0) (actual time=2.011..2.011 rows=28,057 loops=1)

  • Index Cond: (rejected_date IS NOT NULL)
4. 96.841 326.217 ↑ 748.9 27,356 1

Hash (cost=662,248.20..662,248.20 rows=20,486,255 width=28) (actual time=326.217..326.217 rows=27,356 loops=1)

  • Buckets: 65536 Batches: 512 Memory Usage: 524kB
5. 24.767 229.376 ↑ 748.9 27,356 1

Hash Join (cost=21.85..662,248.20 rows=20,486,255 width=28) (actual time=0.293..229.376 rows=27,356 loops=1)

  • Hash Cond: ((unnest(candidate_extension.candidate_owner_ids)) = ua.id)
6. 139.593 204.375 ↑ 98.3 373,321 1

ProjectSet (cost=0.00..197,269.41 rows=36,698,400 width=12) (actual time=0.037..204.375 rows=373,321 loops=1)

7. 64.782 64.782 ↑ 1.0 366,115 1

Seq Scan on candidate_extension (cost=0.00..11,025.03 rows=366,984 width=33) (actual time=0.030..64.782 rows=366,115 loops=1)

  • Filter: (candidate_owner_ids IS NOT NULL)
  • Rows Removed by Filter: 26088
8. 0.052 0.234 ↑ 1.0 139 1

Hash (cost=20.11..20.11 rows=139 width=20) (actual time=0.234..0.234 rows=139 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
9. 0.182 0.182 ↑ 1.0 139 1

Seq Scan on user_account ua (cost=0.00..20.11 rows=139 width=20) (actual time=0.012..0.182 rows=139 loops=1)

  • Filter: ((deleted_timestamp IS NULL) AND (id <> '-10'::integer))
  • Rows Removed by Filter: 110