Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Performance painfully slow exporting large number of inspection-items #209

Open
jashwood opened this issue Feb 14, 2022 · 4 comments
Open

Performance painfully slow exporting large number of inspection-items #209

jashwood opened this issue Feb 14, 2022 · 4 comments
Assignees
@hkf57

Comments

@jashwood
Copy link

Hey there,

We have over 100,000 inspection_item records.. exporting these to csv takes over an hour, sometimes more.
Can the performance be improved somehow?
@hkf57
Copy link
Member

hkf57 commented Feb 23, 2022

Hi @jashwood, I'd like to understand more about your setup. What kind of machine/platform are you running on?

@hkf57 hkf57 self-assigned this Feb 23, 2022
@jashwood
Copy link
Author

We are running on Windows Server 2019, 20 core IaaS VM in SQL Azure, with 140GB of ram and a 10Gbps internet connection, and very high performance disks

@OscarBarrett
Copy link

OscarBarrett commented Dec 12, 2022 •
edited
Loading

We have the same issue (with 535k inspection items), on both linux x64 and darwin ARM.

Query time gets linearly slower and slower for each batch that is written out so there is some inefficiency with the SQLite queries.

e.g. on a high performance Mac Studio, export takes 30 minutes. Our deployment environment allocates significantly lower IOPS and takes over 5 hours.

