explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ouKs

Settings
# exclusive inclusive rows x rows loops node
1. 337.418 11,063.130 ↑ 1.7 224,203 1

Nested Loop (cost=389,327.37..1,057,533.63 rows=385,229 width=87) (actual time=7,417.868..11,063.130 rows=224,203 loops=1)

  • Buffers: shared hit=1085677 read=140634, temp read=52708 written=52678
2. 175.387 9,828.900 ↑ 1.7 224,203 1

Hash Join (cost=389,326.93..771,277.07 rows=385,229 width=55) (actual time=7,417.845..9,828.900 rows=224,203 loops=1)

  • Hash Cond: (operation.session_id = s.id)
  • Buffers: shared hit=187570 read=140634, temp read=52708 written=52678
3. 1,711.734 9,115.934 ↑ 1.7 224,203 1

Hash Join (cost=363,315.61..739,972.59 rows=389,464 width=51) (actual time=6,876.845..9,115.934 rows=224,203 loops=1)

  • Hash Cond: (operation.rpi_id = r.id)
  • Buffers: shared hit=174336 read=140634, temp read=52708 written=52678
4. 574.989 677.233 ↓ 1.4 536,093 1

Bitmap Heap Scan on operation (cost=14,468.68..320,823.48 rows=389,464 width=16) (actual time=146.349..677.233 rows=536,093 loops=1)

  • Recheck Cond: (operation_type = 5)
  • Filter: (invoice_id IS NOT NULL)
  • Rows Removed by Filter: 243146
  • Heap Blocks: exact=172136
  • Buffers: shared hit=174268
5. 102.244 102.244 ↓ 1.0 779,239 1

Bitmap Index Scan on idx_operation_type (cost=0.00..14,371.32 rows=777,984 width=0) (actual time=102.244..102.244 rows=779,239 loops=1)

  • Index Cond: (operation_type = 5)
  • Buffers: shared hit=2132
6. 3,211.793 6,726.967 ↑ 1.0 6,652,308 1

Hash (cost=207,225.08..207,225.08 rows=6,652,308 width=43) (actual time=6,726.967..6,726.967 rows=6,652,308 loops=1)

  • Buckets: 1048576 Batches: 16 Memory Usage: 40720kB
  • Buffers: shared hit=68 read=140634, temp written=51733
7. 3,515.174 3,515.174 ↑ 1.0 6,652,308 1

Seq Scan on session_rpi r (cost=0.00..207,225.08 rows=6,652,308 width=43) (actual time=0.089..3,515.174 rows=6,652,308 loops=1)

  • Buffers: shared hit=68 read=140634
8. 243.321 537.579 ↑ 1.0 565,118 1

Hash (cost=18,947.32..18,947.32 rows=565,120 width=20) (actual time=537.579..537.579 rows=565,118 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 35123kB
  • Buffers: shared hit=13234
9. 294.258 294.258 ↑ 1.0 565,118 1

Seq Scan on session s (cost=0.00..18,947.32 rows=565,120 width=20) (actual time=0.010..294.258 rows=565,118 loops=1)

  • Filter: (finished_at IS NOT NULL)
  • Rows Removed by Filter: 6214
  • Buffers: shared hit=13234
10. 896.812 896.812 ↑ 1.0 1 224,203

Index Scan using rpi_assignment_pkey on rpi_assignment ra (cost=0.44..0.73 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=224,203)

  • Index Cond: (id = r.assignment_id)
  • Buffers: shared hit=898107