explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OgGp

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

Limit (cost=0.42..4.75 rows=1 width=30) (actual time=0.027..0.028 rows=1 loops=1)

2. 0.027 0.027 ↑ 10.0 1 1

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

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