explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bbGj

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.068 ↑ 1.0 1 1

Limit (cost=13.54..13.55 rows=1 width=8) (actual time=0.065..0.068 rows=1 loops=1)

2. 0.007 0.064 ↑ 1.0 1 1

Sort (cost=13.54..13.55 rows=1 width=8) (actual time=0.063..0.064 rows=1 loops=1)

  • Sort Key: o.id DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.007 0.057 ↑ 1.0 1 1

Nested Loop Semi Join (cost=4.90..13.53 rows=1 width=8) (actual time=0.050..0.057 rows=1 loops=1)

  • Join Filter: ("OrderPropertyDO"."orderRef" = op."orderRef")
4. 0.004 0.046 ↑ 1.0 1 1

Nested Loop (cost=4.62..12.69 rows=1 width=16) (actual time=0.040..0.046 rows=1 loops=1)

5. 0.002 0.033 ↑ 1.0 1 1

Unique (cost=4.34..4.35 rows=1 width=8) (actual time=0.032..0.033 rows=1 loops=1)

6. 0.007 0.031 ↑ 1.0 1 1

Sort (cost=4.34..4.35 rows=1 width=8) (actual time=0.030..0.031 rows=1 loops=1)

  • Sort Key: "OrderPropertyDO"."orderRef
  • Sort Method: quicksort Memory: 25kB
7. 0.024 0.024 ↑ 1.0 1 1

Seq Scan on "OrderPropertyDO" (cost=0.00..4.33 rows=1 width=8) (actual time=0.023..0.024 rows=1 loops=1)

  • Filter: (((value)::text ~~ '%7421-2%'::text) AND ((key)::text = 'myOrderNo'::text))
  • Rows Removed by Filter: 95
8. 0.009 0.009 ↑ 1.0 1 1

Index Scan using "OrderDO_pkey" on "OrderDO" o (cost=0.28..8.32 rows=1 width=43) (actual time=0.007..0.009 rows=1 loops=1)

  • Index Cond: (id = "OrderPropertyDO"."orderRef")
  • Filter: ("shopRef" = ANY ('{0,500,1,200,210,220,230,120,100,300,110,111}'::bigint[]))
9. 0.004 0.004 ↑ 2.0 1 1

Index Scan using "index_OrderPosDO_orderRef" on "OrderPosDO" op (cost=0.28..0.82 rows=2 width=8) (actual time=0.004..0.004 rows=1 loops=1)

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