explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1gRg

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 66.022 66.022 ↑ 3.0 1 1

Seq Scan on mst_om_error_details errordetai0_ (cost=0.00..13,142.76 rows=3 width=287) (actual time=0.222..66.022 rows=1 loops=1)

  • Filter: (((order_number)::text = '1000000187581'::text) AND ((order_status)::text = 'Failure'::text))
  • Rows Removed by Filter: 298999