explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qPhb

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Result (cost=556.71..556.72 rows=1 width=0) (actual rows= loops=)

2.          

Initplan (forResult)

3. 0.000 0.000 ↓ 0.0

Limit (cost=0.43..556.71 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using invswinstalled_pk on invswinstalled (cost=0.43..228,076.70 rows=410 width=8) (actual rows= loops=)

  • Index Cond: (component_id IS NOT NULL)