| planning time: 2msexecution time: 7.2sdistribution: localvectorized: trueplan type: customrows decoded from KV: 1,101,238 (464 MiB, 47 gRPC calls)cumulative time spent in KV: 2.1smaximum memory usage: 121 MiBDistSQL network usage: 0 B (0 messages)max sql temp disk usage: 80 MiBsql cpu time: 5.4sisolation level: serializablepriority: normalquality of service: regular• top-k│ sql nodes: n1│ actual row count: 10│ execution time: 23µs│ estimated max memory allocated: 10 KiB│ sql cpu time: 23µs│ estimated row count: 1│ order: -similarity│ k: 10│└── • render │ └── • filter │ sql nodes: n1 │ actual row count: 475 │ execution time: 5µs │ sql cpu time: 5µs │ estimated row count: 1 │ filter: row_number = 1 │ └── • top-k │ sql nodes: n1 │ actual row count: 500 │ execution time: 9ms │ estimated max memory allocated: 170 KiB │ sql cpu time: 9ms │ estimated row count: 500 │ order: +column38 │ k: 500 │ └── • render │ └── • window │ sql nodes: n1 │ actual row count: 400,927 │ execution time: 2.1s │ estimated max memory allocated: 55 MiB │ sql cpu time: 1.8s │ estimated row count: 368,267 │ └── • render │ └── • hash join │ sql nodes: n1 │ actual row count: 400,927 │ execution time: 2.3s │ estimated max memory allocated: 77 MiB │ sql cpu time: 1.9s │ estimated row count: 368,267 │ equality: (spotify_id) = (id) │ left cols are key │ right cols are key │ ├── • scan │ sql nodes: n1 │ kv nodes: n1 │ actual row count: 550,619 │ KV time: 1.3s │ KV rows decoded: 550,619 │ KV bytes read: 317 MiB │ KV gRPC calls: 32 │ estimated max memory allocated: 11 MiB │ sql cpu time: 630ms │ estimated row count: 574,254 (100% of the table; stats collected 1 hour ago; using stats forecast for 1 hour ago) │ table: song_vectors@song_vectors_pkey │ spans: FULL SCAN │ └── • filter │ sql nodes: n1 │ actual row count: 400,927 │ execution time: 3ms │ sql cpu time: 3ms │ estimated row count: 368,267 │ filter: year <= 2016 │ └── • scan sql nodes: n1 kv nodes: n1 actual row count: 550,619 KV time: 777ms KV rows decoded: 550,619 KV bytes read: 147 MiB KV gRPC calls: 15 estimated max memory allocated: 10 MiB sql cpu time: 237ms estimated row count: 505,005 (100% of the table; stats collected 2 hours ago) table: songs@songs_pkey spans: FULL SCAN |