explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eSTb

Settings
# exclusive inclusive rows x rows loops node
1. 0.144 5.435 ↓ 165.0 165 1

Nested Loop (cost=8.49..133.06 rows=1 width=9) (actual time=0.121..5.435 rows=165 loops=1)

2. 0.152 4.631 ↓ 165.0 165 1

Nested Loop (cost=8.07..132.27 rows=1 width=26) (actual time=0.112..4.631 rows=165 loops=1)

3. 0.095 4.314 ↓ 165.0 165 1

Nested Loop (cost=7.79..131.74 rows=1 width=30) (actual time=0.107..4.314 rows=165 loops=1)

4. 0.184 3.879 ↓ 170.0 170 1

Nested Loop (cost=7.36..124.16 rows=1 width=34) (actual time=0.100..3.879 rows=170 loops=1)

5. 0.033 1.995 ↓ 170.0 170 1

Nested Loop (cost=7.07..123.54 rows=1 width=66) (actual time=0.084..1.995 rows=170 loops=1)

6. 0.056 1.622 ↓ 170.0 170 1

Nested Loop (cost=6.64..122.22 rows=1 width=30) (actual time=0.076..1.622 rows=170 loops=1)

7. 0.090 1.226 ↓ 170.0 170 1

Nested Loop (cost=6.21..121.33 rows=1 width=30) (actual time=0.067..1.226 rows=170 loops=1)

8. 0.078 0.796 ↓ 170.0 170 1

Nested Loop (cost=5.78..120.23 rows=1 width=9) (actual time=0.061..0.796 rows=170 loops=1)

9. 0.012 0.484 ↓ 58.5 117 1

Nested Loop (cost=5.35..109.59 rows=2 width=13) (actual time=0.044..0.484 rows=117 loops=1)

10. 0.023 0.121 ↓ 58.5 117 1

Nested Loop (cost=4.92..94.43 rows=2 width=8) (actual time=0.037..0.121 rows=117 loops=1)

11. 0.012 0.012 ↑ 1.0 1 1

Index Scan using components_code_key on components from_cmp (cost=0.28..8.30 rows=1 width=4) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: ((code)::text = 'APP712.01'::text)
12. 0.075 0.086 ↓ 2.6 117 1

Bitmap Heap Scan on artifact_namespace from_an (cost=4.63..85.68 rows=45 width=12) (actual time=0.021..0.086 rows=117 loops=1)

  • Recheck Cond: (comp_id = from_cmp.id)
  • Heap Blocks: exact=32
13. 0.011 0.011 ↓ 2.6 118 1

Bitmap Index Scan on artifact_namespace_comp_id_index (cost=0.00..4.62 rows=45 width=0) (actual time=0.011..0.011 rows=118 loops=1)

  • Index Cond: (comp_id = from_cmp.id)
14. 0.351 0.351 ↑ 1.0 1 117

Index Scan using nexus_artifact_pkey on nexus_artifact from_na (cost=0.43..7.58 rows=1 width=5) (actual time=0.003..0.003 rows=1 loops=117)

  • Index Cond: (id = from_an.latest)
15. 0.234 0.234 ↑ 52.0 1 117

Index Scan using java_method_consumer_to_index on java_method_consumer jmc (cost=0.43..4.80 rows=52 width=8) (actual time=0.002..0.002 rows=1 loops=117)

  • Index Cond: (call_from_nexus_artifact_id = from_na.id)
16. 0.340 0.340 ↑ 1.0 1 170

Index Scan using java_method_pkey on java_method to_jm (cost=0.43..1.10 rows=1 width=29) (actual time=0.002..0.002 rows=1 loops=170)

  • Index Cond: (id = jmc.called_java_method_id)
17. 0.340 0.340 ↑ 1.0 1 170

Index Scan using java_interface_pkey on java_interface to_ji (cost=0.43..0.89 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=170)

  • Index Cond: (id = to_jm.java_interface_id)
18. 0.340 0.340 ↑ 1.0 1 170

Index Scan using nexus_artifact_pkey on nexus_artifact to_na (cost=0.43..1.32 rows=1 width=44) (actual time=0.002..0.002 rows=1 loops=170)

  • Index Cond: (id = to_ji.nexus_artifact_id)
19. 1.700 1.700 ↑ 1.0 1 170

Index Scan using artifact_namespace_code_key on artifact_namespace to_an (cost=0.29..0.62 rows=1 width=50) (actual time=0.010..0.010 rows=1 loops=170)

  • Index Cond: ((code)::text = (to_na.ga)::text)
20. 0.340 0.340 ↑ 1.0 1 170

Index Scan using nexus_artifact_pkey on nexus_artifact latest (cost=0.43..7.58 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=170)

  • Index Cond: (id = to_an.latest)
  • Filter: from_sources
  • Rows Removed by Filter: 0
21. 0.165 0.165 ↑ 1.0 1 165

Index Only Scan using components_pkey on components to_cmp (cost=0.28..0.53 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=165)

  • Index Cond: (id = to_an.comp_id)
  • Heap Fetches: 165
22. 0.660 0.660 ↑ 1.0 1 165

Index Scan using api_method_signature_sha1_key on api_method am (cost=0.41..0.79 rows=1 width=25) (actual time=0.004..0.004 rows=1 loops=165)

  • Index Cond: (signature_sha1 = to_jm.signature_sha1)
Planning time : 5.774 ms
Execution time : 5.569 ms