explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tnlb : Optimization for: plan #1gRg

Settings

Optimization path:

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

Index Scan using mst_om_error_details_order_number_idx on mst_om_error_details errordetai0_ (cost=0.42..7.00 rows=3 width=287) (actual time=0.057..0.058 rows=1 loops=1)

  • Index Cond: (((order_number)::text = '1000000187581'::text) AND ((order_status)::text = 'Failure'::text))
Planning time : 0.218 ms
Execution time : 0.080 ms