explain.depesz.com

PostgreSQL's explain analyze made readable

Result: POJH

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 1,157.528 ↓ 2.5 5 1

Nested Loop Anti Join (cost=3.14..113.72 rows=2 width=65) (actual time=427.066..1,157.528 rows=5 loops=1)

2. 0.039 1,111.491 ↓ 2.5 5 1

Nested Loop (cost=2.71..112.82 rows=2 width=69) (actual time=415.141..1,111.491 rows=5 loops=1)

3. 0.020 602.017 ↓ 2.5 5 1

Nested Loop (cost=2.29..111.84 rows=2 width=71) (actual time=356.674..602.017 rows=5 loops=1)

4. 0.015 499.717 ↓ 2.0 4 1

Nested Loop (cost=1.86..110.63 rows=2 width=67) (actual time=346.106..499.717 rows=4 loops=1)

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

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

6. 0.021 499.690 ↓ 2.0 4 5

Materialize (cost=1.86..109.43 rows=2 width=71) (actual time=69.218..99.938 rows=4 loops=5)

7. 0.028 499.669 ↓ 2.0 4 1

Nested Loop (cost=1.86..109.42 rows=2 width=71) (actual time=346.080..499.669 rows=4 loops=1)

8. 0.022 410.097 ↓ 2.0 4 1

Nested Loop (cost=1.43..108.47 rows=2 width=79) (actual time=291.185..410.097 rows=4 loops=1)

9. 0.010 270.671 ↓ 1.5 3 1

Nested Loop (cost=1.00..106.44 rows=2 width=67) (actual time=243.488..270.671 rows=3 loops=1)

10. 0.010 68.496 ↑ 1.0 1 1

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

11. 68.457 68.457 ↑ 1.0 1 1

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

  • Index Cond: (gid = '68a4fca9-e949-4a5a-93b7-3637adde9326'::uuid)
12. 0.029 0.029 ↓ 0.0 0 1

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

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

  • Index Cond: (artist = art.id)
14. 139.404 139.404 ↑ 15.0 1 3

Index Scan using release_group_idx_artist_credit on release_group rg (cost=0.43..0.87 rows=15 width=12) (actual time=42.213..46.468 rows=1 loops=3)

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

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

  • Index Cond: (id = acn.artist_credit)
  • Heap Fetches: 4
16. 102.280 102.280 ↑ 2.0 1 4

Index Scan using release_idx_release_group on release rel (cost=0.43..0.59 rows=2 width=8) (actual time=25.355..25.570 rows=1 loops=4)

  • Index Cond: (release_group = rg.id)
  • Filter: (status = 1)
17. 509.435 509.435 ↑ 1.0 1 5

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

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

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=9.200..9.200 rows=0 loops=5)

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