explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BgGx

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

Limit (cost=54.80..54.80 rows=1 width=8) (actual time=0.424..0.425 rows=0 loops=1)

2. 0.036 0.423 ↓ 0.0 0 1

Sort (cost=54.80..54.80 rows=1 width=8) (actual time=0.423..0.423 rows=0 loops=1)

  • Sort Key: o.id DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.002 0.387 ↓ 0.0 0 1

Nested Loop Semi Join (cost=0.28..54.79 rows=1 width=8) (actual time=0.387..0.387 rows=0 loops=1)

4. 0.385 0.385 ↓ 0.0 0 1

Seq Scan on "OrderDO" o (cost=0.00..48.33 rows=1 width=8) (actual time=0.385..0.385 rows=0 loops=1)

  • Filter: (((((id)::character varying)::text ~~ '%7421-2%'::text) OR (("shopOrderNo")::text ~~ '%7421-2%'::text)) AND ("shopRef" = ANY ('{0,500,1,200,210,220,230,120,100,300,110,111}'::bigint[])))
  • Rows Removed by Filter: 639
5. 0.000 0.000 ↓ 0.0 0

Index Scan using "index_OrderPosDO_orderRef" on "OrderPosDO" op (cost=0.28..8.72 rows=2 width=8) (never executed)

  • Index Cond: ("orderRef" = o.id)
  • Filter: ("supplierRef" = ANY ('{1,3000,1211,1212,1000,2000,1200,1210,1100}'::bigint[]))
Planning time : 0.510 ms
Execution time : 0.476 ms