explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q2ZN

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.039 ↑ 1.0 1 1

Limit (cost=0.42..8.44 rows=1 width=113) (actual time=0.038..0.039 rows=1 loops=1)

2. 0.037 0.037 ↑ 1.0 1 1

Index Scan using box_machine_comp_stat_uniq on box_machine_component_status (cost=0.42..8.44 rows=1 width=113) (actual time=0.037..0.037 rows=1 loops=1)

  • Index Cond: ((box_machine_id = '2478'::numeric) AND ((component)::text = 'Fan'::text))
Planning time : 0.202 ms
Execution time : 0.075 ms