dolt log is slow to respond without a small -n limit and no other params on a small database (7000 commits)

[sfenig]

The initial query is fast but then the follow up queries to decorate, and add branches and tags seems to slow it down to respond. Could it be paginated or get rid of the n+1

 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select commit_hash from dolt_log() limit 1000" queryTime="2025-08-27 20:48:11.777838883 +0000 UTC m=+1075.803436450"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 25 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select commit_hash from dolt_log() limit 1000" queryTime="2025-08-27 20:48:11.803240883 +0000 UTC m=+1075.828838158"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select dolt_hashof('HEAD')" queryTime="2025-08-27 20:48:11.803479049 +0000 UTC m=+1075.829076450"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 1 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select dolt_hashof('HEAD')" queryTime="2025-08-27 20:48:11.804576341 +0000 UTC m=+1075.830173617"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select * from dolt_log('hi1k4vuacq7cr1hm4aba3b57babrbbft', '--parents', '--decorate=full')" queryTime="2025-08-27 20:48:11.804757424 +0000 UTC m=+1075.830354658"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 44 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select * from dolt_log('hi1k4vuacq7cr1hm4aba3b57babrbbft', '--parents', '--decorate=full')" queryTime="2025-08-27 20:48:11.848939549 +0000 UTC m=+1075.874536825"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_branches where hash = 'hi1k4vuacq7cr1hm4aba3b57babrbbft'" queryTime="2025-08-27 20:48:11.849446591 +0000 UTC m=+1075.875043908"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 1 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_branches where hash = 'hi1k4vuacq7cr1hm4aba3b57babrbbft'" queryTime="2025-08-27 20:48:11.850605966 +0000 UTC m=+1075.876203200"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_remote_branches where hash = 'hi1k4vuacq7cr1hm4aba3b57babrbbft'" queryTime="2025-08-27 20:48:11.850752966 +0000 UTC m=+1075.876350242"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_remote_branches where hash = 'hi1k4vuacq7cr1hm4aba3b57babrbbft'" queryTime="2025-08-27 20:48:11.851423549 +0000 UTC m=+1075.877020783"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select tag_name from dolt_tags where tag_hash = 'hi1k4vuacq7cr1hm4aba3b57babrbbft'" queryTime="2025-08-27 20:48:11.851565299 +0000 UTC m=+1075.877162575"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 4 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select tag_name from dolt_tags where tag_hash = 'hi1k4vuacq7cr1hm4aba3b57babrbbft'" queryTime="2025-08-27 20:48:11.856293674 +0000 UTC m=+1075.881890950"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select dolt_hashof('HEAD')" queryTime="2025-08-27 20:48:11.856433383 +0000 UTC m=+1075.882030658"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select dolt_hashof('HEAD')" queryTime="2025-08-27 20:48:11.856711508 +0000 UTC m=+1075.882308742"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select * from dolt_log('2t7ug4sairumijnb0vei9uviqit8tghk', '--parents', '--decorate=full')" queryTime="2025-08-27 20:48:11.856821174 +0000 UTC m=+1075.882418408"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 73 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select * from dolt_log('2t7ug4sairumijnb0vei9uviqit8tghk', '--parents', '--decorate=full')" queryTime="2025-08-27 20:48:11.930246716 +0000 UTC m=+1075.955843950"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_branches where hash = '2t7ug4sairumijnb0vei9uviqit8tghk'" queryTime="2025-08-27 20:48:11.930846883 +0000 UTC m=+1075.956444158"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 1 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_branches where hash = '2t7ug4sairumijnb0vei9uviqit8tghk'" queryTime="2025-08-27 20:48:11.931779174 +0000 UTC m=+1075.957376408"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_remote_branches where hash = '2t7ug4sairumijnb0vei9uviqit8tghk'" queryTime="2025-08-27 20:48:11.931908424 +0000 UTC m=+1075.957505700"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_remote_branches where hash = '2t7ug4sairumijnb0vei9uviqit8tghk'" queryTime="2025-08-27 20:48:11.932375216 +0000 UTC m=+1075.957972492"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select tag_name from dolt_tags where tag_hash = '2t7ug4sairumijnb0vei9uviqit8tghk'" queryTime="2025-08-27 20:48:11.932481549 +0000 UTC m=+1075.958078783"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 6 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select tag_name from dolt_tags where tag_hash = '2t7ug4sairumijnb0vei9uviqit8tghk'" queryTime="2025-08-27 20:48:11.938951091 +0000 UTC m=+1075.964548367"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select dolt_hashof('HEAD')" queryTime="2025-08-27 20:48:11.939115799 +0000 UTC m=+1075.964713033"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select dolt_hashof('HEAD')" queryTime="2025-08-27 20:48:11.939441716 +0000 UTC m=+1075.965038950"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select * from dolt_log('sh822r3dm25kbo5uiobho83u5004r4ji', '--parents', '--decorate=full')" queryTime="2025-08-27 20:48:11.939568008 +0000 UTC m=+1075.965165242"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 47 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select * from dolt_log('sh822r3dm25kbo5uiobho83u5004r4ji', '--parents', '--decorate=full')" queryTime="2025-08-27 20:48:11.987166174 +0000 UTC m=+1076.012763408"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_branches where hash = 'sh822r3dm25kbo5uiobho83u5004r4ji'" queryTime="2025-08-27 20:48:11.987806258 +0000 UTC m=+1076.013403492"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_branches where hash = 'sh822r3dm25kbo5uiobho83u5004r4ji'" queryTime="2025-08-27 20:48:11.988354508 +0000 UTC m=+1076.013951783"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_remote_branches where hash = 'sh822r3dm25kbo5uiobho83u5004r4ji'" queryTime="2025-08-27 20:48:11.988473924 +0000 UTC m=+1076.014071158"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_remote_branches where hash = 'sh822r3dm25kbo5uiobho83u5004r4ji'" queryTime="2025-08-27 20:48:11.989066383 +0000 UTC m=+1076.014663658"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select tag_name from dolt_tags where tag_hash = 'sh822r3dm25kbo5uiobho83u5004r4ji'" queryTime="2025-08-27 20:48:11.989186008 +0000 UTC m=+1076.014783283"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 4 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select tag_name from dolt_tags where tag_hash = 'sh822r3dm25kbo5uiobho83u5004r4ji'" queryTime="2025-08-27 20:48:11.994012383 +0000 UTC m=+1076.019609617"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select dolt_hashof('HEAD')" queryTime="2025-08-27 20:48:11.994247883 +0000 UTC m=+1076.019845158"
 time="2025-08-27T20:48:11Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select dolt_hashof('HEAD')" queryTime="2025-08-27 20:48:11.994481633 +0000 UTC m=+1076.020078908"
 time="2025-08-27T20:48:11Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select * from dolt_log('mh0ank3mtter1on381b159pcj4i7v04v', '--parents', '--decorate=full')" queryTime="2025-08-27 20:48:11.994607008 +0000 UTC m=+1076.020204242"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 36 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select * from dolt_log('mh0ank3mtter1on381b159pcj4i7v04v', '--parents', '--decorate=full')" queryTime="2025-08-27 20:48:12.031072174 +0000 UTC m=+1076.056669450"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_branches where hash = 'mh0ank3mtter1on381b159pcj4i7v04v'" queryTime="2025-08-27 20:48:12.031470049 +0000 UTC m=+1076.057067325"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_branches where hash = 'mh0ank3mtter1on381b159pcj4i7v04v'" queryTime="2025-08-27 20:48:12.032100883 +0000 UTC m=+1076.057698158"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_remote_branches where hash = 'mh0ank3mtter1on381b159pcj4i7v04v'" queryTime="2025-08-27 20:48:12.032223133 +0000 UTC m=+1076.057820408"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_remote_branches where hash = 'mh0ank3mtter1on381b159pcj4i7v04v'" queryTime="2025-08-27 20:48:12.032632508 +0000 UTC m=+1076.058229783"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select tag_name from dolt_tags where tag_hash = 'mh0ank3mtter1on381b159pcj4i7v04v'" queryTime="2025-08-27 20:48:12.032744258 +0000 UTC m=+1076.058341492"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 3 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select tag_name from dolt_tags where tag_hash = 'mh0ank3mtter1on381b159pcj4i7v04v'" queryTime="2025-08-27 20:48:12.036652216 +0000 UTC m=+1076.062249450"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select dolt_hashof('HEAD')" queryTime="2025-08-27 20:48:12.036772716 +0000 UTC m=+1076.062369992"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select dolt_hashof('HEAD')" queryTime="2025-08-27 20:48:12.037134008 +0000 UTC m=+1076.062731283"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select * from dolt_log('dg0bn3a6dcvrq2brimn3dgh7hllpo6pj', '--parents', '--decorate=full')" queryTime="2025-08-27 20:48:12.037301799 +0000 UTC m=+1076.062899033"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 36 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select * from dolt_log('dg0bn3a6dcvrq2brimn3dgh7hllpo6pj', '--parents', '--decorate=full')" queryTime="2025-08-27 20:48:12.073836883 +0000 UTC m=+1076.099434158"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_branches where hash = 'dg0bn3a6dcvrq2brimn3dgh7hllpo6pj'" queryTime="2025-08-27 20:48:12.074273341 +0000 UTC m=+1076.099870617"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_branches where hash = 'dg0bn3a6dcvrq2brimn3dgh7hllpo6pj'" queryTime="2025-08-27 20:48:12.074894091 +0000 UTC m=+1076.100491367"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_remote_branches where hash = 'dg0bn3a6dcvrq2brimn3dgh7hllpo6pj'" queryTime="2025-08-27 20:48:12.075023633 +0000 UTC m=+1076.100620867"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_remote_branches where hash = 'dg0bn3a6dcvrq2brimn3dgh7hllpo6pj'" queryTime="2025-08-27 20:48:12.075671799 +0000 UTC m=+1076.101269075"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select tag_name from dolt_tags where tag_hash = 'dg0bn3a6dcvrq2brimn3dgh7hllpo6pj'" queryTime="2025-08-27 20:48:12.075780008 +0000 UTC m=+1076.101377242"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 4 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select tag_name from dolt_tags where tag_hash = 'dg0bn3a6dcvrq2brimn3dgh7hllpo6pj'" queryTime="2025-08-27 20:48:12.079872383 +0000 UTC m=+1076.105469617"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select dolt_hashof('HEAD')" queryTime="2025-08-27 20:48:12.079982633 +0000 UTC m=+1076.105579908"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select dolt_hashof('HEAD')" queryTime="2025-08-27 20:48:12.080206091 +0000 UTC m=+1076.105803325"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select * from dolt_log('uc6puai2326ncuos0q4u8bhub3oo7cmb', '--parents', '--decorate=full')" queryTime="2025-08-27 20:48:12.080339299 +0000 UTC m=+1076.105936533"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 38 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select * from dolt_log('uc6puai2326ncuos0q4u8bhub3oo7cmb', '--parents', '--decorate=full')" queryTime="2025-08-27 20:48:12.118413383 +0000 UTC m=+1076.144010658"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_branches where hash = 'uc6puai2326ncuos0q4u8bhub3oo7cmb'" queryTime="2025-08-27 20:48:12.118768049 +0000 UTC m=+1076.144365325"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_branches where hash = 'uc6puai2326ncuos0q4u8bhub3oo7cmb'" queryTime="2025-08-27 20:48:12.119493924 +0000 UTC m=+1076.145091200"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_remote_branches where hash = 'uc6puai2326ncuos0q4u8bhub3oo7cmb'" queryTime="2025-08-27 20:48:12.119628674 +0000 UTC m=+1076.145225908"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_remote_branches where hash = 'uc6puai2326ncuos0q4u8bhub3oo7cmb'" queryTime="2025-08-27 20:48:12.120188633 +0000 UTC m=+1076.145785867"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select tag_name from dolt_tags where tag_hash = 'uc6puai2326ncuos0q4u8bhub3oo7cmb'" queryTime="2025-08-27 20:48:12.120293841 +0000 UTC m=+1076.145891075"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 4 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select tag_name from dolt_tags where tag_hash = 'uc6puai2326ncuos0q4u8bhub3oo7cmb'" queryTime="2025-08-27 20:48:12.124653841 +0000 UTC m=+1076.150251117"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select dolt_hashof('HEAD')" queryTime="2025-08-27 20:48:12.124788341 +0000 UTC m=+1076.150385575"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select dolt_hashof('HEAD')" queryTime="2025-08-27 20:48:12.125211924 +0000 UTC m=+1076.150809158"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select * from dolt_log('fc61k034lvn794695qqsmk1ubduif72v', '--parents', '--decorate=full')" queryTime="2025-08-27 20:48:12.125333299 +0000 UTC m=+1076.150930533"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 41 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select * from dolt_log('fc61k034lvn794695qqsmk1ubduif72v', '--parents', '--decorate=full')" queryTime="2025-08-27 20:48:12.166472799 +0000 UTC m=+1076.192070033"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_branches where hash = 'fc61k034lvn794695qqsmk1ubduif72v'" queryTime="2025-08-27 20:48:12.166910008 +0000 UTC m=+1076.192507283"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_branches where hash = 'fc61k034lvn794695qqsmk1ubduif72v'" queryTime="2025-08-27 20:48:12.167650299 +0000 UTC m=+1076.193247575"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_remote_branches where hash = 'fc61k034lvn794695qqsmk1ubduif72v'" queryTime="2025-08-27 20:48:12.167782508 +0000 UTC m=+1076.193379742"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select name, hash from dolt_remote_branches where hash = 'fc61k034lvn794695qqsmk1ubduif72v'" queryTime="2025-08-27 20:48:12.168294174 +0000 UTC m=+1076.193891408"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select tag_name from dolt_tags where tag_hash = 'fc61k034lvn794695qqsmk1ubduif72v'" queryTime="2025-08-27 20:48:12.168416758 +0000 UTC m=+1076.194014033"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 4 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select tag_name from dolt_tags where tag_hash = 'fc61k034lvn794695qqsmk1ubduif72v'" queryTime="2025-08-27 20:48:12.172818174 +0000 UTC m=+1076.198415450"
 time="2025-08-27T20:48:12Z" level=debug msg="Starting query" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select dolt_hashof('HEAD')" queryTime="2025-08-27 20:48:12.172933924 +0000 UTC m=+1076.198531200"
 time="2025-08-27T20:48:12Z" level=debug msg="Query finished in 0 ms" connectTime="2025-08-27 20:48:11.776818674 +0000 UTC m=+1075.802416033" connectionDb=org1 connectionID=5 query="select dolt_hashof('HEAD')" queryTime="2025-08-27 20:48:12.173207466 +0000 UTC m=+1076.198804742"

