explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l5yk

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 115.658 ↑ 1.0 1 1

Nested Loop (cost=27.86..1,715.50 rows=1 width=22) (actual time=63.389..115.658 rows=1 loops=1)

2.          

Initplan (forNested Loop)

3. 0.029 0.029 ↑ 1.0 1 1

Seq Scan on ceh_service_ci_types (cost=0.00..1.07 rows=1 width=8) (actual time=0.027..0.029 rows=1 loops=1)

  • Filter: ((type)::text = 'Resource'::text)
  • Rows Removed by Filter: 5
4. 0.120 115.620 ↑ 1.0 1 1

Nested Loop (cost=26.50..1,706.11 rows=1 width=30) (actual time=63.352..115.620 rows=1 loops=1)

  • Join Filter: (m.resource_id = serci.service_ci_type_inst_id)
  • Rows Removed by Join Filter: 146
5. 0.023 0.903 ↓ 21.0 21 1

Nested Loop (cost=26.50..33.24 rows=1 width=38) (actual time=0.393..0.903 rows=21 loops=1)

6. 0.032 0.775 ↓ 21.0 21 1

Nested Loop (cost=26.22..32.71 rows=1 width=42) (actual time=0.388..0.775 rows=21 loops=1)

7. 0.043 0.638 ↓ 21.0 21 1

Nested Loop (cost=26.08..32.51 rows=1 width=46) (actual time=0.381..0.638 rows=21 loops=1)

8. 0.096 0.490 ↓ 21.0 21 1

Hash Join (cost=25.81..32.04 rows=1 width=16) (actual time=0.372..0.490 rows=21 loops=1)

  • Hash Cond: (attrval.resource_attr_map_id = attrmap.resource_attr_map_id)
9. 0.072 0.072 ↑ 1.0 307 1

Seq Scan on ceh_res_attr_values attrval (cost=0.00..5.07 rows=307 width=16) (actual time=0.024..0.072 rows=307 loops=1)

10. 0.014 0.322 ↓ 21.0 21 1

Hash (cost=25.79..25.79 rows=1 width=16) (actual time=0.322..0.322 rows=21 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.082 0.308 ↓ 21.0 21 1

Hash Join (cost=17.56..25.79 rows=1 width=16) (actual time=0.180..0.308 rows=21 loops=1)

  • Hash Cond: (attrmap.attribute_id = attrmaster.attribute_id)
12. 0.079 0.079 ↑ 1.0 307 1

Seq Scan on ceh_res_attr_mapping attrmap (cost=0.00..7.07 rows=307 width=24) (actual time=0.006..0.079 rows=307 loops=1)

13. 0.008 0.147 ↑ 1.0 1 1

Hash (cost=17.55..17.55 rows=1 width=8) (actual time=0.147..0.147 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.139 0.139 ↑ 1.0 1 1

Seq Scan on ceh_attribute_master attrmaster (cost=0.00..17.55 rows=1 width=8) (actual time=0.013..0.139 rows=1 loops=1)

  • Filter: ((attribute_key)::text = 'OS Version'::text)
  • Rows Removed by Filter: 683
15. 0.105 0.105 ↑ 1.0 1 21

Index Scan using ceh_resource_master_pkey on ceh_resource_master m (cost=0.27..0.46 rows=1 width=30) (actual time=0.005..0.005 rows=1 loops=21)

  • Index Cond: (resource_id = attrmap.resource_id)
16. 0.105 0.105 ↑ 1.0 1 21

Index Scan using ceh_resource_type_master_pkey on ceh_resource_type_master type (cost=0.14..0.19 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=21)

  • Index Cond: (resource_type_id = m.resource_type_id)
  • Filter: ((resource_type)::text = 'OS'::text)
17. 0.105 0.105 ↑ 1.0 1 21

Index Scan using ceh_attr_quanti_value_pkey on ceh_attr_quanti_value attrquantval (cost=0.28..0.52 rows=1 width=12) (actual time=0.004..0.005 rows=1 loops=21)

  • Index Cond: (value_id = attrval.value_id)
18. 114.597 114.597 ↓ 2.3 7 21

Seq Scan on ceh_service_ci serci (cost=0.00..1,672.83 rows=3 width=16) (actual time=2.320..5.457 rows=7 loops=21)

  • Filter: ((parent_ci_id = 111441) AND (service_ci_type_id = $0))
  • Rows Removed by Filter: 18266
19. 0.035 0.035 ↑ 1.0 1 1

Index Only Scan using pk_ci_id on ceh_service_ci ci (cost=0.29..8.30 rows=1 width=8) (actual time=0.034..0.035 rows=1 loops=1)

  • Index Cond: (ci_id = 111441)
  • Heap Fetches: 1
Planning time : 4.096 ms
Execution time : 115.898 ms