explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UIrO : Optimization for: plan #cqIv

Settings

Optimization path:

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

Sort (cost=2.03..2.08 rows=20 width=161) (actual rows= loops=)

  • Sort Key: (CASE WHEN ((type)::text = 'BP'::text) THEN '1'::text WHEN ((type)::text = 'BO'::text) THEN '1'::text WHEN ((type)::text = 'BG'::text) THEN '1'::text WHEN ((type)::text = 'BW'::text) THEN '1'::text WHEN ((type)::text = 'BT'::text) THEN '1'::text WHEN ((type)::text = 'PF'::text) THEN '1'::text WHEN ((type)::text = 'GSM'::text) THEN '2'::text WHEN ((type)::text = 'QA'::text) THEN '3'::text ELSE NULL::text END), requester_id, request_time, process_start_time
2. 0.000 0.000 ↓ 0.0

Seq Scan on task (cost=0.00..1.60 rows=20 width=161) (actual rows= loops=)