explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E0Zl

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=14.65..33.34 rows=3 width=216) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=14.50..32.74 rows=3 width=124) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using artists_name_key on artists a (cost=0.15..8.17 rows=1 width=124) (actual rows= loops=)

  • Index Cond: ((name)::text = 'Male Puppy'::text)
4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on artists_albums aa (cost=14.35..24.50 rows=7 width=32) (actual rows= loops=)

  • Recheck Cond: (artist_id = a.id)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on artists_albums_pkey (cost=0.00..14.35 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (artist_id = a.id)
6. 0.000 0.000 ↓ 0.0

Index Scan using pk_albums_id on albums al (cost=0.15..0.20 rows=1 width=124) (actual rows= loops=)

  • Index Cond: (id = aa.album_id)