explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mxyE

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

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

  • Buffers: shared hit=1085773 read=140538, temp read=52708 written=52678
2. 175.867 10,001.206 ↑ 1.7 224,203 1

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

  • Hash Cond: (operation.session_id = s.id)
  • Buffers: shared hit=187666 read=140538, temp read=52708 written=52678
3. 2,003.977 9,285.901 ↑ 1.7 224,203 1

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

  • Hash Cond: (operation.rpi_id = r.id)
  • Buffers: shared hit=174432 read=140538, temp read=52708 written=52678
4. 589.572 686.889 ↓ 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.873..686.889 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. 97.317 97.317 ↓ 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=97.317..97.317 rows=779,239 loops=1)

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

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

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

  • Buffers: shared hit=164 read=140538
8. 249.250 539.438 ↑ 1.0 565,118 1

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

  • Buckets: 1048576 Batches: 1 Memory Usage: 35123kB
  • Buffers: shared hit=13234
9. 290.188 290.188 ↑ 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..290.188 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