explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fEIx

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

Unique (cost=1,821,524.18..2,340,145.45 rows=4,413,798 width=491) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=1,821,524.18..1,832,558.68 rows=4,413,798 width=491) (actual rows= loops=)

  • Sort Key: orderitem.id, orderitem.store_id, orderitem.orders_id, orderitem.catentry_id, orderitem.itemspc_id, orderitem.partnumber, orderitem.shipmode_id, orderitem.ffmcenter_id, orderitem.member_id, orderitem.address_id, orderitem.description, orderitem.quantity, orderitem.price, orderitem.totalproduct, orderitem.ordrelease_id, orderitem.offer_id, orderitem.taxamount, orderitem.shipcharge, orderitem.shiptaxamount, orderitem.totaladjustment, orderitem.timecreated, orderitem.timeupdated, orderitem.timereleased, orderitem.timeshipped, orderitem.lastallocupdate, orderitem.status, orderitem.inventorystatus, orderitem.fulfillmentstatus, orderitem.prepareflags, orderitem.expedited, orderitem.requestedshipdate, orderitem.comments, orderitem.optcounter, orderitem.shippingoffset, orderitem.allocffmcenter_id, orderitem.allocaddress_id, orderitem.allocquantity, orderitem.estavailtime, orderitem.promisedavailtime, orderitem.currency, orderitem.availquantity, orderitem.field1, orderitem.field2, orderitem.correlationgroup, orderitem.bundle_id, orderitem.wishlist_id
3. 0.000 0.000 ↓ 0.0

Append (cost=0.57..774,036.36 rows=4,413,798 width=491) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using orderitem_pk on orderitem (cost=0.57..407,749.79 rows=2,576,493 width=340) (actual rows= loops=)

  • Index Cond: (id > 1194965278)
5. 0.000 0.000 ↓ 0.0

Index Scan using orderitem_idx19 on orderitem orderitem_1 (cost=0.57..322,148.59 rows=1,837,305 width=340) (actual rows= loops=)

  • Index Cond: (timeupdated > '2020-10-10 22:34:49'::timestamp without time zone)