explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s2qU

Settings
# exclusive inclusive rows x rows loops node
1. 177.862 184.436 ↓ 1.0 47,901 1

Bitmap Heap Scan on seller_orders_sellerorder (cost=1,642.55..142,058.10 rows=47,680 width=601) (actual time=14.103..184.436 rows=47,901 loops=1)

  • Recheck Cond: (seller_id = 'b5760b25-a8bd-4e26-acfe-f1b071263126'::uuid)
  • Filter: ((cancelation_status)::text = ''::text)
  • Rows Removed by Filter: 5,342
  • Heap Blocks: exact=45,319
2. 6.574 6.574 ↓ 1.0 53,243 1

Bitmap Index Scan on seller_orde_seller__c661c1_idx (cost=0.00..1,630.63 rows=51,476 width=0) (actual time=6.574..6.574 rows=53,243 loops=1)

  • Index Cond: (seller_id = 'b5760b25-a8bd-4e26-acfe-f1b071263126'::uuid)
Planning time : 0.168 ms
Execution time : 186.391 ms