explain.depesz.com

A tool for finding a real cause for slow queries.

Result: qCb

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.033 442.503 ↓ 8.1 65 1

Nested Loop (cost=11,358.29..11,374.92 rows=8 width=16) (actual time=442.021..442.503 rows=65 loops=1)

2. 0.080 442.015 ↓ 32.5 65 1

HashAggregate (cost=11,358.29..11,358.31 rows=2 width=8) (actual time=441.988..442.015 rows=65 loops=1)

3. 0.696 441.935 ↓ 8.1 65 1

Hash Join (cost=11,305.93..11,358.27 rows=8 width=8) (actual time=440.322..441.935 rows=65 loops=1)

  • Hash Cond: (t.artist_id = ntile.artist_id)
4. 27.813 426.210 ↑ 1.2 2,823 1

HashAggregate (cost=10,721.59..10,754.89 rows=3,330 width=4) (actual time=425.219..426.210 rows=2,823 loops=1)

5. 173.132 398.397 ↑ 1.0 53,093 1

Hash Join (cost=6,265.80..10,588.85 rows=53,093 width=4) (actual time=181.988..398.397 rows=53,093 loops=1)

  • Hash Cond: (mf.track_id = t.id)
6. 43.537 43.537 ↑ 1.0 53,093 1

Seq Scan on musicfile mf (cost=0.00..2,411.93 rows=53,093 width=4) (actual time=0.045..43.537 rows=53,093 loops=1)

7. 92.651 181.728 ↓ 1.0 145,690 1

Hash (cost=3,891.02..3,891.02 rows=144,702 width=8) (actual time=181.728..181.728 rows=145,690 loops=1)

  • Buckets: 4096 Batches: 8 Memory Usage: 726kB
8. 89.077 89.077 ↓ 1.0 145,690 1

Seq Scan on track t (cost=0.00..3,891.02 rows=144,702 width=8) (actual time=0.022..89.077 rows=145,690 loops=1)

9. 0.048 15.029 ↓ 6.6 99 1

Hash (cost=584.16..584.16 rows=15 width=4) (actual time=15.029..15.029 rows=99 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
10. 0.620 14.981 ↓ 6.6 99 1

Subquery Scan on ntile (cost=495.84..584.16 rows=15 width=4) (actual time=12.525..14.981 rows=99 loops=1)

  • Filter: (ntile.ntile = 1)
11. 2.461 14.361 ↓ 1.0 2,956 1

WindowAgg (cost=495.84..547.36 rows=2,944 width=12) (actual time=12.518..14.361 rows=2,956 loops=1)

12. 3.906 11.900 ↓ 1.0 2,956 1

Sort (cost=495.84..503.20 rows=2,944 width=12) (actual time=11.534..11.900 rows=2,956 loops=1)

  • Sort Key: webservice_history.invocation_time
  • Sort Method: quicksort Memory: 235kB
13. 7.994 7.994 ↓ 1.0 2,956 1

Seq Scan on webservice_history (cost=0.00..326.21 rows=2,944 width=12) (actual time=0.071..7.994 rows=2,956 loops=1)

  • Filter: (calltype_id = 2)
14. 0.455 0.455 ↑ 1.0 1 65

Index Scan using artist_pkey on artist (cost=0.00..8.29 rows=1 width=20) (actual time=0.006..0.007 rows=1 loops=65)

  • Index Cond: (id = ntile.artist_id)