explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OZt8

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 6,363.700 ↑ 1.0 1 1

Result (cost=556.71..556.72 rows=1 width=0) (actual time=6,363.700..6,363.700 rows=1 loops=1)

2.          

Initplan (forResult)

3. 0.002 6,363.692 ↑ 1.0 1 1

Limit (cost=0.43..556.71 rows=1 width=8) (actual time=6,363.692..6,363.692 rows=1 loops=1)

4. 6,363.690 6,363.690 ↑ 410.0 1 1

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

  • Index Cond: (component_id IS NOT NULL)
  • Filter: (software_id = 654681)
  • Rows Removed by Filter: 3855069
Planning time : 0.301 ms