explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DYD8

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

Limit (cost=133.05..133.05 rows=1 width=12) (actual time=0.025..0.025 rows=0 loops=1)

2. 0.005 0.023 ↓ 0.0 0 1

Sort (cost=133.05..133.06 rows=2 width=12) (actual time=0.023..0.023 rows=0 loops=1)

  • Sort Key: (CASE WHEN (location = 'CW'::bpchar) THEN 0 ELSE 1 END)
  • Sort Method: quicksort Memory: 25kB
3. 0.018 0.018 ↓ 0.0 0 1

Index Scan using stock_supplier_code_upper_trim_idx on stock (cost=0.43..133.04 rows=2 width=12) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (upper(btrim((supplier_code)::text)) = 'LEDEDP36'::text)
  • Filter: ((supplier)::text = 'MLA'::text)