explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l8Ol

Settings
# exclusive inclusive rows x rows loops node
1. 6.605 31.173 ↓ 0.0 0 1

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

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

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

  • Buffers: local hit=1 read=2447
3. 5.611 10.603 ↑ 1.0 24,733 1

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

  • Buffers: shared hit=295
4. 4.992 4.992 ↑ 1.0 24,733 1

Seq Scan on import_sale_error se (cost=0..548.7 rows=25,370 width=16) (actual time=0.009..4.992 rows=24,733 loops=1)

  • Buffers: shared hit=295