explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cqIv

Settings

Optimization(s) for this plan:

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

Sort (cost=1.93..1.98 rows=20 width=161) (actual rows= loops=)

  • Sort Key: (CASE WHEN ((type)::text = 'BP'::text) THEN '1'::text WHEN ((type)::text = ANY ('{BP,BO,BW,BT,PF,BG}'::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.50 rows=20 width=161) (actual rows= loops=)