[timsehn]

We'll see what we can do.

Is your application really sensitive to sub-100ms latency?

Or is this more like, why is it 10-100X slower than a normal log query? Seems like a bug.

Just trying to judge urgency.

[sfenig]

It's not so much for application, as for customer support playbooks and not really urgent. We're transitioning from git to dolt and formerly a playbook would've included the use of git log to quickly see what's been changed or deployed. I was evaluating dolt log as an option for the playbooks in addition to a set of useful queries for a starting point. But without -n that would take days to respond at some of our customers. For this particular case, if I could enforce a 1000 commit limit, that might work, but even that is too long to be useful and is slamming the db pretty hard. I probably won't introduce the cli as something in the tool belt if it could easily end up slamming customer databases with 100000+ queries because they ran dolt log with no params.

[timsehn]

OK. I'll have @jycor profile it and see if he can see anything slow.

[jycor]

Hey @sfenig, we've found a few areas where we could improve with dolt log and merged those changes into to dolt main; there should be a roughly 1.7x speed up when running select * from dolt_log() with a few hundred commits.
I'm continuing to look for other solutions to improve the speed up.

[jycor]

We added some caching to further improve the runtime for dolt_log(). There is roughly a 4-5x improvement.
This optimization is in dolt main and will be in the next dolt release.

Let us know if this is good enough for your use case.