explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ynLg

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.075 ↓ 0.0 0 1

Sort (cost=17.19..17.20 rows=1 width=72) (actual time=0.075..0.075 rows=0 loops=1)

  • Sort Key: (((((COALESCE((SubPlan 1), '-1'::text) || '_'::text) || COALESCE((c_orderline.line)::text, '-1'::text)) || '_'::text) || COALESCE((c_orderline.linenetamt)::text, '-1'::text)))
  • Sort Method: quicksort Memory: 25kB
2. 0.066 0.066 ↓ 0.0 0 1

Index Scan using idx_c_orderline_ad_org_ad_client on c_orderline (cost=1.57..17.18 rows=1 width=72) (actual time=0.066..0.066 rows=0 loops=1)

  • Index Cond: (ad_org_id = ANY ('{0,5000007,5000003,1000001,5000005,5000000,5000002,5000001}'::numeric[]))
  • Filter: ((ad_client_id = ANY ('{0,1000000}'::numeric[])) AND ((c_orderline_id IS NULL) OR (NOT (hashed SubPlan 2))))
3.          

SubPlan (forIndex Scan)

4. 0.000 0.000 ↓ 0.0 0

Seq Scan on ad_private_access (cost=0.00..1.14 rows=1 width=7) (never executed)

  • Filter: ((ad_user_id <> '5000028'::numeric) AND (ad_table_id = '260'::numeric) AND (isactive = 'Y'::bpchar))
5. 0.000 0.000 ↓ 0.0 0

Index Scan using c_order_pkey on c_order (cost=0.42..2.65 rows=1 width=32) (never executed)

  • Index Cond: (c_orderline.c_order_id = c_order_id)