explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kb9h

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.030 ↓ 0.0 0 1

Limit (cost=0.42..4.64 rows=1 width=30) (actual time=0.030..0.030 rows=0 loops=1)

2. 0.029 0.029 ↓ 0.0 0 1

Index Scan using spare_mass_prod_part_id_root_part_i on spare_mass_prod_part (cost=0.42..42.67 rows=10 width=30) (actual time=0.029..0.029 rows=0 loops=1)

  • Index Cond: ((id_root_part)::text = '009231081A'::text)
Planning time : 0.122 ms
Execution time : 0.045 ms