Changes between Version 6 and Version 7 of OtherTopics
- Timestamp:
- 02/13/26 19:12:20 (2 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
OtherTopics
v6 v7 68 68 |QUERY PLAN | 69 69 +----------------------------------------------------------------------------------------------------------------------------------------------------+ 70 |Index Only Scan using listens_timestamp_idx on listens (cost=0.43..140.59 rows=4408 width=4) (actual time=0.034..0.670 rows=4139 loops=1) |70 |Index Only Scan using listens_timestamp_idx on listens (cost=0.43..140.59 rows=4408 width=4) (actual time=0.034..0.670 rows=4139 loops=1) | 71 71 | Index Cond: (("timestamp" >= (CURRENT_DATE - 1)) AND ("timestamp" <= CURRENT_DATE)) | 72 72 | Heap Fetches: 0 | … … 225 225 | -> Nested Loop Left Join (cost=0.84..47470.09 rows=2 width=82) (actual time=55.582..76.259 rows=1 loops=3) | 226 226 | -> Nested Loop Left Join (cost=0.42..47461.22 rows=2 width=66) (actual time=55.561..76.234 rows=1 loops=3) | 227 | -> Parallel Seq Scan on musical_entities _temp me (cost=0.00..47444.33 rows=2 width=50) (actual time=55.513..76.174 rows=1 loops=3)|227 | -> Parallel Seq Scan on musical_entities me (cost=0.00..47444.33 rows=2 width=50) (actual time=55.513..76.174 rows=1 loops=3) | 228 228 | Filter: (released_by = 123456) | 229 229 | Rows Removed by Filter: 333332 | 230 | -> Index Scan using temp_songs_pkey on temp_songs s (cost=0.42..8.44 rows=1 width=16) (actual time=0.049..0.049 rows=1 loops=3)|230 | -> Index Scan using songs_pkey on songs s (cost=0.42..8.44 rows=1 width=16) (actual time=0.049..0.049 rows=1 loops=3) | 231 231 | Index Cond: (id = me.id) | 232 | -> Index Only Scan using temp_albums_pkey on temp_albums a (cost=0.42..4.44 rows=1 width=8) (actual time=0.020..0.020 rows=0 loops=3)|232 | -> Index Only Scan using albums_pkey on albums a (cost=0.42..4.44 rows=1 width=8) (actual time=0.020..0.020 rows=0 loops=3) | 233 233 | Index Cond: (id = me.id) | 234 234 | Heap Fetches: 0 | … … 248 248 |Nested Loop Left Join (cost=1.27..88.91 rows=5 width=82) (actual time=0.061..0.084 rows=3 loops=1) | 249 249 | -> Nested Loop Left Join (cost=0.85..66.72 rows=5 width=66) (actual time=0.026..0.041 rows=3 loops=1) | 250 | -> Index Scan using me_released_by_release_date_idx on musical_entities _temp me (cost=0.42..24.51 rows=5 width=50) (actual time=0.013..0.018 rows=3 loops=1)|250 | -> Index Scan using me_released_by_release_date_idx on musical_entities me (cost=0.42..24.51 rows=5 width=50) (actual time=0.013..0.018 rows=3 loops=1) | 251 251 | Index Cond: (released_by = 123456) | 252 | -> Index Scan using temp_songs_pkey on temp_songs s (cost=0.42..8.44 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=3)|252 | -> Index Scan using songs_pkey on songs s (cost=0.42..8.44 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=3) | 253 253 | Index Cond: (id = me.id) | 254 | -> Index Only Scan using temp_albums_pkey on temp_albums a (cost=0.42..4.44 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=3)|254 | -> Index Only Scan using albums_pkey on albums a (cost=0.42..4.44 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=3) | 255 255 | Index Cond: (id = me.id) | 256 256 | Heap Fetches: 0 |
