explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Y7i

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.007 0.264 ↑ 2.3 6 1

Nested Loop (cost=0.00..132.89 rows=14 width=25) (actual time=0.084..0.264 rows=6 loops=1)

2. 0.011 0.011 ↑ 2.3 6 1

Index Scan using test_m2m_band_members_band_id on test_m2m_band_members (cost=0.00..9.29 rows=14 width=4) (actual time=0.009..0.011 rows=6 loops=1)

  • Index Cond: (band_id = 1)
3. 0.246 0.246 ↑ 1.0 1 6

Index Scan using test_m2m_artist_pkey on test_m2m_artist (cost=0.00..8.82 rows=1 width=25) (actual time=0.040..0.041 rows=1 loops=6)

  • Index Cond: (id = test_m2m_band_members.artist_id)