explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uNFZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.042 ↑ 1.0 1 1

Nested Loop (cost=0.55..5.00 rows=1 width=190) (actual time=0.042..0.042 rows=1 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=7
2. 0.028 0.028 ↑ 1.0 1 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.028..0.028 rows=1 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 = '5079478927'::numeric))
  • Buffers: shared hit=3
3. 0.011 0.011 ↑ 1.0 1 1

Index Only Scan using cyc_suborder_suborderidorder_index on cccl.cyc_suborder s (cost=0.28..2.49 rows=1 width=4) (actual time=0.011..0.011 rows=1 loops=1)

  • Output: s.suborderidorder
  • Index Cond: (s.suborderidorder = o.orderid)
  • Heap Fetches: 1
  • Buffers: shared hit=4
Planning time : 0.286 ms
Execution time : 0.070 ms