explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y8al

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

Limit (cost=305,716.71..305,723.71 rows=60 width=1,731) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=305,716.71..335,353.28 rows=254,010 width=1,731) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Sort (cost=304,716.69..305,034.20 rows=127,005 width=1,731) (actual rows= loops=)

  • Sort Key: ttna NULLS FIRST
4. 0.000 0.000 ↓ 0.0

Parallel Index Scan using index_shipments_on_type on shipments (cost=0.56..300,330.64 rows=127,005 width=1,731) (actual rows= loops=)

  • Index Cond: ((type)::text = 'SingleShipment'::text)
  • Filter: (NOT is_quote)