explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZBfO

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 31.447 ↓ 0.0 0 1

Unique (cost=12,776.68..15,495.86 rows=51,794 width=246) (actual time=31.447..31.447 rows=0 loops=1)

  • Buffers: shared hit=14 read=293 dirtied=293, local hit=1 read=2447
2. 0.044 31.447 ↓ 0.0 0 1

Sort (cost=12,776.68..12,906.16 rows=51,794 width=246) (actual time=31.447..31.447 rows=0 loops=1)

  • Sort Key: s.client_id, s.sale_number, s.company_id, s.invoice_number, s.invoice_date, s.order_date, s.ship_date, s.sale_reporting_date, s.product_id, s.quantity, s.uom_type_id, s.price, s.reduction, s.freight, s.redistributor_company_id, s.sell_to_company_number, s.sell_to_company_name, s.broker_company_id, s.company_grouping_id, s.extended_price_broker_commission
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=14 read=293 dirtied=293, local hit=1 read=2447
3. 6.123 31.403 ↓ 0.0 0 1

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

  • Buffers: shared hit=2 read=293 dirtied=293, local hit=1 read=2447
4. 13.701 13.701 ↑ 3.4 21,908 1

Seq Scan on _import_sale s (cost=0..3,190.81 rows=74,281 width=262) (actual time=3.44..13.701 rows=21,908 loops=1)

  • Buffers: local hit=1 read=2447
5. 5.240 11.579 ↑ 1.0 24,733 1

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

  • Buffers: shared hit=2 read=293 dirtied=293
6. 6.339 6.339 ↑ 1.0 24,733 1

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

  • Buffers: shared hit=2 read=293 dirtied=293