explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3n6j

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

Nested Loop (cost=0.55..5.00 rows=1 width=190) (actual time=0.009..0.009 rows=0 loops=1)

  • Output: o.orderid, o.ordernumber, o.orderidclient, o.orderpickingstatus, o.ordercommerce, o.ordercountryid, o.orderchannelid, o.orderupdatedate, o.ordercreationdate, o.orderstatusid, o.orderhasqr, o.orderisfraud, o.orderstorage
  • Buffers: shared hit=2
2. 0.009 0.009 ↓ 0.0 0 1

Index Scan using cyc_order_ordercountryid_ordernumber_index on cccl.cyc_order o (cost=0.28..2.49 rows=1 width=190) (actual time=0.008..0.009 rows=0 loops=1)

  • Output: o.orderid, o.ordernumber, o.orderidclient, o.orderpickingstatus, o.ordercommerce, o.ordercountryid, o.orderchannelid, o.orderupdatedate, o.ordercreationdate, o.orderstatusid, o.orderhasqr, o.orderisfraud, o.orderstorage
  • Index Cond: (((o.ordercountryid)::text = 'CL'::text) AND (o.ordernumber = '5079496885'::numeric))
  • Buffers: shared hit=2
3. 0.000 0.000 ↓ 0.0 0

Index Only Scan using cyc_suborder_suborderidorder_index on cccl.cyc_suborder s (cost=0.28..2.49 rows=1 width=4) (never executed)

  • Output: s.suborderidorder
  • Index Cond: (s.suborderidorder = o.orderid)
  • Heap Fetches: 0
Planning time : 0.247 ms
Execution time : 0.033 ms