explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KXsn

Settings
# exclusive inclusive rows x rows loops node
1. 156.754 163.553 ↓ 1.0 47,901 1

Bitmap Heap Scan on seller_orders_sellerorder (cost=1,453.28..133,872.87 rows=47,680 width=601) (actual time=13.569..163.553 rows=47,901 loops=1)

  • Recheck Cond: ((seller_id = 'b5760b25-a8bd-4e26-acfe-f1b071263126'::uuid) AND ((cancelation_status)::text = ''::text))
  • Heap Blocks: exact=41,134
2. 6.799 6.799 ↓ 1.0 47,901 1

Bitmap Index Scan on seller_orde_seller__0c1ee4_idx (cost=0.00..1,441.36 rows=47,680 width=0) (actual time=6.799..6.799 rows=47,901 loops=1)

  • Index Cond: ((seller_id = 'b5760b25-a8bd-4e26-acfe-f1b071263126'::uuid) AND ((cancelation_status)::text = ''::text))
Planning time : 0.172 ms
Execution time : 165.926 ms