explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HpLo

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

Limit (cost=0.43..3.73 rows=9 width=15) (actual time=0.033..0.035 rows=1 loops=1)

2. 0.032 0.032 ↑ 9.0 1 1

Index Only Scan using box_machine_comp_stat_uniq on box_machine_component_status (cost=0.43..3.73 rows=9 width=15) (actual time=0.031..0.032 rows=1 loops=1)

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