explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PV4Lx

Settings
# exclusive inclusive rows x rows loops node
1. 0.042 13.178 ↓ 75.0 75 1

Nested Loop Left Join (cost=34.62..174.94 rows=1 width=84) (actual time=0.486..13.178 rows=75 loops=1)

2. 0.081 13.061 ↓ 75.0 75 1

Nested Loop (cost=34.47..166.66 rows=1 width=60) (actual time=0.475..13.061 rows=75 loops=1)

3. 0.362 12.905 ↓ 75.0 75 1

Nested Loop (cost=34.34..166.50 rows=1 width=64) (actual time=0.443..12.905 rows=75 loops=1)

4. 0.160 1.653 ↓ 247.5 495 1

Nested Loop (cost=1.71..101.19 rows=2 width=68) (actual time=0.165..1.653 rows=495 loops=1)

5. 0.014 0.281 ↓ 6.0 12 1

Nested Loop (cost=1.28..99.11 rows=2 width=47) (actual time=0.138..0.281 rows=12 loops=1)

6. 0.011 0.123 ↓ 6.0 12 1

Nested Loop (cost=0.86..98.15 rows=2 width=43) (actual time=0.090..0.123 rows=12 loops=1)

7. 0.064 0.064 ↑ 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.062..0.064 rows=1 loops=1)

  • Index Cond: (gid = '23d8426c-18c7-46e6-a51d-7395bd43c641'::uuid)
8. 0.048 0.048 ↑ 1.9 12 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.020..0.048 rows=12 loops=1)

  • Index Cond: (artist = art.id)
9. 0.144 0.144 ↑ 1.0 1 12

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

  • Index Cond: (id = acn.artist_credit)
  • Heap Fetches: 12
10. 1.212 1.212 ↓ 2.0 41 12

Index Scan using release_group_idx_artist_credit on release_group rg (cost=0.43..0.84 rows=20 width=33) (actual time=0.009..0.101 rows=41 loops=12)

  • Index Cond: (artist_credit = cred.id)
11. 0.000 10.890 ↓ 0.0 0 495

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

  • Filter: (rg.id = rel.rg)
12. 0.000 10.890 ↓ 0.0 0 495

Unique (cost=32.63..32.63 rows=1 width=15) (actual time=0.022..0.022 rows=0 loops=495)

13. 1.485 10.890 ↓ 0.0 0 495

Sort (cost=32.63..32.63 rows=1 width=15) (actual time=0.022..0.022 rows=0 loops=495)

  • Sort Key: ((cty.country = 222)) DESC, cty.date_year, cty.date_month, cty.date_day
  • Sort Method: quicksort Memory: 25kB
14. 0.510 9.405 ↑ 1.0 1 495

Nested Loop (cost=1.71..32.62 rows=1 width=15) (actual time=0.013..0.019 rows=1 loops=495)

15. 0.000 6.435 ↓ 0.0 0 495

Nested Loop (cost=1.28..24.16 rows=1 width=8) (actual time=0.012..0.013 rows=0 loops=495)

16. 0.691 4.950 ↓ 0.0 0 495

Nested Loop Left Join (cost=0.85..12.90 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=495)

  • Join Filter: (sec.release_group = _rg.id)
  • Filter: (sec.secondary_type IS NULL)
  • Rows Removed by Filter: 1
17. 2.475 2.475 ↑ 1.0 1 495

Index Scan using release_group_pkey on release_group _rg (cost=0.43..8.45 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=495)

  • Index Cond: (id = rg.id)
  • Filter: (type = ANY ('{1,3}'::integer[]))
  • Rows Removed by Filter: 0
18. 1.784 1.784 ↑ 1.0 1 446

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=8) (actual time=0.004..0.004 rows=1 loops=446)

  • Index Cond: (release_group = rg.id)
  • Heap Fetches: 0
19. 1.501 1.501 ↓ 1.5 3 79

Index Scan using release_idx_release_group on release _rel (cost=0.43..11.24 rows=2 width=8) (actual time=0.011..0.019 rows=3 loops=79)

  • Index Cond: (release_group = rg.id)
  • Filter: (status = 1)
  • Rows Removed by Filter: 0
20. 2.460 2.460 ↑ 1.0 1 246

Index Scan using release_country_pkey on release_country cty (cost=0.43..8.45 rows=1 width=14) (actual time=0.009..0.010 rows=1 loops=246)

  • Index Cond: (release = _rel.id)
21. 0.075 0.075 ↑ 1.0 1 75

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.001..0.001 rows=1 loops=75)

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

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

  • Index Cond: (id = COALESCE(art.begin_area, art.area))
Planning time : 5.330 ms
Execution time : 13.455 ms