explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lwXf

Settings
# exclusive inclusive rows x rows loops node
1. 3.374 1,220.515 ↓ 1.9 1,389 1

Nested Loop Left Join (cost=379.72..22,912.63 rows=724 width=628) (actual time=59.421..1,220.515 rows=1,389 loops=1)

2. 3.439 1,108.799 ↓ 1.9 1,389 1

Nested Loop (cost=379.29..16,899.58 rows=724 width=546) (actual time=59.407..1,108.799 rows=1,389 loops=1)

3. 8.696 576.151 ↓ 1.9 1,389 1

Hash Join (cost=378.87..12,281.86 rows=724 width=542) (actual time=59.004..576.151 rows=1,389 loops=1)

  • Hash Cond: (dashboard_artists.artist_id = trackings.artist_id)
4. 530.703 530.703 ↓ 1.8 10,637 1

Index Scan using index_dashboard_artists_on_current_and_artist_id_where_current on dashboard_artists (cost=0.29..11,442.35 rows=5,950 width=529) (actual time=0.005..530.703 rows=10,637 loops=1)

5. 0.707 36.752 ↓ 1.1 1,389 1

Hash (cost=362.88..362.88 rows=1,256 width=13) (actual time=36.752..36.752 rows=1,389 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 83kB
6. 35.893 36.045 ↓ 1.1 1,389 1

Bitmap Heap Scan on trackings (cost=35.21..362.88 rows=1,256 width=13) (actual time=0.194..36.045 rows=1,389 loops=1)

  • Recheck Cond: (user_id = 478)
  • Filter: active
  • Rows Removed by Filter: 126
  • Heap Blocks: exact=282
7. 0.152 0.152 ↓ 1.1 1,523 1

Bitmap Index Scan on index_trackings_on_user_id_and_artist_id (cost=0.00..34.89 rows=1,414 width=0) (actual time=0.152..0.152 rows=1,523 loops=1)

  • Index Cond: (user_id = 478)
8. 529.209 529.209 ↑ 1.0 1 1,389

Index Scan using artists_pkey on artists (cost=0.42..6.37 rows=1 width=12) (actual time=0.381..0.381 rows=1 loops=1,389)

  • Index Cond: (id = dashboard_artists.artist_id)
9. 108.342 108.342 ↑ 1.0 1 1,389

Index Scan using index_sp_accounts_on_artist_id on sp_accounts (cost=0.43..8.30 rows=1 width=86) (actual time=0.078..0.078 rows=1 loops=1,389)

  • Index Cond: (artist_id = trackings.artist_id)
Planning time : 0.857 ms
Execution time : 1,221.103 ms