explain.depesz.com

A tool for finding a real cause for slow queries.

Result: S1s

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.259 6420.262 ↓ 8.3 500 1

Nested Loop (cost=44.06..530.80 rows=60 width=20) (actual time=3421.536..6420.262 rows=500 loops=1)

2. 0.011 0.011 ↑ 6.0 1 1

Seq Scan on user_library library (cost=0.00..25.38 rows=6 width=32) (actual time=0.006..0.011 rows=1 loops=1)

  • Filter: (user_id = 1)
3. 2998.626 6419.992 ↓ 50.0 500 1

Bitmap Heap Scan on de_recording r (cost=44.06..84.01 rows=10 width=28) (actual time=3421.523..6419.992 rows=500 loops=1)

  • Recheck Cond: (id = ANY (library.recordings))
4. 3421.366 3421.366 ↓ 50.0 500 1

Bitmap Index Scan on de_recording_pkey (cost=0.00..44.05 rows=10 width=0) (actual time=3421.366..3421.366 rows=500 loops=1)

  • Index Cond: (id = ANY (library.recordings))