explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lUeA

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.092 ↓ 2.0 2 1

Nested Loop (cost=8.73..15.59 rows=1 width=12) (actual time=0.060..0.092 rows=2 loops=1)

2. 0.009 0.083 ↓ 2.0 2 1

Nested Loop (cost=8.60..13.29 rows=1 width=12) (actual time=0.055..0.083 rows=2 loops=1)

  • Join Filter: ((ra.ga)::text = (an.code)::text)
  • Rows Removed by Join Filter: 13
3. 0.003 0.064 ↓ 2.0 2 1

Nested Loop (cost=8.46..12.87 rows=1 width=561) (actual time=0.045..0.064 rows=2 loops=1)

4. 0.005 0.055 ↓ 2.0 2 1

Nested Loop (cost=8.32..11.95 rows=1 width=565) (actual time=0.040..0.055 rows=2 loops=1)

5. 0.016 0.044 ↓ 2.0 2 1

Hash Join (cost=8.18..9.50 rows=1 width=557) (actual time=0.034..0.044 rows=2 loops=1)

  • Hash Cond: (((na.ga)::text = (ra.ga)::text) AND ((na.version)::text = (ra.version)::text))
6. 0.017 0.017 ↑ 1.0 21 1

Seq Scan on nexus_artifact na (cost=0.00..1.21 rows=21 width=43) (actual time=0.008..0.017 rows=21 loops=1)

7. 0.004 0.011 ↓ 2.0 2 1

Hash (cost=8.16..8.16 rows=1 width=1,036) (actual time=0.010..0.011 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
8. 0.007 0.007 ↓ 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.005..0.007 rows=2 loops=1)

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

Index Scan using platform_segment_unq on platform_segment ps (cost=0.14..2.45 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=2)

  • Index Cond: (tenant_id = na.tenant_id)
10. 0.006 0.006 ↑ 1.0 1 2

Index Scan using release_unq on release r (cost=0.14..0.53 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=2)

  • Index Cond: (platform_segment_id = ps.id)
  • Filter: (id = 1)
  • Rows Removed by Filter: 2
11. 0.010 0.010 ↓ 1.6 8 2

Index Scan using artifact_namespace_code_key on artifact_namespace an (cost=0.14..0.35 rows=5 width=33) (actual time=0.002..0.005 rows=8 loops=2)

  • Index Cond: (tenant_id = ps.tenant_id)
12. 0.004 0.004 ↑ 1.0 1 2

Index Only Scan using components_pkey on components c (cost=0.14..2.15 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=2)

  • Index Cond: (id = an.comp_id)
  • Heap Fetches: 2
Planning time : 1.175 ms
Execution time : 0.137 ms