explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ox9b

Settings
# exclusive inclusive rows x rows loops node
1. 485.588 387,860.536 ↑ 1.7 224,203 1

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

  • Buffers: shared hit=831527 read=394784, temp read=52708 written=52678
2. 274.744 106,896.995 ↑ 1.7 224,203 1

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

  • Hash Cond: (operation.session_id = s.id)
  • Buffers: shared hit=16164 read=312040, temp read=52708 written=52678
3. 1,817.043 106,082.641 ↑ 1.7 224,203 1

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

  • Hash Cond: (operation.rpi_id = r.id)
  • Buffers: shared hit=2930 read=312040, temp read=52708 written=52678
4. 97,523.558 97,623.098 ↓ 1.4 536,093 1

Bitmap Heap Scan on operation (cost=14,468.68..320,823.48 rows=389,464 width=16) (actual time=143.729..97,623.098 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=2894 read=171374
5. 99.540 99.540 ↓ 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=99.540..99.540 rows=779,239 loops=1)

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

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

  • Buckets: 1048576 Batches: 16 Memory Usage: 40720kB
  • Buffers: shared hit=36 read=140666, temp written=51733
7. 3,489.893 3,489.893 ↑ 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.098..3,489.893 rows=6,652,308 loops=1)

  • Buffers: shared hit=36 read=140666
8. 246.171 539.610 ↑ 1.0 565,118 1

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

  • Buckets: 1048576 Batches: 1 Memory Usage: 35123kB
  • Buffers: shared hit=13234
9. 293.439 293.439 ↑ 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..293.439 rows=565,118 loops=1)

  • Filter: (finished_at IS NOT NULL)
  • Rows Removed by Filter: 6214
  • Buffers: shared hit=13234
10. 280,477.953 280,477.953 ↑ 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=1.251..1.251 rows=1 loops=224,203)

  • Index Cond: (id = r.assignment_id)
  • Buffers: shared hit=815363 read=82744
Planning time : 1.466 ms
Execution time : 387,921.325 ms