explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oalU

Settings
# exclusive inclusive rows x rows loops node
1. 0.125 2,554.138 ↓ 29.0 58 1

Nested Loop (cost=1.86..110.63 rows=2 width=63) (actual time=266.847..2,554.138 rows=58 loops=1)

  • Join Filter: (rg.type = reltype.id)
  • Rows Removed by Join Filter: 242
2. 0.008 0.008 ↑ 1.0 5 1

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

3. 0.252 2,554.005 ↓ 30.0 60 5

Materialize (cost=1.86..109.44 rows=2 width=67) (actual time=50.508..510.801 rows=60 loops=5)

4. 0.259 2,553.753 ↓ 30.0 60 1

Nested Loop (cost=1.86..109.43 rows=2 width=67) (actual time=252.533..2,553.753 rows=60 loops=1)

5. 0.096 797.311 ↓ 5.5 11 1

Nested Loop (cost=1.43..107.34 rows=2 width=71) (actual time=177.305..797.311 rows=11 loops=1)

6. 0.039 685.378 ↓ 5.5 11 1

Nested Loop (cost=1.00..106.44 rows=2 width=67) (actual time=165.867..685.378 rows=11 loops=1)

7. 0.010 117.200 ↑ 1.0 1 1

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

8. 117.163 117.163 ↑ 1.0 1 1

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

  • Index Cond: (gid = '664c3e0e-42d8-48c1-b209-1efca19c0325'::uuid)
9. 0.027 0.027 ↓ 0.0 0 1

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

  • Index Cond: (id = COALESCE(art.begin_area, art.area))
10. 568.139 568.139 ↑ 2.1 11 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=48.663..568.139 rows=11 loops=1)

  • Index Cond: (artist = art.id)
11. 111.837 111.837 ↑ 1.0 1 11

Index Only Scan using artist_credit_pkey on artist_credit cred (cost=0.43..0.45 rows=1 width=4) (actual time=10.167..10.167 rows=1 loops=11)

  • Index Cond: (id = acn.artist_credit)
  • Heap Fetches: 0
12. 1,756.183 1,756.183 ↑ 4.0 5 11

Index Scan using release_group_idx_artist_credit on release_group rg (cost=0.43..0.84 rows=20 width=8) (actual time=11.484..159.653 rows=5 loops=11)

  • Index Cond: (artist_credit = cred.id)
Planning time : 3.302 ms
Execution time : 2,554.275 ms