explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JXXf

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.031 ↑ 1.0 1 1

Limit (cost=0.42..8.44 rows=1 width=113) (actual time=0.030..0.031 rows=1 loops=1)

2. 0.030 0.030 ↑ 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.029..0.030 rows=1 loops=1)

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