explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5Iv2

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 34.897 ↓ 0.0 0 1

ModifyTable (cost=4,981.12..210,929.95 rows=59,141 width=257) (actual time=34.897..34.897 rows=0 loops=1)

  • Buffers: shared hit=295, local hit=1 read=2447
2. 0.001 34.895 ↓ 0.0 0 1

Nested Loop (cost=4,981.12..210,929.95 rows=59,141 width=257) (actual time=34.895..34.895 rows=0 loops=1)

  • Buffers: shared hit=295, local hit=1 read=2447
3. 0.332 34.894 ↓ 0.0 0 1

Aggregate (cost=4,980.56..5,498.5 rows=51,794 width=36) (actual time=34.893..34.894 rows=0 loops=1)

  • Buffers: shared hit=295, local hit=1 read=2447
4. 6.045 34.562 ↓ 0.0 0 1

Hash Join (cost=865.83..4,851.08 rows=51,794 width=36) (actual time=34.562..34.562 rows=0 loops=1)

  • Buffers: shared hit=295, local hit=1 read=2447
5. 16.931 16.931 ↑ 3.4 21,908 1

Seq Scan on _import_sale iss (cost=0..3,190.81 rows=74,281 width=46) (actual time=3.757..16.931 rows=21,908 loops=1)

  • Buffers: local hit=1 read=2447
6. 5.915 11.586 ↑ 1.0 24,733 1

Hash (cost=548.7..548.7 rows=25,370 width=22) (actual time=11.586..11.586 rows=24,733 loops=1)

  • Buffers: shared hit=295
7. 5.671 5.671 ↑ 1.0 24,733 1

Seq Scan on import_sale_error se (cost=0..548.7 rows=25,370 width=22) (actual time=0.01..5.671 rows=24,733 loops=1)

  • Buffers: shared hit=295
8. 0.000 0.000 ↓ 0.0 0 0

Index Scan using sale_sale_number_idx on sale sale (cost=0.56..3.95 rows=1 width=233) (never executed)

  • Index Cond: ((sale.sale_number)::text = iss.sale_number)
  • Filter: upper_inf(sale.active_range)