explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R7ZX

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.613 ↓ 7.5 15 1

Nested Loop Anti Join (cost=3.14..113.72 rows=2 width=65) (actual time=0.208..0.613 rows=15 loops=1)

2. 0.012 0.497 ↓ 9.0 18 1

Nested Loop (cost=2.71..112.82 rows=2 width=69) (actual time=0.189..0.497 rows=18 loops=1)

3. 0.004 0.323 ↓ 9.0 18 1

Nested Loop (cost=2.29..111.84 rows=2 width=71) (actual time=0.160..0.323 rows=18 loops=1)

4. 0.010 0.219 ↓ 5.0 10 1

Nested Loop (cost=1.86..110.63 rows=2 width=67) (actual time=0.144..0.219 rows=10 loops=1)

  • Join Filter: (rg.type = reltype.id)
  • Rows Removed by Join Filter: 40
5. 0.009 0.009 ↑ 1.0 5 1

Seq Scan on release_group_primary_type reltype (cost=0.00..1.05 rows=5 width=4) (actual time=0.007..0.009 rows=5 loops=1)

6. 0.012 0.200 ↓ 5.0 10 5

Materialize (cost=1.86..109.43 rows=2 width=71) (actual time=0.027..0.040 rows=10 loops=5)

7. 0.008 0.188 ↓ 5.0 10 1

Nested Loop (cost=1.86..109.42 rows=2 width=71) (actual time=0.130..0.188 rows=10 loops=1)

8. 0.002 0.120 ↓ 5.0 10 1

Nested Loop (cost=1.43..108.47 rows=2 width=79) (actual time=0.085..0.120 rows=10 loops=1)

9. 0.000 0.066 ↑ 2.0 1 1

Nested Loop (cost=1.00..106.44 rows=2 width=67) (actual time=0.065..0.066 rows=1 loops=1)

10. 0.003 0.054 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..16.73 rows=1 width=67) (actual time=0.053..0.054 rows=1 loops=1)

11. 0.039 0.039 ↑ 1.0 1 1

Index Scan using artist_idx_gid on artist art (cost=0.43..8.45 rows=1 width=43) (actual time=0.038..0.039 rows=1 loops=1)

  • Index Cond: (gid = '1a5c6b6c-3b81-431a-b5d3-15a7698de499'::uuid)
12. 0.012 0.012 ↓ 0.0 0 1

Index Scan using area_pkey on area (cost=0.14..8.16 rows=1 width=36) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (id = COALESCE(art.begin_area, art.area))
13. 0.012 0.012 ↑ 23.0 1 1

Index Scan using artist_credit_name_idx_artist on artist_credit_name acn (cost=0.43..89.48 rows=23 width=8) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: (artist = art.id)
14. 0.052 0.052 ↑ 1.5 10 1

Index Scan using release_group_idx_artist_credit on release_group rg (cost=0.43..0.87 rows=15 width=12) (actual time=0.020..0.052 rows=10 loops=1)

  • Index Cond: (artist_credit = acn.artist_credit)
  • Filter: (type = ANY ('{1,3}'::integer[]))
  • Rows Removed by Filter: 4
15. 0.060 0.060 ↑ 1.0 1 10

Index Only Scan using artist_credit_pkey on artist_credit cred (cost=0.43..0.48 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=10)

  • Index Cond: (id = acn.artist_credit)
  • Heap Fetches: 10
16. 0.100 0.100 ↑ 1.0 2 10

Index Scan using release_idx_release_group on release rel (cost=0.43..0.59 rows=2 width=8) (actual time=0.008..0.010 rows=2 loops=10)

  • Index Cond: (release_group = rg.id)
  • Filter: (status = 1)
  • Rows Removed by Filter: 0
17. 0.162 0.162 ↑ 1.0 1 18

Index Scan using release_country_pkey on release_country cty (cost=0.43..0.48 rows=1 width=6) (actual time=0.009..0.009 rows=1 loops=18)

  • Index Cond: (release = rel.id)
18. 0.108 0.108 ↓ 0.0 0 18

Index Only Scan using release_group_secondary_type_join_pkey on release_group_secondary_type_join (cost=0.42..0.44 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=18)

  • Index Cond: (release_group = rg.id)
  • Heap Fetches: 0
Planning time : 6.224 ms
Execution time : 0.781 ms