explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Ns6

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.013 449.571 ↓ 0.0 0 1

Hash Join (cost=12,854.09..15,162.43 rows=40,228 width=16) (actual time=449.571..449.571 rows=0 loops=1)

  • Hash Cond: (artist.id = t.artist_id)
2. 0.013 0.013 ↑ 80,456.0 1 1

Seq Scan on artist (cost=0.00..1,994.56 rows=80,456 width=20) (actual time=0.013..0.013 rows=1 loops=1)

3. 0.001 449.545 ↓ 0.0 0 1

Hash (cost=12,839.01..12,839.01 rows=1,207 width=4) (actual time=449.545..449.545 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
4. 0.028 449.544 ↓ 0.0 0 1

HashAggregate (cost=12,814.87..12,826.94 rows=1,207 width=4) (actual time=449.544..449.544 rows=0 loops=1)

5. 57.678 449.516 ↓ 0.0 0 1

Hash Anti Join (cost=9,522.09..12,811.85 rows=1,207 width=4) (actual time=449.516..449.516 rows=0 loops=1)

  • Hash Cond: (t.artist_id = att.artist_id)
6. 26.711 252.126 ↑ 16.6 371 1

Hash Join (cost=5,799.03..8,537.96 rows=6,154 width=4) (actual time=197.017..252.126 rows=371 loops=1)

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

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

8. 2.286 193.236 ↑ 3.7 4,541 1

Hash (cost=5,589.36..5,589.36 rows=16,773 width=8) (actual time=193.236..193.236 rows=4,541 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 178kB
9. 78.364 190.950 ↑ 3.7 4,541 1

Hash Anti Join (cost=363.01..5,589.36 rows=16,773 width=8) (actual time=41.597..190.950 rows=4,541 loops=1)

  • Hash Cond: (t.artist_id = webservice_history.artist_id)
10. 75.574 75.574 ↓ 1.0 145,690 1

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

11. 2.699 37.012 ↓ 1.0 2,956 1

Hash (cost=326.21..326.21 rows=2,944 width=4) (actual time=37.012..37.012 rows=2,956 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 104kB
12. 34.313 34.313 ↓ 1.0 2,956 1

Seq Scan on webservice_history (cost=0.00..326.21 rows=2,944 width=4) (actual time=16.478..34.313 rows=2,956 loops=1)

  • Filter: (calltype_id = 2)
13. 83.001 139.712 ↓ 1.0 113,460 1

Hash (cost=1,868.25..1,868.25 rows=113,025 width=4) (actual time=139.712..139.712 rows=113,460 loops=1)

  • Buckets: 4096 Batches: 8 Memory Usage: 521kB
14. 56.711 56.711 ↓ 1.0 113,460 1

Seq Scan on artisttoptrack att (cost=0.00..1,868.25 rows=113,025 width=4) (actual time=0.044..56.711 rows=113,460 loops=1)