Luis RodrĂguez Escario
06/22/2023, 4:20 PMdasger instance migrate
it goes over the runs with a chunk_size of 100. Can we increase that number manually?
Otherwise it has to iterate over the table with limit 100...
SELECT runs.run_body, runs.id
FROM runs LEFT OUTER JOIN (SELECT run_tags.run_id AS tags_run_id
FROM run_tags
WHERE run_tags.key = '.dagster/repository') AS tag_subquery ON runs.run_id = tag_subquery.tags_run_id
WHERE tag_subquery.tags_run_id IS NULL AND runs.id > 3676 ORDER BY runs.id ASC
LIMIT 100
alex
06/22/2023, 6:56 PMalex
06/22/2023, 6:57 PMLuis RodrĂguez Escario
06/22/2023, 7:02 PM