explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HnCF

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

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

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

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