explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pfB1

Settings
# exclusive inclusive rows x rows loops node
1. 1.347 488.905 ↓ 9.5 19 1

Nested Loop Semi Join (cost=2.13..67.80 rows=2 width=12) (actual time=0.274..488.905 rows=19 loops=1)

  • Join Filter: (((ra.ga)::text = (na.ga)::text) AND ((ra.version)::text = (na.version)::text) AND (ps.tenant_id = na.tenant_id))
  • Rows Removed by Join Filter: 7,624
2. 0.133 0.808 ↓ 14.8 59 1

Nested Loop (cost=1.58..34.93 rows=4 width=1,099) (actual time=0.116..0.808 rows=59 loops=1)

3. 0.034 0.311 ↓ 14.0 28 1

Nested Loop (cost=1.29..33.99 rows=2 width=1,086) (actual time=0.104..0.311 rows=28 loops=1)

4. 0.018 0.173 ↓ 2.0 2 1

Nested Loop (cost=1.00..33.26 rows=1 width=1,086) (actual time=0.091..0.173 rows=2 loops=1)

5. 0.005 0.137 ↓ 2.0 2 1

Nested Loop (cost=0.72..32.93 rows=1 width=1,086) (actual time=0.079..0.137 rows=2 loops=1)

6. 0.008 0.074 ↓ 2.0 2 1

Nested Loop (cost=0.43..24.61 rows=1 width=1,036) (actual time=0.045..0.074 rows=2 loops=1)

7. 0.006 0.054 ↓ 2.0 2 1

Nested Loop (cost=0.29..16.33 rows=1 width=1,036) (actual time=0.035..0.054 rows=2 loops=1)

8. 0.028 0.028 ↓ 2.0 2 1

Index Only Scan using released_artifact_unq on released_artifact ra (cost=0.14..8.16 rows=1 width=1,036) (actual time=0.022..0.028 rows=2 loops=1)

  • Index Cond: (release_id = 1)
  • Heap Fetches: 2
9. 0.020 0.020 ↑ 1.0 1 2

Index Scan using release_pkey on release r (cost=0.14..8.16 rows=1 width=8) (actual time=0.008..0.010 rows=1 loops=2)

  • Index Cond: (id = 1)
10. 0.012 0.012 ↑ 1.0 1 2

Index Scan using platform_segment_pkey on platform_segment ps (cost=0.14..8.16 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=2)

  • Index Cond: (id = r.platform_segment_id)
11. 0.058 0.058 ↑ 1.0 1 2

Index Scan using artifact_namespace_code_key on artifact_namespace an (cost=0.29..8.30 rows=1 width=50) (actual time=0.026..0.029 rows=1 loops=2)

  • Index Cond: ((code)::text = (ra.ga)::text)
12. 0.018 0.018 ↑ 1.0 1 2

Index Only Scan using components_pkey on components c (cost=0.28..0.33 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=2)

  • Index Cond: (id = an.comp_id)
  • Heap Fetches: 0
13. 0.104 0.104 ↓ 1.8 14 2

Index Scan using api_qname_artifact_id_index on api_qname aq (cost=0.29..0.65 rows=8 width=8) (actual time=0.009..0.052 rows=14 loops=2)

  • Index Cond: (artifact_id = an.id)
14. 0.364 0.364 ↑ 1.0 2 28

Index Scan using api_version_api_id_index on api_version av (cost=0.29..0.45 rows=2 width=17) (actual time=0.008..0.013 rows=2 loops=28)

  • Index Cond: (api_id = aq.id)
15. 486.750 486.750 ↓ 130.0 130 59

Index Scan using nexus_artifact_ga_major_version_minor_version_snapshot_index on nexus_artifact na (cost=0.56..8.20 rows=1 width=62) (actual time=0.033..8.250 rows=130 loops=59)

  • Index Cond: (((ga)::text = (an.code)::text) AND (major_version = av.major_version) AND (minor_version = av.minor_version) AND (snapshot = av.snapshot))
  • Filter: from_sources
  • Rows Removed by Filter: 5,875
Planning time : 9.061 ms
Execution time : 489.072 ms