explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4HPI

Settings
# exclusive inclusive rows x rows loops node
1. 17.797 254.836 ↑ 3.4 21,908 1

Unique (cost=14,751.15..18,650.91 rows=74,281 width=246) (actual time=233.317..254.836 rows=21,908 loops=1)

  • Buffers: local read=2448
2. 213.544 237.039 ↑ 3.4 21,908 1

Sort (cost=14,751.15..14,936.86 rows=74,281 width=246) (actual time=233.313..237.039 rows=21,908 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: 6152kB
  • Buffers: local read=2448
3. 23.495 23.495 ↑ 3.4 21,908 1

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

  • Buffers: local read=2448