explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DHps

Settings
# exclusive inclusive rows x rows loops node
1. 0.157 10,856.838 ↓ 81.0 81 1

Nested Loop Left Join (cost=34.62..174.95 rows=1 width=84) (actual time=26.967..10,856.838 rows=81 loops=1)

2. 0.122 10,856.519 ↓ 81.0 81 1

Nested Loop (cost=34.48..166.67 rows=1 width=60) (actual time=26.954..10,856.519 rows=81 loops=1)

3. 0.695 10,855.830 ↓ 81.0 81 1

Nested Loop (cost=34.35..166.51 rows=1 width=64) (actual time=26.667..10,855.830 rows=81 loops=1)

4. 1.083 1,570.003 ↓ 163.0 326 1

Nested Loop (cost=1.71..101.19 rows=2 width=68) (actual time=3.598..1,570.003 rows=326 loops=1)

5. 0.952 1,558.294 ↓ 115.5 231 1

Nested Loop (cost=1.28..99.11 rows=2 width=47) (actual time=3.505..1,558.294 rows=231 loops=1)

6. 0.222 2.712 ↓ 115.5 231 1

Nested Loop (cost=0.86..98.15 rows=2 width=43) (actual time=0.138..2.712 rows=231 loops=1)

7. 0.081 0.081 ↑ 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.079..0.081 rows=1 loops=1)

  • Index Cond: (gid = '53b106e7-0cc6-42cc-ac95-ed8d30a3a98e'::uuid)
8. 2.409 2.409 ↓ 10.0 231 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.053..2.409 rows=231 loops=1)

  • Index Cond: (artist = art.id)
9. 1,554.630 1,554.630 ↑ 1.0 1 231

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

  • Index Cond: (id = acn.artist_credit)
  • Heap Fetches: 231
10. 10.626 10.626 ↑ 20.0 1 231

Index Scan using release_group_idx_artist_credit on release_group rg (cost=0.43..0.84 rows=20 width=33) (actual time=0.032..0.046 rows=1 loops=231)

  • Index Cond: (artist_credit = cred.id)
11. 0.652 9,285.132 ↓ 0.0 0 326

Subquery Scan on rel (cost=32.63..32.65 rows=1 width=4) (actual time=28.482..28.482 rows=0 loops=326)

  • Filter: (rg.id = rel.rg)
12. 0.978 9,284.480 ↓ 0.0 0 326

Unique (cost=32.63..32.64 rows=1 width=15) (actual time=28.480..28.480 rows=0 loops=326)

13. 4.890 9,283.502 ↓ 0.0 0 326

Sort (cost=32.63..32.64 rows=1 width=15) (actual time=28.477..28.477 rows=0 loops=326)

  • Sort Key: ((cty.country = 222)) DESC, cty.date_year, cty.date_month, cty.date_day
  • Sort Method: quicksort Memory: 25kB
14. 0.980 9,278.612 ↓ 0.0 0 326

Result (cost=1.28..32.62 rows=1 width=15) (actual time=28.455..28.462 rows=0 loops=326)

  • One-Time Filter: (rg.type = ANY ('{1,3}'::integer[]))
15. 1.959 9,277.632 ↓ 0.0 0 288

Nested Loop Left Join (cost=1.28..32.62 rows=1 width=15) (actual time=32.206..32.214 rows=0 loops=288)

  • Filter: (sec.secondary_type IS NULL)
  • Rows Removed by Filter: 2
16. 4.216 9,266.976 ↑ 1.0 2 288

Nested Loop (cost=0.86..28.15 rows=2 width=14) (actual time=20.934..32.177 rows=2 loops=288)

17. 5,103.360 5,103.360 ↑ 1.0 2 288

Index Scan using release_idx_release_group on release _rel (cost=0.43..11.24 rows=2 width=8) (actual time=16.465..17.720 rows=2 loops=288)

  • Index Cond: (release_group = rg.id)
  • Filter: (status = 1)
  • Rows Removed by Filter: 0
18. 4,159.400 4,159.400 ↑ 1.0 1 700

Index Scan using release_country_pkey on release_country cty (cost=0.43..8.45 rows=1 width=14) (actual time=5.938..5.942 rows=1 loops=700)

  • Index Cond: (release = _rel.id)
19. 1.473 8.697 ↑ 1.0 1 669

Materialize (cost=0.42..4.45 rows=1 width=4) (actual time=0.013..0.013 rows=1 loops=669)

20. 7.224 7.224 ↑ 1.0 1 258

Index Only Scan using release_group_secondary_type_join_pkey on release_group_secondary_type_join sec (cost=0.42..4.44 rows=1 width=4) (actual time=0.028..0.028 rows=1 loops=258)

  • Index Cond: (release_group = rg.id)
  • Heap Fetches: 0
21. 0.567 0.567 ↑ 1.0 1 81

Index Only Scan using release_group_primary_type_pkey on release_group_primary_type reltype (cost=0.13..0.15 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=81)

  • Index Cond: (id = rg.type)
  • Heap Fetches: 0
22. 0.162 0.162 ↓ 0.0 0 81

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

  • Index Cond: (id = COALESCE(art.begin_area, art.area))
Planning time : 7.419 ms
Execution time : 10,857.223 ms