Example output from a dev machine: 
2022-12-12T12:01:06.279+0800    INFO    [email protected]    writing out CSV file    {"feed": "inspection_items"}
2022-12-12T12:01:06.510+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 197, "query_time_ms": 158, "write_time_ms": 39}
2022-12-12T12:01:06.722+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 212, "query_time_ms": 172, "write_time_ms": 40}
2022-12-12T12:01:06.953+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 230, "query_time_ms": 189, "write_time_ms": 41}
2022-12-12T12:01:07.217+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 264, "query_time_ms": 207, "write_time_ms": 57}
2022-12-12T12:01:07.475+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 257, "query_time_ms": 217, "write_time_ms": 40}
2022-12-12T12:01:07.745+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 270, "query_time_ms": 233, "write_time_ms": 36}
2022-12-12T12:01:08.030+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 285, "query_time_ms": 248, "write_time_ms": 36}
2022-12-12T12:01:08.332+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 301, "query_time_ms": 264, "write_time_ms": 37}
2022-12-12T12:01:08.658+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 325, "query_time_ms": 290, "write_time_ms": 35}
2022-12-12T12:01:08.983+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 324, "query_time_ms": 288, "write_time_ms": 36}
2022-12-12T12:01:09.327+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 343, "query_time_ms": 305, "write_time_ms": 37}
2022-12-12T12:01:09.691+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 364, "query_time_ms": 326, "write_time_ms": 37}
2022-12-12T12:01:10.062+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 370, "query_time_ms": 334, "write_time_ms": 36}
2022-12-12T12:01:10.452+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 389, "query_time_ms": 351, "write_time_ms": 38}
2022-12-12T12:01:10.857+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 405, "query_time_ms": 367, "write_time_ms": 38}
2022-12-12T12:01:11.290+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 432, "query_time_ms": 394, "write_time_ms": 38}
2022-12-12T12:01:11.741+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 451, "query_time_ms": 410, "write_time_ms": 41}
2022-12-12T12:01:12.204+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 462, "query_time_ms": 425, "write_time_ms": 37}
2022-12-12T12:01:12.672+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 467, "query_time_ms": 431, "write_time_ms": 36}
2022-12-12T12:01:13.153+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 480, "query_time_ms": 443, "write_time_ms": 37}
2022-12-12T12:01:13.656+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 502, "query_time_ms": 466, "write_time_ms": 36}
2022-12-12T12:01:14.174+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 517, "query_time_ms": 479, "write_time_ms": 38}
2022-12-12T12:01:14.696+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 521, "query_time_ms": 484, "write_time_ms": 37}
2022-12-12T12:01:15.233+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 537, "query_time_ms": 500, "write_time_ms": 36}
2022-12-12T12:01:15.791+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 558, "query_time_ms": 520, "write_time_ms": 37}
2022-12-12T12:01:16.361+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 569, "query_time_ms": 533, "write_time_ms": 36}
2022-12-12T12:01:16.953+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 592, "query_time_ms": 554, "write_time_ms": 37}
2022-12-12T12:01:17.563+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 609, "query_time_ms": 571, "write_time_ms": 37}
2022-12-12T12:01:18.178+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 615, "query_time_ms": 578, "write_time_ms": 37}
2022-12-12T12:01:18.807+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 628, "query_time_ms": 590, "write_time_ms": 38}
2022-12-12T12:01:19.454+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 647, "query_time_ms": 610, "write_time_ms": 36}
2022-12-12T12:01:20.121+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 666, "query_time_ms": 629, "write_time_ms": 37}
2022-12-12T12:01:20.810+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 689, "query_time_ms": 652, "write_time_ms": 36}
2022-12-12T12:01:21.498+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 687, "query_time_ms": 650, "write_time_ms": 37}
2022-12-12T12:01:22.203+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 705, "query_time_ms": 667, "write_time_ms": 37}
2022-12-12T12:01:22.925+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 721, "query_time_ms": 684, "write_time_ms": 37}
2022-12-12T12:01:23.669+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 744, "query_time_ms": 707, "write_time_ms": 37}
2022-12-12T12:01:24.421+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 751, "query_time_ms": 714, "write_time_ms": 37}
2022-12-12T12:01:25.199+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 777, "query_time_ms": 740, "write_time_ms": 37}
2022-12-12T12:01:25.978+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 779, "query_time_ms": 740, "write_time_ms": 38}
2022-12-12T12:01:26.774+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 795, "query_time_ms": 758, "write_time_ms": 37}
2022-12-12T12:01:27.594+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 819, "query_time_ms": 782, "write_time_ms": 37}
2022-12-12T12:01:28.437+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 843, "query_time_ms": 805, "write_time_ms": 37}
2022-12-12T12:01:29.277+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 840, "query_time_ms": 803, "write_time_ms": 36}
2022-12-12T12:01:30.142+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 865, "query_time_ms": 827, "write_time_ms": 37}
2022-12-12T12:01:31.030+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 887, "query_time_ms": 849, "write_time_ms": 37}
2022-12-12T12:01:31.913+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 883, "query_time_ms": 845, "write_time_ms": 37}
2022-12-12T12:01:32.884+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 970, "query_time_ms": 932, "write_time_ms": 37}
2022-12-12T12:01:33.816+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 932, "query_time_ms": 894, "write_time_ms": 37}
2022-12-12T12:01:34.783+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 967, "query_time_ms": 928, "write_time_ms": 38}
2022-12-12T12:01:35.743+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 959, "query_time_ms": 921, "write_time_ms": 37}
2022-12-12T12:01:36.710+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 966, "query_time_ms": 929, "write_time_ms": 37}
2022-12-12T12:01:37.711+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1001, "query_time_ms": 965, "write_time_ms": 36}
2022-12-12T12:01:38.711+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 999, "query_time_ms": 962, "write_time_ms": 37}
2022-12-12T12:01:39.729+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1018, "query_time_ms": 980, "write_time_ms": 37}
2022-12-12T12:01:40.764+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1034, "query_time_ms": 997, "write_time_ms": 36}
2022-12-12T12:01:41.815+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1051, "query_time_ms": 1012, "write_time_ms": 39}
2022-12-12T12:01:42.906+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1090, "query_time_ms": 1053, "write_time_ms": 37}
2022-12-12T12:01:43.987+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1081, "query_time_ms": 1045, "write_time_ms": 36}
2022-12-12T12:01:45.089+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1101, "query_time_ms": 1063, "write_time_ms": 38}
2022-12-12T12:01:46.204+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1114, "query_time_ms": 1077, "write_time_ms": 37}
2022-12-12T12:01:47.334+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1130, "query_time_ms": 1092, "write_time_ms": 37}
2022-12-12T12:01:48.470+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1135, "query_time_ms": 1099, "write_time_ms": 36}
2022-12-12T12:01:49.620+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1149, "query_time_ms": 1111, "write_time_ms": 38}
2022-12-12T12:01:50.780+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1160, "query_time_ms": 1122, "write_time_ms": 37}
2022-12-12T12:01:51.949+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1168, "query_time_ms": 1132, "write_time_ms": 36}
2022-12-12T12:01:53.142+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1193, "query_time_ms": 1154, "write_time_ms": 39}
2022-12-12T12:01:54.356+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1213, "query_time_ms": 1177, "write_time_ms": 36}
2022-12-12T12:01:55.575+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1218, "query_time_ms": 1181, "write_time_ms": 36}
2022-12-12T12:01:56.826+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1251, "query_time_ms": 1213, "write_time_ms": 37}
2022-12-12T12:01:58.077+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1250, "query_time_ms": 1214, "write_time_ms": 36}
2022-12-12T12:01:59.343+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1266, "query_time_ms": 1228, "write_time_ms": 37}
2022-12-12T12:02:00.619+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1275, "query_time_ms": 1238, "write_time_ms": 36}
2022-12-12T12:02:01.912+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1293, "query_time_ms": 1256, "write_time_ms": 36}
2022-12-12T12:02:03.235+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1322, "query_time_ms": 1284, "write_time_ms": 37}
2022-12-12T12:02:04.604+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1369, "query_time_ms": 1331, "write_time_ms": 37}
2022-12-12T12:02:06.016+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1411, "query_time_ms": 1373, "write_time_ms": 37}
2022-12-12T12:02:07.391+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1374, "query_time_ms": 1337, "write_time_ms": 36}
2022-12-12T12:02:08.809+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1418, "query_time_ms": 1380, "write_time_ms": 38}
2022-12-12T12:02:10.280+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1470, "query_time_ms": 1432, "write_time_ms": 37}
2022-12-12T12:02:11.695+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1414, "query_time_ms": 1378, "write_time_ms": 36}
2022-12-12T12:02:13.154+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1459, "query_time_ms": 1421, "write_time_ms": 38}
2022-12-12T12:02:14.657+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1503, "query_time_ms": 1465, "write_time_ms": 37}
2022-12-12T12:02:16.120+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1462, "query_time_ms": 1425, "write_time_ms": 37}
2022-12-12T12:02:17.584+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1464, "query_time_ms": 1427, "write_time_ms": 37}
2022-12-12T12:02:19.062+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1477, "query_time_ms": 1440, "write_time_ms": 36}
2022-12-12T12:02:20.601+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1538, "query_time_ms": 1501, "write_time_ms": 36}
2022-12-12T12:02:22.156+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1555, "query_time_ms": 1518, "write_time_ms": 36}
2022-12-12T12:02:23.766+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1610, "query_time_ms": 1572, "write_time_ms": 37}
2022-12-12T12:02:25.359+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1592, "query_time_ms": 1555, "write_time_ms": 37}
2022-12-12T12:02:26.939+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1579, "query_time_ms": 1542, "write_time_ms": 37}
2022-12-12T12:02:28.540+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1600, "query_time_ms": 1563, "write_time_ms": 37}
2022-12-12T12:02:30.152+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1612, "query_time_ms": 1576, "write_time_ms": 36}
2022-12-12T12:02:31.771+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1618, "query_time_ms": 1580, "write_time_ms": 38}
2022-12-12T12:02:33.389+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1617, "query_time_ms": 1581, "write_time_ms": 35}
2022-12-12T12:02:35.044+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1655, "query_time_ms": 1618, "write_time_ms": 37}
2022-12-12T12:02:36.733+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1688, "query_time_ms": 1652, "write_time_ms": 36}
2022-12-12T12:02:38.412+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1679, "query_time_ms": 1642, "write_time_ms": 37}
2022-12-12T12:02:40.130+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1718, "query_time_ms": 1677, "write_time_ms": 40}
2022-12-12T12:02:41.869+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1738, "query_time_ms": 1702, "write_time_ms": 36}
2022-12-12T12:02:43.603+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1734, "query_time_ms": 1692, "write_time_ms": 41}
2022-12-12T12:02:45.403+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1799, "query_time_ms": 1763, "write_time_ms": 35}
2022-12-12T12:02:47.156+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1752, "query_time_ms": 1716, "write_time_ms": 35}
2022-12-12T12:02:48.928+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1771, "query_time_ms": 1735, "write_time_ms": 36}
2022-12-12T12:02:50.733+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1804, "query_time_ms": 1769, "write_time_ms": 35}
2022-12-12T12:02:52.538+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1805, "query_time_ms": 1768, "write_time_ms": 36}
2022-12-12T12:02:54.369+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1830, "query_time_ms": 1793, "write_time_ms": 36}
2022-12-12T12:02:56.197+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1827, "query_time_ms": 1792, "write_time_ms": 35}
2022-12-12T12:02:58.040+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1843, "query_time_ms": 1807, "write_time_ms": 35}
2022-12-12T12:02:59.894+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1853, "query_time_ms": 1818, "write_time_ms": 35}
2022-12-12T12:03:01.747+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1853, "query_time_ms": 1817, "write_time_ms": 35}
2022-12-12T12:03:03.623+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1875, "query_time_ms": 1839, "write_time_ms": 36}
2022-12-12T12:03:05.534+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1910, "query_time_ms": 1872, "write_time_ms": 37}
2022-12-12T12:03:07.459+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1925, "query_time_ms": 1888, "write_time_ms": 37}
2022-12-12T12:03:09.378+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1919, "query_time_ms": 1882, "write_time_ms": 36}
2022-12-12T12:03:11.374+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1995, "query_time_ms": 1957, "write_time_ms": 37}
2022-12-12T12:03:13.375+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2000, "query_time_ms": 1963, "write_time_ms": 37}
2022-12-12T12:03:15.415+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2040, "query_time_ms": 2001, "write_time_ms": 38}
2022-12-12T12:03:17.402+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 1986, "query_time_ms": 1950, "write_time_ms": 36}
2022-12-12T12:03:19.420+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2017, "query_time_ms": 1981, "write_time_ms": 36}
2022-12-12T12:03:21.491+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2071, "query_time_ms": 2030, "write_time_ms": 40}
2022-12-12T12:03:23.571+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2080, "query_time_ms": 2043, "write_time_ms": 37}
2022-12-12T12:03:25.647+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2075, "query_time_ms": 2038, "write_time_ms": 37}
2022-12-12T12:03:27.769+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2122, "query_time_ms": 2084, "write_time_ms": 37}
2022-12-12T12:03:29.900+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2130, "query_time_ms": 2092, "write_time_ms": 38}
2022-12-12T12:03:32.001+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2101, "query_time_ms": 2064, "write_time_ms": 36}
2022-12-12T12:03:34.112+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2110, "query_time_ms": 2073, "write_time_ms": 37}
2022-12-12T12:03:36.267+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2155, "query_time_ms": 2117, "write_time_ms": 37}
2022-12-12T12:03:38.459+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2191, "query_time_ms": 2153, "write_time_ms": 38}
2022-12-12T12:03:40.620+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2161, "query_time_ms": 2123, "write_time_ms": 37}
2022-12-12T12:03:42.892+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2271, "query_time_ms": 2233, "write_time_ms": 38}
2022-12-12T12:03:45.199+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2306, "query_time_ms": 2267, "write_time_ms": 38}
2022-12-12T12:03:47.458+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2259, "query_time_ms": 2220, "write_time_ms": 38}
2022-12-12T12:03:49.766+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2307, "query_time_ms": 2268, "write_time_ms": 38}
2022-12-12T12:03:52.095+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2329, "query_time_ms": 2290, "write_time_ms": 38}
2022-12-12T12:03:54.467+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2371, "query_time_ms": 2332, "write_time_ms": 38}
2022-12-12T12:03:56.813+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2346, "query_time_ms": 2309, "write_time_ms": 37}
2022-12-12T12:03:59.151+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2337, "query_time_ms": 2299, "write_time_ms": 37}
2022-12-12T12:04:01.511+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2359, "query_time_ms": 2322, "write_time_ms": 37}
2022-12-12T12:04:03.869+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2358, "query_time_ms": 2321, "write_time_ms": 36}
2022-12-12T12:04:06.232+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2362, "query_time_ms": 2324, "write_time_ms": 37}
2022-12-12T12:04:08.657+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2425, "query_time_ms": 2385, "write_time_ms": 40}
2022-12-12T12:04:11.144+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2486, "query_time_ms": 2448, "write_time_ms": 37}
2022-12-12T12:04:13.590+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2446, "query_time_ms": 2408, "write_time_ms": 37}
2022-12-12T12:04:16.083+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2493, "query_time_ms": 2454, "write_time_ms": 38}
2022-12-12T12:04:18.584+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2500, "query_time_ms": 2464, "write_time_ms": 36}
2022-12-12T12:04:21.114+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2529, "query_time_ms": 2491, "write_time_ms": 38}
2022-12-12T12:04:23.655+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2540, "query_time_ms": 2503, "write_time_ms": 36}
2022-12-12T12:04:26.154+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2499, "query_time_ms": 2461, "write_time_ms": 38}
2022-12-12T12:04:28.752+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2597, "query_time_ms": 2559, "write_time_ms": 37}
2022-12-12T12:04:31.237+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2485, "query_time_ms": 2447, "write_time_ms": 37}
2022-12-12T12:04:33.820+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2583, "query_time_ms": 2543, "write_time_ms": 39}
2022-12-12T12:04:36.399+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2578, "query_time_ms": 2542, "write_time_ms": 36}
2022-12-12T12:04:39.012+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2612, "query_time_ms": 2574, "write_time_ms": 38}
2022-12-12T12:04:41.561+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2549, "query_time_ms": 2511, "write_time_ms": 37}
2022-12-12T12:04:44.210+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2649, "query_time_ms": 2612, "write_time_ms": 37}
2022-12-12T12:04:46.844+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2633, "query_time_ms": 2595, "write_time_ms": 38}
2022-12-12T12:04:49.453+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2608, "query_time_ms": 2572, "write_time_ms": 36}
2022-12-12T12:04:52.151+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2698, "query_time_ms": 2659, "write_time_ms": 38}
2022-12-12T12:04:54.828+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2677, "query_time_ms": 2639, "write_time_ms": 37}
2022-12-12T12:04:57.441+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2612, "query_time_ms": 2575, "write_time_ms": 37}
2022-12-12T12:05:00.106+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2665, "query_time_ms": 2627, "write_time_ms": 38}
2022-12-12T12:05:02.817+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2711, "query_time_ms": 2673, "write_time_ms": 37}
2022-12-12T12:05:05.537+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2719, "query_time_ms": 2680, "write_time_ms": 39}
2022-12-12T12:05:08.326+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2788, "query_time_ms": 2751, "write_time_ms": 37}
2022-12-12T12:05:11.023+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2696, "query_time_ms": 2658, "write_time_ms": 37}
2022-12-12T12:05:13.733+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2710, "query_time_ms": 2672, "write_time_ms": 37}
2022-12-12T12:05:16.474+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2740, "query_time_ms": 2702, "write_time_ms": 38}
2022-12-12T12:05:19.290+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2815, "query_time_ms": 2777, "write_time_ms": 38}
2022-12-12T12:05:22.231+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2940, "query_time_ms": 2902, "write_time_ms": 37}
2022-12-12T12:05:25.030+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2798, "query_time_ms": 2761, "write_time_ms": 37}
2022-12-12T12:05:27.838+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2808, "query_time_ms": 2769, "write_time_ms": 38}
2022-12-12T12:05:30.631+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2791, "query_time_ms": 2752, "write_time_ms": 38}
2022-12-12T12:05:33.475+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2842, "query_time_ms": 2805, "write_time_ms": 37}
2022-12-12T12:05:36.298+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2821, "query_time_ms": 2784, "write_time_ms": 37}
2022-12-12T12:05:39.140+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2841, "query_time_ms": 2804, "write_time_ms": 37}
2022-12-12T12:05:41.993+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2852, "query_time_ms": 2815, "write_time_ms": 36}
2022-12-12T12:05:44.985+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2991, "query_time_ms": 2953, "write_time_ms": 37}
2022-12-12T12:05:47.918+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2931, "query_time_ms": 2893, "write_time_ms": 37}
2022-12-12T12:05:50.886+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2968, "query_time_ms": 2931, "write_time_ms": 37}
2022-12-12T12:05:53.854+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2966, "query_time_ms": 2927, "write_time_ms": 39}
2022-12-12T12:05:56.818+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2964, "query_time_ms": 2927, "write_time_ms": 37}
2022-12-12T12:05:59.794+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 2974, "query_time_ms": 2937, "write_time_ms": 37}
2022-12-12T12:06:02.803+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3008, "query_time_ms": 2968, "write_time_ms": 39}
2022-12-12T12:06:05.825+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3021, "query_time_ms": 2984, "write_time_ms": 37}
2022-12-12T12:06:08.859+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3033, "query_time_ms": 2996, "write_time_ms": 37}
2022-12-12T12:06:11.931+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3071, "query_time_ms": 3034, "write_time_ms": 37}
2022-12-12T12:06:14.968+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3037, "query_time_ms": 2999, "write_time_ms": 37}
2022-12-12T12:06:18.133+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3165, "query_time_ms": 3125, "write_time_ms": 39}
2022-12-12T12:06:21.193+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3059, "query_time_ms": 3023, "write_time_ms": 36}
2022-12-12T12:06:24.276+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3082, "query_time_ms": 3044, "write_time_ms": 37}
2022-12-12T12:06:27.420+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3143, "query_time_ms": 3106, "write_time_ms": 37}
2022-12-12T12:06:30.518+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3097, "query_time_ms": 3059, "write_time_ms": 38}
2022-12-12T12:06:33.662+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3144, "query_time_ms": 3107, "write_time_ms": 36}
2022-12-12T12:06:36.784+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3121, "query_time_ms": 3084, "write_time_ms": 37}
2022-12-12T12:06:39.995+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3211, "query_time_ms": 3173, "write_time_ms": 37}
2022-12-12T12:06:43.161+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3166, "query_time_ms": 3128, "write_time_ms": 37}
2022-12-12T12:06:46.423+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3261, "query_time_ms": 3221, "write_time_ms": 39}
2022-12-12T12:06:49.696+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3273, "query_time_ms": 3236, "write_time_ms": 37}
2022-12-12T12:06:52.958+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3261, "query_time_ms": 3222, "write_time_ms": 38}
2022-12-12T12:06:56.205+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3246, "query_time_ms": 3205, "write_time_ms": 41}
2022-12-12T12:06:59.468+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3263, "query_time_ms": 3226, "write_time_ms": 37}
2022-12-12T12:07:02.811+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3342, "query_time_ms": 3305, "write_time_ms": 37}
2022-12-12T12:07:06.137+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3325, "query_time_ms": 3289, "write_time_ms": 36}
2022-12-12T12:07:09.493+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3356, "query_time_ms": 3320, "write_time_ms": 36}
2022-12-12T12:07:12.824+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3330, "query_time_ms": 3294, "write_time_ms": 36}
2022-12-12T12:07:16.150+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3325, "query_time_ms": 3290, "write_time_ms": 35}
2022-12-12T12:07:19.506+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3355, "query_time_ms": 3319, "write_time_ms": 35}
2022-12-12T12:07:22.921+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3415, "query_time_ms": 3379, "write_time_ms": 35}
2022-12-12T12:07:26.433+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3511, "query_time_ms": 3476, "write_time_ms": 35}
2022-12-12T12:07:29.914+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3480, "query_time_ms": 3443, "write_time_ms": 36}
2022-12-12T12:07:33.406+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3492, "query_time_ms": 3455, "write_time_ms": 36}
2022-12-12T12:07:36.905+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3499, "query_time_ms": 3461, "write_time_ms": 37}
2022-12-12T12:07:40.463+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3557, "query_time_ms": 3521, "write_time_ms": 35}
2022-12-12T12:07:44.009+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3546, "query_time_ms": 3509, "write_time_ms": 36}
2022-12-12T12:07:47.523+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3514, "query_time_ms": 3478, "write_time_ms": 35}
2022-12-12T12:07:50.999+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3476, "query_time_ms": 3439, "write_time_ms": 36}
2022-12-12T12:07:54.468+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3468, "query_time_ms": 3432, "write_time_ms": 36}
2022-12-12T12:07:57.982+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3514, "query_time_ms": 3478, "write_time_ms": 36}
2022-12-12T12:08:01.536+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3553, "query_time_ms": 3517, "write_time_ms": 35}
2022-12-12T12:08:05.063+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3526, "query_time_ms": 3490, "write_time_ms": 35}
2022-12-12T12:08:08.603+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3540, "query_time_ms": 3503, "write_time_ms": 36}
2022-12-12T12:08:12.217+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3614, "query_time_ms": 3578, "write_time_ms": 36}
2022-12-12T12:08:15.818+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3600, "query_time_ms": 3563, "write_time_ms": 36}
2022-12-12T12:08:19.476+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3658, "query_time_ms": 3622, "write_time_ms": 35}
2022-12-12T12:08:23.105+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3629, "query_time_ms": 3591, "write_time_ms": 37}
2022-12-12T12:08:26.699+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3593, "query_time_ms": 3557, "write_time_ms": 36}
2022-12-12T12:08:30.346+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3646, "query_time_ms": 3609, "write_time_ms": 36}
2022-12-12T12:08:34.041+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3695, "query_time_ms": 3658, "write_time_ms": 36}
2022-12-12T12:08:37.733+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3691, "query_time_ms": 3656, "write_time_ms": 35}
2022-12-12T12:08:41.427+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3693, "query_time_ms": 3655, "write_time_ms": 37}
2022-12-12T12:08:45.110+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3682, "query_time_ms": 3647, "write_time_ms": 35}
2022-12-12T12:08:49.021+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3910, "query_time_ms": 3874, "write_time_ms": 35}
2022-12-12T12:08:52.857+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3836, "query_time_ms": 3800, "write_time_ms": 36}
2022-12-12T12:08:56.767+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3909, "query_time_ms": 3868, "write_time_ms": 40}
2022-12-12T12:09:00.534+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3766, "query_time_ms": 3731, "write_time_ms": 35}
2022-12-12T12:09:04.315+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3781, "query_time_ms": 3745, "write_time_ms": 36}
2022-12-12T12:09:08.206+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3891, "query_time_ms": 3856, "write_time_ms": 34}
2022-12-12T12:09:12.053+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3846, "query_time_ms": 3810, "write_time_ms": 35}
2022-12-12T12:09:15.931+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3877, "query_time_ms": 3840, "write_time_ms": 37}
2022-12-12T12:09:19.952+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4020, "query_time_ms": 3983, "write_time_ms": 37}
2022-12-12T12:09:23.898+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3945, "query_time_ms": 3907, "write_time_ms": 37}
2022-12-12T12:09:27.852+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3954, "query_time_ms": 3919, "write_time_ms": 34}
2022-12-12T12:09:31.783+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3930, "query_time_ms": 3894, "write_time_ms": 35}
2022-12-12T12:09:35.719+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3935, "query_time_ms": 3899, "write_time_ms": 36}
2022-12-12T12:09:39.773+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4053, "query_time_ms": 4017, "write_time_ms": 35}
2022-12-12T12:09:43.762+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3988, "query_time_ms": 3952, "write_time_ms": 36}
2022-12-12T12:09:47.759+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 3997, "query_time_ms": 3961, "write_time_ms": 35}
2022-12-12T12:09:51.781+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4021, "query_time_ms": 3985, "write_time_ms": 35}
2022-12-12T12:09:55.865+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4083, "query_time_ms": 4046, "write_time_ms": 37}
2022-12-12T12:09:59.883+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4018, "query_time_ms": 3982, "write_time_ms": 36}
2022-12-12T12:10:03.891+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4007, "query_time_ms": 3971, "write_time_ms": 35}
2022-12-12T12:10:07.946+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4054, "query_time_ms": 4018, "write_time_ms": 36}
2022-12-12T12:10:11.955+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4009, "query_time_ms": 3973, "write_time_ms": 35}
2022-12-12T12:10:15.962+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4007, "query_time_ms": 3971, "write_time_ms": 35}
2022-12-12T12:10:20.002+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4039, "query_time_ms": 4002, "write_time_ms": 36}
2022-12-12T12:10:24.109+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4107, "query_time_ms": 4070, "write_time_ms": 36}
2022-12-12T12:10:28.243+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4133, "query_time_ms": 4097, "write_time_ms": 36}
2022-12-12T12:10:32.349+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4106, "query_time_ms": 4068, "write_time_ms": 37}
2022-12-12T12:10:36.441+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4091, "query_time_ms": 4056, "write_time_ms": 34}
2022-12-12T12:10:40.566+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4124, "query_time_ms": 4089, "write_time_ms": 35}
2022-12-12T12:10:44.718+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4152, "query_time_ms": 4115, "write_time_ms": 36}
2022-12-12T12:10:49.012+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4293, "query_time_ms": 4254, "write_time_ms": 39}
2022-12-12T12:10:53.249+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4237, "query_time_ms": 4200, "write_time_ms": 36}
2022-12-12T12:10:57.673+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4423, "query_time_ms": 4385, "write_time_ms": 37}
2022-12-12T12:11:02.037+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4363, "query_time_ms": 4328, "write_time_ms": 35}
2022-12-12T12:11:06.298+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4261, "query_time_ms": 4224, "write_time_ms": 36}
2022-12-12T12:11:10.589+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4290, "query_time_ms": 4254, "write_time_ms": 36}
2022-12-12T12:11:14.885+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4295, "query_time_ms": 4258, "write_time_ms": 36}
2022-12-12T12:11:19.197+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4311, "query_time_ms": 4275, "write_time_ms": 36}
2022-12-12T12:11:23.567+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4370, "query_time_ms": 4336, "write_time_ms": 34}
2022-12-12T12:11:28.008+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4440, "query_time_ms": 4403, "write_time_ms": 37}
2022-12-12T12:11:32.355+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4347, "query_time_ms": 4311, "write_time_ms": 35}
2022-12-12T12:11:36.733+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4377, "query_time_ms": 4341, "write_time_ms": 35}
2022-12-12T12:11:41.063+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4329, "query_time_ms": 4294, "write_time_ms": 35}
2022-12-12T12:11:45.556+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4492, "query_time_ms": 4454, "write_time_ms": 37}
2022-12-12T12:11:50.154+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4597, "query_time_ms": 4560, "write_time_ms": 37}
2022-12-12T12:11:54.616+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4461, "query_time_ms": 4425, "write_time_ms": 36}
2022-12-12T12:11:58.991+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4375, "query_time_ms": 4339, "write_time_ms": 36}
2022-12-12T12:12:03.367+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4375, "query_time_ms": 4339, "write_time_ms": 36}
2022-12-12T12:12:07.808+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4440, "query_time_ms": 4404, "write_time_ms": 36}
2022-12-12T12:12:12.210+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4402, "query_time_ms": 4367, "write_time_ms": 35}
2022-12-12T12:12:16.639+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4429, "query_time_ms": 4392, "write_time_ms": 36}
2022-12-12T12:12:21.160+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4520, "query_time_ms": 4485, "write_time_ms": 35}
2022-12-12T12:12:25.643+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4483, "query_time_ms": 4446, "write_time_ms": 36}
2022-12-12T12:12:30.154+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4510, "query_time_ms": 4474, "write_time_ms": 35}
2022-12-12T12:12:34.663+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4508, "query_time_ms": 4472, "write_time_ms": 35}
2022-12-12T12:12:39.167+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4503, "query_time_ms": 4467, "write_time_ms": 36}
2022-12-12T12:12:43.723+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4556, "query_time_ms": 4519, "write_time_ms": 36}
2022-12-12T12:12:48.256+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4532, "query_time_ms": 4496, "write_time_ms": 36}
2022-12-12T12:12:52.807+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4550, "query_time_ms": 4514, "write_time_ms": 36}
2022-12-12T12:12:57.373+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4566, "query_time_ms": 4530, "write_time_ms": 36}
2022-12-12T12:13:02.007+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4633, "query_time_ms": 4597, "write_time_ms": 35}
2022-12-12T12:13:06.702+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4694, "query_time_ms": 4656, "write_time_ms": 38}
2022-12-12T12:13:11.631+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4928, "query_time_ms": 4893, "write_time_ms": 35}
2022-12-12T12:13:16.296+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4664, "query_time_ms": 4628, "write_time_ms": 36}
2022-12-12T12:13:20.944+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4648, "query_time_ms": 4611, "write_time_ms": 36}
2022-12-12T12:13:25.616+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4671, "query_time_ms": 4624, "write_time_ms": 46}
2022-12-12T12:13:30.304+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4687, "query_time_ms": 4650, "write_time_ms": 37}
2022-12-12T12:13:35.025+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4721, "query_time_ms": 4684, "write_time_ms": 36}
2022-12-12T12:13:39.958+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4933, "query_time_ms": 4891, "write_time_ms": 41}
2022-12-12T12:13:44.881+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4922, "query_time_ms": 4885, "write_time_ms": 36}
2022-12-12T12:13:49.668+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4786, "query_time_ms": 4750, "write_time_ms": 36}
2022-12-12T12:13:54.450+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4781, "query_time_ms": 4746, "write_time_ms": 35}
2022-12-12T12:13:59.255+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4804, "query_time_ms": 4768, "write_time_ms": 36}
2022-12-12T12:14:04.163+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4908, "query_time_ms": 4870, "write_time_ms": 38}
2022-12-12T12:14:09.173+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5009, "query_time_ms": 4972, "write_time_ms": 37}
2022-12-12T12:14:14.140+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4966, "query_time_ms": 4930, "write_time_ms": 36}
2022-12-12T12:14:19.130+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 4989, "query_time_ms": 4953, "write_time_ms": 36}
2022-12-12T12:14:24.249+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5119, "query_time_ms": 5082, "write_time_ms": 36}
2022-12-12T12:14:29.396+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5147, "query_time_ms": 5111, "write_time_ms": 36}
2022-12-12T12:14:34.597+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5200, "query_time_ms": 5161, "write_time_ms": 38}
2022-12-12T12:14:39.796+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5199, "query_time_ms": 5159, "write_time_ms": 40}
2022-12-12T12:14:45.062+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5266, "query_time_ms": 5227, "write_time_ms": 39}
2022-12-12T12:14:50.350+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5287, "query_time_ms": 5250, "write_time_ms": 36}
2022-12-12T12:14:55.600+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5249, "query_time_ms": 5212, "write_time_ms": 37}
2022-12-12T12:15:00.869+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5269, "query_time_ms": 5232, "write_time_ms": 37}
2022-12-12T12:15:06.227+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5358, "query_time_ms": 5318, "write_time_ms": 39}
2022-12-12T12:15:11.554+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5326, "query_time_ms": 5286, "write_time_ms": 39}
2022-12-12T12:15:16.910+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5355, "query_time_ms": 5315, "write_time_ms": 40}
2022-12-12T12:15:22.265+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5355, "query_time_ms": 5314, "write_time_ms": 40}
2022-12-12T12:15:27.635+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5370, "query_time_ms": 5327, "write_time_ms": 42}
2022-12-12T12:15:32.987+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5351, "query_time_ms": 5310, "write_time_ms": 41}
2022-12-12T12:15:38.359+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5371, "query_time_ms": 5330, "write_time_ms": 40}
2022-12-12T12:15:43.797+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5438, "query_time_ms": 5396, "write_time_ms": 41}
2022-12-12T12:15:49.213+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5415, "query_time_ms": 5375, "write_time_ms": 40}
2022-12-12T12:15:54.556+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5342, "query_time_ms": 5303, "write_time_ms": 38}
2022-12-12T12:15:59.757+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5201, "query_time_ms": 5165, "write_time_ms": 36}
2022-12-12T12:16:04.945+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5187, "query_time_ms": 5150, "write_time_ms": 37}
2022-12-12T12:16:10.122+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5176, "query_time_ms": 5140, "write_time_ms": 35}
2022-12-12T12:16:15.315+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5193, "query_time_ms": 5155, "write_time_ms": 37}
2022-12-12T12:16:20.512+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5196, "query_time_ms": 5160, "write_time_ms": 36}
2022-12-12T12:16:25.720+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5207, "query_time_ms": 5171, "write_time_ms": 36}
2022-12-12T12:16:30.934+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5214, "query_time_ms": 5176, "write_time_ms": 37}
2022-12-12T12:16:36.161+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5226, "query_time_ms": 5190, "write_time_ms": 36}
2022-12-12T12:16:41.402+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5240, "query_time_ms": 5203, "write_time_ms": 37}
2022-12-12T12:16:46.641+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5238, "query_time_ms": 5202, "write_time_ms": 36}
2022-12-12T12:16:51.996+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5355, "query_time_ms": 5317, "write_time_ms": 37}
2022-12-12T12:16:57.387+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5391, "query_time_ms": 5354, "write_time_ms": 36}
2022-12-12T12:17:02.805+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5417, "query_time_ms": 5379, "write_time_ms": 37}
2022-12-12T12:17:08.146+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5340, "query_time_ms": 5305, "write_time_ms": 35}
2022-12-12T12:17:13.504+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5358, "query_time_ms": 5322, "write_time_ms": 35}
2022-12-12T12:17:18.967+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5462, "query_time_ms": 5425, "write_time_ms": 37}
2022-12-12T12:17:24.380+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5412, "query_time_ms": 5377, "write_time_ms": 35}
2022-12-12T12:17:29.845+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5464, "query_time_ms": 5425, "write_time_ms": 39}
2022-12-12T12:17:35.221+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5375, "query_time_ms": 5339, "write_time_ms": 35}
2022-12-12T12:17:40.753+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5531, "query_time_ms": 5494, "write_time_ms": 37}
2022-12-12T12:17:46.442+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5689, "query_time_ms": 5652, "write_time_ms": 37}
2022-12-12T12:17:52.023+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5580, "query_time_ms": 5543, "write_time_ms": 36}
2022-12-12T12:17:57.823+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5799, "query_time_ms": 5761, "write_time_ms": 38}
2022-12-12T12:18:03.531+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5707, "query_time_ms": 5671, "write_time_ms": 36}
2022-12-12T12:18:09.207+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5676, "query_time_ms": 5637, "write_time_ms": 39}
2022-12-12T12:18:14.825+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5617, "query_time_ms": 5580, "write_time_ms": 36}
2022-12-12T12:18:20.338+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5512, "query_time_ms": 5475, "write_time_ms": 37}
2022-12-12T12:18:25.920+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5582, "query_time_ms": 5545, "write_time_ms": 36}
2022-12-12T12:18:31.481+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5560, "query_time_ms": 5523, "write_time_ms": 36}
2022-12-12T12:18:37.056+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5574, "query_time_ms": 5537, "write_time_ms": 36}
2022-12-12T12:18:42.639+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5583, "query_time_ms": 5547, "write_time_ms": 36}
2022-12-12T12:18:48.233+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5593, "query_time_ms": 5554, "write_time_ms": 39}
2022-12-12T12:18:53.864+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5630, "query_time_ms": 5595, "write_time_ms": 35}
2022-12-12T12:18:59.507+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5642, "query_time_ms": 5605, "write_time_ms": 37}
2022-12-12T12:19:05.201+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5693, "query_time_ms": 5658, "write_time_ms": 35}
2022-12-12T12:19:11.029+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5827, "query_time_ms": 5790, "write_time_ms": 37}
2022-12-12T12:19:16.850+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5821, "query_time_ms": 5782, "write_time_ms": 38}
2022-12-12T12:19:22.690+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5840, "query_time_ms": 5804, "write_time_ms": 35}
2022-12-12T12:19:28.554+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5863, "query_time_ms": 5826, "write_time_ms": 36}
2022-12-12T12:19:34.321+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5767, "query_time_ms": 5731, "write_time_ms": 35}
2022-12-12T12:19:40.063+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5741, "query_time_ms": 5704, "write_time_ms": 36}
2022-12-12T12:19:45.797+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5733, "query_time_ms": 5696, "write_time_ms": 37}
2022-12-12T12:19:51.548+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5751, "query_time_ms": 5714, "write_time_ms": 36}
2022-12-12T12:19:57.317+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5768, "query_time_ms": 5731, "write_time_ms": 36}
2022-12-12T12:20:03.103+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5786, "query_time_ms": 5749, "write_time_ms": 36}
2022-12-12T12:20:08.896+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5793, "query_time_ms": 5757, "write_time_ms": 35}
2022-12-12T12:20:14.953+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6056, "query_time_ms": 6020, "write_time_ms": 36}
2022-12-12T12:20:20.986+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6033, "query_time_ms": 5996, "write_time_ms": 36}
2022-12-12T12:20:27.074+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6087, "query_time_ms": 6052, "write_time_ms": 34}
2022-12-12T12:20:33.062+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5988, "query_time_ms": 5951, "write_time_ms": 37}
2022-12-12T12:20:39.012+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5951, "query_time_ms": 5915, "write_time_ms": 35}
2022-12-12T12:20:44.962+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5950, "query_time_ms": 5913, "write_time_ms": 37}
2022-12-12T12:20:50.898+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5937, "query_time_ms": 5900, "write_time_ms": 36}
2022-12-12T12:20:56.863+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5965, "query_time_ms": 5929, "write_time_ms": 35}
2022-12-12T12:21:02.836+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5972, "query_time_ms": 5935, "write_time_ms": 37}
2022-12-12T12:21:08.832+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5996, "query_time_ms": 5960, "write_time_ms": 35}
2022-12-12T12:21:14.829+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 5997, "query_time_ms": 5960, "write_time_ms": 36}
2022-12-12T12:21:20.854+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6024, "query_time_ms": 5988, "write_time_ms": 36}
2022-12-12T12:21:26.905+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6051, "query_time_ms": 6014, "write_time_ms": 36}
2022-12-12T12:21:32.969+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6063, "query_time_ms": 6027, "write_time_ms": 36}
2022-12-12T12:21:39.049+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6080, "query_time_ms": 6043, "write_time_ms": 36}
2022-12-12T12:21:45.116+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6067, "query_time_ms": 6030, "write_time_ms": 36}
2022-12-12T12:21:51.201+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6084, "query_time_ms": 6048, "write_time_ms": 36}
2022-12-12T12:21:57.327+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6126, "query_time_ms": 6089, "write_time_ms": 37}
2022-12-12T12:22:03.470+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6142, "query_time_ms": 6106, "write_time_ms": 36}
2022-12-12T12:22:09.615+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6145, "query_time_ms": 6108, "write_time_ms": 36}
2022-12-12T12:22:15.858+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6242, "query_time_ms": 6205, "write_time_ms": 36}
2022-12-12T12:22:22.120+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6262, "query_time_ms": 6224, "write_time_ms": 37}
2022-12-12T12:22:28.314+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6193, "query_time_ms": 6156, "write_time_ms": 37}
2022-12-12T12:22:34.598+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6284, "query_time_ms": 6248, "write_time_ms": 36}
2022-12-12T12:22:41.012+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6413, "query_time_ms": 6376, "write_time_ms": 36}
2022-12-12T12:22:47.275+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6262, "query_time_ms": 6226, "write_time_ms": 35}
2022-12-12T12:22:53.560+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6284, "query_time_ms": 6247, "write_time_ms": 37}
2022-12-12T12:22:59.842+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6282, "query_time_ms": 6242, "write_time_ms": 39}
2022-12-12T12:23:06.138+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6295, "query_time_ms": 6259, "write_time_ms": 35}
2022-12-12T12:23:12.572+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6433, "query_time_ms": 6397, "write_time_ms": 35}
2022-12-12T12:23:18.939+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6367, "query_time_ms": 6332, "write_time_ms": 35}
2022-12-12T12:23:25.288+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6348, "query_time_ms": 6312, "write_time_ms": 36}
2022-12-12T12:23:31.709+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6420, "query_time_ms": 6385, "write_time_ms": 35}
2022-12-12T12:23:38.088+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6379, "query_time_ms": 6343, "write_time_ms": 35}
2022-12-12T12:23:44.593+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6505, "query_time_ms": 6470, "write_time_ms": 34}
2022-12-12T12:23:50.998+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6404, "query_time_ms": 6368, "write_time_ms": 36}
2022-12-12T12:23:57.414+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6416, "query_time_ms": 6381, "write_time_ms": 35}
2022-12-12T12:24:03.830+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6416, "query_time_ms": 6381, "write_time_ms": 34}
2022-12-12T12:24:10.273+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6442, "query_time_ms": 6405, "write_time_ms": 37}
2022-12-12T12:24:16.813+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6540, "query_time_ms": 6503, "write_time_ms": 37}
2022-12-12T12:24:23.291+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6477, "query_time_ms": 6441, "write_time_ms": 36}
2022-12-12T12:24:29.869+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6578, "query_time_ms": 6541, "write_time_ms": 36}
2022-12-12T12:24:36.482+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6613, "query_time_ms": 6576, "write_time_ms": 36}
2022-12-12T12:24:43.082+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6599, "query_time_ms": 6563, "write_time_ms": 36}
2022-12-12T12:24:49.675+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6592, "query_time_ms": 6554, "write_time_ms": 37}
2022-12-12T12:24:56.371+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6695, "query_time_ms": 6658, "write_time_ms": 37}
2022-12-12T12:25:03.121+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6750, "query_time_ms": 6713, "write_time_ms": 36}
2022-12-12T12:25:09.938+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6816, "query_time_ms": 6779, "write_time_ms": 36}
2022-12-12T12:25:16.810+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6871, "query_time_ms": 6833, "write_time_ms": 38}
2022-12-12T12:25:23.599+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6789, "query_time_ms": 6752, "write_time_ms": 36}
2022-12-12T12:25:30.315+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6715, "query_time_ms": 6677, "write_time_ms": 37}
2022-12-12T12:25:37.026+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6711, "query_time_ms": 6662, "write_time_ms": 48}
2022-12-12T12:25:43.700+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6674, "query_time_ms": 6637, "write_time_ms": 37}
2022-12-12T12:25:50.457+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6756, "query_time_ms": 6720, "write_time_ms": 36}
2022-12-12T12:25:57.267+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6809, "query_time_ms": 6772, "write_time_ms": 37}
2022-12-12T12:26:04.191+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6923, "query_time_ms": 6887, "write_time_ms": 36}
2022-12-12T12:26:11.195+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 7003, "query_time_ms": 6968, "write_time_ms": 35}
2022-12-12T12:26:18.129+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6934, "query_time_ms": 6898, "write_time_ms": 36}
2022-12-12T12:26:24.909+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6779, "query_time_ms": 6742, "write_time_ms": 36}
2022-12-12T12:26:31.807+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6897, "query_time_ms": 6862, "write_time_ms": 35}
2022-12-12T12:26:38.739+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6931, "query_time_ms": 6895, "write_time_ms": 36}
2022-12-12T12:26:45.611+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6871, "query_time_ms": 6835, "write_time_ms": 36}
2022-12-12T12:26:52.464+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6853, "query_time_ms": 6817, "write_time_ms": 35}
2022-12-12T12:26:59.361+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6897, "query_time_ms": 6860, "write_time_ms": 36}
2022-12-12T12:27:06.304+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6941, "query_time_ms": 6906, "write_time_ms": 35}
2022-12-12T12:27:13.289+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6985, "query_time_ms": 6949, "write_time_ms": 36}
2022-12-12T12:27:20.215+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6925, "query_time_ms": 6888, "write_time_ms": 37}
2022-12-12T12:27:27.200+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6985, "query_time_ms": 6948, "write_time_ms": 36}
2022-12-12T12:27:34.243+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 7042, "query_time_ms": 7005, "write_time_ms": 37}
2022-12-12T12:27:41.203+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 6960, "query_time_ms": 6924, "write_time_ms": 35}
2022-12-12T12:27:48.297+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 7093, "query_time_ms": 7057, "write_time_ms": 36}
2022-12-12T12:27:55.308+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 7010, "query_time_ms": 6973, "write_time_ms": 36}
2022-12-12T12:28:02.360+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 7052, "query_time_ms": 7017, "write_time_ms": 35}
2022-12-12T12:28:09.470+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 7109, "query_time_ms": 7072, "write_time_ms": 37}
2022-12-12T12:28:16.606+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 7135, "query_time_ms": 7099, "write_time_ms": 35}
2022-12-12T12:28:23.849+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 7243, "query_time_ms": 7205, "write_time_ms": 37}
2022-12-12T12:28:31.047+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 7198, "query_time_ms": 7161, "write_time_ms": 36}
2022-12-12T12:28:38.226+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 7178, "query_time_ms": 7142, "write_time_ms": 36}
2022-12-12T12:28:45.408+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 7181, "query_time_ms": 7145, "write_time_ms": 36}
2022-12-12T12:28:52.606+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 10000, "total_time_ms": 7197, "query_time_ms": 7159, "write_time_ms": 37}
2022-12-12T12:28:59.934+0800    INFO    [email protected]    writing out CSV batch   {"feed": "inspection_items", "rows_added": 6211, "total_time_ms": 7328, "query_time_ms": 7306, "write_time_ms": 22}
2022-12-12T12:29:07.261+0800    INFO    [email protected]    CSV exported    {"feed": "inspection_items"}
2022-12-12T12:29:07.261+0800    INFO    [email protected]    Export finished

@hkf57
Copy link
Member

hkf57 commented Dec 18, 2022

@OscarBarrett thanks for raising this!

If you have any bandwidth, we'd love to see contributions to addressing this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hkf57 hkf57

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@hkf57 @jashwood @OscarBarrett