explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4k51

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

Limit (cost=0.43..1.58 rows=1 width=112) (actual time=0.041..0.041 rows=1 loops=1)

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

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