explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZABj

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.041 ↑ 9.0 1 1

Limit (cost=0.43..10.75 rows=9 width=112) (actual time=0.039..0.041 rows=1 loops=1)

2. 0.038 0.038 ↑ 9.0 1 1

Index Scan using box_machine_comp_stat_uniq on box_machine_component_status (cost=0.43..10.75 rows=9 width=112) (actual time=0.037..0.038 rows=1 loops=1)

  • Index Cond: ((box_machine_id = '10438'::numeric) AND ((component)::text = 'Fan'::text))