explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4dMr

Settings
# exclusive inclusive rows x rows loops node
1. 0.289 1,870.591 ↓ 19.5 39 1

Nested Loop Anti Join (cost=3.14..113.72 rows=2 width=65) (actual time=226.503..1,870.591 rows=39 loops=1)

2. 0.281 1,847.394 ↓ 23.0 46 1

Nested Loop (cost=2.71..112.82 rows=2 width=69) (actual time=226.444..1,847.394 rows=46 loops=1)

3. 0.113 1,281.537 ↓ 22.0 44 1

Nested Loop (cost=2.29..111.84 rows=2 width=71) (actual time=226.342..1,281.537 rows=44 loops=1)

4. 0.057 321.640 ↓ 10.5 21 1

Nested Loop (cost=1.86..110.63 rows=2 width=67) (actual time=224.213..321.640 rows=21 loops=1)

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

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

6. 0.092 321.570 ↓ 10.5 21 5

Materialize (cost=1.86..109.43 rows=2 width=71) (actual time=44.841..64.314 rows=21 loops=5)

7. 0.150 321.478 ↓ 10.5 21 1

Nested Loop (cost=1.86..109.42 rows=2 width=71) (actual time=224.193..321.478 rows=21 loops=1)

8. 0.047 287.350 ↓ 10.5 21 1

Nested Loop (cost=1.43..108.47 rows=2 width=79) (actual time=190.569..287.350 rows=21 loops=1)

9. 0.006 109.755 ↑ 2.0 1 1

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

10. 0.012 44.653 ↑ 1.0 1 1

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

11. 44.611 44.611 ↑ 1.0 1 1

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

  • Index Cond: (gid = 'a16371b9-7d36-497a-a9d4-42b0a0440c5e'::uuid)
12. 0.030 0.030 ↓ 0.0 0 1

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

  • Index Cond: (id = COALESCE(art.begin_area, art.area))
13. 65.096 65.096 ↑ 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=65.094..65.096 rows=1 loops=1)

  • Index Cond: (artist = art.id)
14. 177.548 177.548 ↓ 1.4 21 1

Index Scan using release_group_idx_artist_credit on release_group rg (cost=0.43..0.87 rows=15 width=12) (actual time=80.812..177.548 rows=21 loops=1)

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

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

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

Index Scan using release_idx_release_group on release rel (cost=0.43..0.59 rows=2 width=8) (actual time=30.773..45.704 rows=2 loops=21)

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

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

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

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.498..0.498 rows=0 loops=46)

  • Index Cond: (release_group = rg.id)
  • Heap Fetches: 0
Planning time : 6.205 ms
Execution time : 1,870.795 ms