9. Load ZIP Code Database data into PostgreSQL¶
2025-03-01¶
===========================================================================
Start run_io_avstats_dev
---------------------------------------------------------------------------
IO-AVSTATS - Aviation Event Statistics.
---------------------------------------------------------------------------
ENV_FOR_DYNACONF : prod
PYTHONPATH : .
---------------------------------------------------------------------------
TASK : l_z_d
APPLICATION :
COMPOSE_TASK :
MSACCESS :
MSEXCEL :
---------------------------------------------------------------------------
The current time is: 5:21:57.23
Enter the new time:
===========================================================================
2025-03-01 05:21:58,056 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-03-01 05:21:58,057 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-03-01 05:21:58,057 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-03-01 05:21:58,061 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-03-01 04:21:59.297153+00:00 : ===============================================================================.
Progress update 2025-03-01 04:21:59.297153+00:00 : INFO.00.004 Start Launcher.
2025-03-01 05:21:59,297 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'l_z_d']
2025-03-01 05:21:59,298 [root] [launcher.py ] INFO Start launcher.py
2025-03-01 05:21:59,308 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-03-01 04:21:59.310151+00:00 : INFO.00.005 Argument task='l_z_d'.
Progress update 2025-03-01 04:21:59.310151+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-03-01 04:21:59.310151+00:00 : INFO.00.056 Load ZIP Code Database data.
Progress update 2025-03-01 04:21:59.310151+00:00 : --------------------------------------------------------------------------------
2025-03-01 05:21:59,310 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-03-01 04:21:59.734860+00:00 : INFO.00.063 Processed data source 'Zip Codes.org ZIP Code Database'.
Progress update 2025-03-01 04:21:59.734860+00:00 : Number rows deleted : 13379.
Progress update 2025-03-01 04:21:59.734860+00:00 : --------------------------------------------------------------------------------
Progress update 2025-03-01 04:21:59.735861+00:00 : INFO.00.061 Database table io_lat_lng: Load the estimated zip code data.
Progress update 2025-03-01 04:21:59.735861+00:00 : --------------------------------------------------------------------------------
Progress update 2025-03-01 04:28:43.839146+00:00 : Number of rows so far read : 10000.
Progress update 2025-03-01 04:35:53.027375+00:00 : Number of rows so far read : 20000.
Progress update 2025-03-01 04:43:08.099017+00:00 : Number of rows so far read : 30000.
Progress update 2025-03-01 04:49:21.843918+00:00 : Number of rows so far read : 40000.
Progress update 2025-03-01 04:50:49.623623+00:00 : Number rows selected : 42735.
Progress update 2025-03-01 04:50:49.623623+00:00 : Number rows upserted : 13381.
Progress update 2025-03-01 04:50:49.628624+00:00 : --------------------------------------------------------------------------------
Progress update 2025-03-01 04:50:49.781127+00:00 : INFO.00.063 Processed data source 'average'.
Progress update 2025-03-01 04:50:49.781127+00:00 : Number rows deleted : 15605.
Progress update 2025-03-01 04:50:49.782127+00:00 : --------------------------------------------------------------------------------
Progress update 2025-03-01 04:50:49.782127+00:00 : INFO.00.062 Database table io_lat_lng: Load the averaged city data.
Progress update 2025-03-01 04:50:49.782127+00:00 : --------------------------------------------------------------------------------
2025-03-01 05:50:49,782 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-03-01 04:53:07.994090+00:00 : Number of rows so far read : 10000.
Progress update 2025-03-01 04:55:31.331537+00:00 : Number of rows so far read : 20000.
Progress update 2025-03-01 04:57:55.467057+00:00 : Number of rows so far read : 30000.
Progress update 2025-03-01 05:00:18.878489+00:00 : Number of rows so far read : 40000.
Progress update 2025-03-01 05:01:59.589240+00:00 : Number rows selected : 46788.
Progress update 2025-03-01 05:01:59.589240+00:00 : Number rows inserted : 46788.
Progress update 2025-03-01 05:01:59.676686+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-03-01 05:01:59.677690+00:00 : 2,400 s - Total time launcher.
Progress update 2025-03-01 05:01:59.677690+00:00 : INFO.00.006 End Launcher.
Progress update 2025-03-01 05:01:59.677690+00:00 : ===============================================================================.
---------------------------------------------------------------------------
The current time is: 6:02:00.09
Enter the new time:
---------------------------------------------------------------------------
End run_io_avstats_dev
===========================================================================
2024-11-01¶
===========================================================================
Start run_io_avstats_dev
---------------------------------------------------------------------------
IO-AVSTATS - Aviation Event Statistics.
---------------------------------------------------------------------------
ENV_FOR_DYNACONF : prod
PYTHONPATH : .
---------------------------------------------------------------------------
TASK : l_z_d
APPLICATION :
COMPOSE_TASK :
MSACCESS :
MSEXCEL :
---------------------------------------------------------------------------
The current time is: 6:44:50.35
Enter the new time:
===========================================================================
2024-11-01 06:44:51,351 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.60 logger (Copyright (c) 2022-2024 IO-Aero)
2024-11-01 06:44:51,352 [root] [io_settings.py ] INFO Starting the configuration management system.
2024-11-01 06:44:51,352 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2024-11-01 06:44:51,352 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2024-11-01 05:44:52.366874+00:00 : ===============================================================================.
Progress update 2024-11-01 05:44:52.366874+00:00 : INFO.00.004 Start Launcher.
2024-11-01 06:44:52,366 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'l_z_d']
2024-11-01 06:44:52,367 [root] [launcher.py ] INFO Start launcher.py
2024-11-01 06:44:52,376 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2024-11-01 05:44:52.378873+00:00 : INFO.00.005 Argument task='l_z_d'.
Progress update 2024-11-01 05:44:52.378873+00:00 : -------------------------------------------------------------------------------.
Progress update 2024-11-01 05:44:52.378873+00:00 : INFO.00.056 Load ZIP Code Database data.
Progress update 2024-11-01 05:44:52.378873+00:00 : --------------------------------------------------------------------------------
2024-11-01 06:44:52,379 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2024-11-01 05:44:52.611677+00:00 : INFO.00.063 Processed data source 'Zip Codes.org ZIP Code Database'.
Progress update 2024-11-01 05:44:52.611677+00:00 : Number rows deleted : 13367.
Progress update 2024-11-01 05:44:52.611677+00:00 : --------------------------------------------------------------------------------
Progress update 2024-11-01 05:44:52.611677+00:00 : INFO.00.061 Database table io_lat_lng: Load the estimated zip code data.
Progress update 2024-11-01 05:44:52.611677+00:00 : --------------------------------------------------------------------------------
Progress update 2024-11-01 05:50:46.745253+00:00 : Number of rows so far read : 10000.
Progress update 2024-11-01 05:57:47.037050+00:00 : Number of rows so far read : 20000.
Progress update 2024-11-01 06:05:01.151479+00:00 : Number of rows so far read : 30000.
Progress update 2024-11-01 06:11:13.630871+00:00 : Number of rows so far read : 40000.
Progress update 2024-11-01 06:12:38.919571+00:00 : Number rows selected : 42735.
Progress update 2024-11-01 06:12:38.919571+00:00 : Number rows upserted : 13380.
Progress update 2024-11-01 06:12:38.924633+00:00 : --------------------------------------------------------------------------------
Progress update 2024-11-01 06:12:39.323799+00:00 : INFO.00.063 Processed data source 'average'.
Progress update 2024-11-01 06:12:39.323799+00:00 : Number rows deleted : 15676.
Progress update 2024-11-01 06:12:39.323799+00:00 : --------------------------------------------------------------------------------
Progress update 2024-11-01 06:12:39.323799+00:00 : INFO.00.062 Database table io_lat_lng: Load the averaged city data.
Progress update 2024-11-01 06:12:39.323799+00:00 : --------------------------------------------------------------------------------
2024-11-01 07:12:39,324 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2024-11-01 06:15:23.828027+00:00 : Number of rows so far read : 10000.
Progress update 2024-11-01 06:17:57.986915+00:00 : Number of rows so far read : 20000.
Progress update 2024-11-01 06:20:31.878157+00:00 : Number of rows so far read : 30000.
Progress update 2024-11-01 06:23:10.873801+00:00 : Number of rows so far read : 40000.
Progress update 2024-11-01 06:24:55.742215+00:00 : Number rows selected : 46739.
Progress update 2024-11-01 06:24:55.742215+00:00 : Number rows inserted : 46739.
Progress update 2024-11-01 06:24:55.853208+00:00 : -------------------------------------------------------------------------------.
Progress update 2024-11-01 06:24:55.853208+00:00 : 2,403 s - Total time launcher.
Progress update 2024-11-01 06:24:55.853208+00:00 : INFO.00.006 End Launcher.
Progress update 2024-11-01 06:24:55.853208+00:00 : ===============================================================================.
---------------------------------------------------------------------------
The current time is: 7:24:56.11
Enter the new time:
---------------------------------------------------------------------------
End run_io_avstats_dev
===========================================================================
2024-03-10¶
===========================================================================
Start run_io_avstats
---------------------------------------------------------------------------
IO-AVSTATS - Aviation Event Statistics.
---------------------------------------------------------------------------
ENV_FOR_DYNACONF : prod
PYTHONPATH : .
---------------------------------------------------------------------------
TASK : l_z_d
APPLICATION :
COMPOSE_TASK :
MSACCESS :
MSEXCEL :
---------------------------------------------------------------------------
The current time is: 4:58:24.16
Enter the new time:
===========================================================================
Progress update 2024-03-10 04:58:28.404733 : ===============================================================================.
Progress update 2024-03-10 04:58:28.404733 : INFO.00.004 Start Launcher.
2024-03-10 04:58:28,413 [iocommon.io_logger] [io_logging.py ] INFO initialise_logger:59 You are using io-aero's iocommon version 1.2.41 logger (Copyright (c) 2022-2024 IO-Aero)
2024-03-10 04:58:28,413 [__main__] [launcher.py ] INFO main:80 Start launcher.py
Progress update 2024-03-10 04:58:28.424322 : INFO.00.005 Argument task='l_z_d'.
Progress update 2024-03-10 04:58:28.424322 : -------------------------------------------------------------------------------.
Progress update 2024-03-10 04:58:28.424322 : INFO.00.056 Load ZIP Code Database data.
Progress update 2024-03-10 04:58:28.424322 : --------------------------------------------------------------------------------
Progress update 2024-03-10 04:58:28.424322 : INFO.00.081 User connect request host=localhost port=5432 dbname=io_aero_db user=io_aero.
Progress update 2024-03-10 04:58:28.641013 : INFO.00.063 Processed data source 'Zip Codes.org ZIP Code Database'.
Progress update 2024-03-10 04:58:28.641013 : Number rows deleted : 13376.
Progress update 2024-03-10 04:58:28.641013 : --------------------------------------------------------------------------------
Progress update 2024-03-10 04:58:28.641539 : INFO.00.061 Database table io_lat_lng: Load the estimated zip code data.
Progress update 2024-03-10 04:58:28.641539 : --------------------------------------------------------------------------------
Progress update 2024-03-10 05:02:14.527978 : Number of rows so far read : 10000.
Progress update 2024-03-10 05:06:57.883777 : Number of rows so far read : 20000.
Progress update 2024-03-10 05:11:55.192924 : Number of rows so far read : 30000.
Progress update 2024-03-10 05:15:50.861165 : Number of rows so far read : 40000.
Progress update 2024-03-10 05:16:42.414720 : Number rows selected : 42735.
Progress update 2024-03-10 05:16:42.414720 : Number rows upserted : 13376.
Progress update 2024-03-10 05:16:42.417715 : --------------------------------------------------------------------------------
Progress update 2024-03-10 05:16:42.538788 : INFO.00.063 Processed data source 'average'.
Progress update 2024-03-10 05:16:42.538788 : Number rows deleted : 15682.
Progress update 2024-03-10 05:16:42.539309 : --------------------------------------------------------------------------------
Progress update 2024-03-10 05:16:42.539309 : INFO.00.062 Database table io_lat_lng: Load the averaged city data.
Progress update 2024-03-10 05:16:42.539309 : --------------------------------------------------------------------------------
Progress update 2024-03-10 05:16:42.539309 : INFO.00.081 User connect request host=localhost port=5432 dbname=io_aero_db user=io_aero.
Progress update 2024-03-10 05:18:15.263992 : Number of rows so far read : 10000.
Progress update 2024-03-10 05:19:48.912463 : Number of rows so far read : 20000.
Progress update 2024-03-10 05:21:20.403151 : Number of rows so far read : 30000.
Progress update 2024-03-10 05:22:51.136345 : Number of rows so far read : 40000.
Progress update 2024-03-10 05:23:47.968757 : Number rows selected : 46738.
Progress update 2024-03-10 05:23:47.968757 : Number rows inserted : 46738.
Progress update 2024-03-10 05:23:47.988330 : -------------------------------------------------------------------------------.
Progress update 2024-03-10 05:23:47.988330 : 1,519 s - Total time launcher.
Progress update 2024-03-10 05:23:47.988330 : INFO.00.006 End Launcher.
Progress update 2024-03-10 05:23:47.988330 : ===============================================================================.
---------------------------------------------------------------------------
The current time is: 5:23:48.21
Enter the new time:
---------------------------------------------------------------------------
End run_io_avstats
===========================================================================
2023-08-22¶
=======================================================================
Start run_io_avstats
-----------------------------------------------------------------------
IO-AVSTATS - Aviation Event Statistics.
-----------------------------------------------------------------------
PYTHONPATH : D:\SoftDevelopment\Projects\IO-Aero\io-avstats-db\dist;D:\SoftDevelopment\Projects\IO-Aero\io-maps\dist
-----------------------------------------------------------------------
TASK : l_z_d
APPLICATION :
COMPOSE_TASK :
MSACCESS :
MSEXCEL :
-----------------------------------------------------------------------
The current time is: 1:47:37.03
Enter the new time:
=======================================================================
Progress update 2023-08-22 01:47:38.263210 : ===============================================================================.
Progress update 2023-08-22 01:47:38.263210 : INFO.00.004 Start Launcher.
Progress update 2023-08-22 01:47:38.265206 : INFO.00.001 The logger is configured and ready.
Progress update 2023-08-22 01:47:38.275379 : INFO.00.005 Argument task='l_z_d'.
Progress update 2023-08-22 01:47:38.275379 : -------------------------------------------------------------------------------.
Progress update 2023-08-22 01:47:38.275379 : INFO.00.056 Load ZIP Code Database data.
Progress update 2023-08-22 01:47:38.275379 : --------------------------------------------------------------------------------
Progress update 2023-08-22 01:47:38.275379 : INFO.00.081 User connect request host=localhost port=5432 dbname=io_aero_db user=io_aero.
Progress update 2023-08-22 01:47:38.342729 : INFO.00.061 Database table io_lat_lng: Load the estimated zip code data.
Progress update 2023-08-22 01:47:38.342729 : --------------------------------------------------------------------------------
Progress update 2023-08-22 01:47:44.344629 : Number of rows so far read : 10000.
Progress update 2023-08-22 01:47:50.391710 : Number of rows so far read : 20000.
Progress update 2023-08-22 01:47:56.324224 : Number of rows so far read : 30000.
Progress update 2023-08-22 01:48:01.613681 : Number of rows so far read : 40000.
Progress update 2023-08-22 01:48:02.872042 : Number rows selected : 42736.
Progress update 2023-08-22 01:48:02.872042 : Number rows upserted : 13369.
Progress update 2023-08-22 01:48:02.872042 : --------------------------------------------------------------------------------
Progress update 2023-08-22 01:48:02.913086 : INFO.00.063 Processed data source 'average'.
Progress update 2023-08-22 01:48:02.913086 : Number rows deleted : 7537.
Progress update 2023-08-22 01:48:02.913086 : --------------------------------------------------------------------------------
Progress update 2023-08-22 01:48:02.913086 : INFO.00.062 Database table io_lat_lng: Load the averaged city data.
Progress update 2023-08-22 01:48:02.913086 : --------------------------------------------------------------------------------
Progress update 2023-08-22 01:48:02.913086 : INFO.00.081 User connect request host=localhost port=5432 dbname=io_aero_db user=io_aero.
Progress update 2023-08-22 01:48:07.645702 : Number of rows so far read : 10000.
Progress update 2023-08-22 01:48:12.210835 : Number of rows so far read : 20000.
Progress update 2023-08-22 01:48:16.692840 : Number of rows so far read : 30000.
Progress update 2023-08-22 01:48:21.232907 : Number of rows so far read : 40000.
Progress update 2023-08-22 01:48:24.175061 : Number rows selected : 46564.
Progress update 2023-08-22 01:48:24.175061 : Number rows inserted : 46564.
Progress update 2023-08-22 01:48:24.177062 : -------------------------------------------------------------------------------.
Progress update 2023-08-22 01:48:24.177062 : 45,913,851,900 ns - Total time launcher.
Progress update 2023-08-22 01:48:24.177062 : INFO.00.006 End Launcher.
Progress update 2023-08-22 01:48:24.177062 : ===============================================================================.
2023-06-30¶
Script run_io_avstats is now running
=======================================================================
Start run_io_avstats
-----------------------------------------------------------------------
IO-AVSTATS - Aviation Event Statistics.
-----------------------------------------------------------------------
PYTHONPATH : D:\SoftDevelopment\Projects\IO-Aero\io-avstats-db\dist;D:\SoftDevelopment\Projects\IO-Aero\io-maps\dist
-----------------------------------------------------------------------
TASK : l_z_d
APPLICATION :
COMPOSE_TASK :
MSACCESS :
MSEXCEL :
-----------------------------------------------------------------------
The current time is: 17:03:57.58
Enter the new time:
=======================================================================
Progress update 2023-07-31 17:03:58.713078 : ===============================================================================.
Progress update 2023-07-31 17:03:58.713078 : INFO.00.004 Start Launcher.
Progress update 2023-07-31 17:03:58.715078 : INFO.00.001 The logger is configured and ready.
Progress update 2023-07-31 17:03:58.724078 : INFO.00.005 Argument task='l_z_d'.
Progress update 2023-07-31 17:03:58.724078 : -------------------------------------------------------------------------------.
Progress update 2023-07-31 17:03:58.724078 : INFO.00.056 Load ZIP Code Database data.
Progress update 2023-07-31 17:03:58.724078 : --------------------------------------------------------------------------------
Progress update 2023-07-31 17:03:58.724078 : INFO.00.081 User connect request host=localhost port=5432 dbname=io_avstats_db user=io_aero.
Progress update 2023-07-31 17:03:58.790307 : INFO.00.061 Database table io_lat_lng: Load the estimated zip code data.
Progress update 2023-07-31 17:03:58.790307 : --------------------------------------------------------------------------------
Progress update 2023-07-31 17:04:04.816406 : Number of rows so far read : 10000.
Progress update 2023-07-31 17:04:10.948322 : Number of rows so far read : 20000.
Progress update 2023-07-31 17:04:16.971469 : Number of rows so far read : 30000.
Progress update 2023-07-31 17:04:22.361318 : Number of rows so far read : 40000.
Progress update 2023-07-31 17:04:23.669313 : Number rows selected : 42736.
Progress update 2023-07-31 17:04:23.669313 : Number rows upserted : 13369.
Progress update 2023-07-31 17:04:23.669313 : --------------------------------------------------------------------------------
Progress update 2023-07-31 17:04:23.736829 : INFO.00.063 Processed data source 'average'.
Progress update 2023-07-31 17:04:23.736829 : Number rows deleted : 7537.
Progress update 2023-07-31 17:04:23.736829 : --------------------------------------------------------------------------------
Progress update 2023-07-31 17:04:23.736829 : INFO.00.062 Database table io_lat_lng: Load the averaged city data.
Progress update 2023-07-31 17:04:23.736829 : --------------------------------------------------------------------------------
Progress update 2023-07-31 17:04:23.736829 : INFO.00.081 User connect request host=localhost port=5432 dbname=io_avstats_db user=io_aero.
Progress update 2023-07-31 17:04:28.676646 : Number of rows so far read : 10000.
Progress update 2023-07-31 17:04:33.408908 : Number of rows so far read : 20000.
Progress update 2023-07-31 17:04:38.232046 : Number of rows so far read : 30000.
Progress update 2023-07-31 17:04:42.922145 : Number of rows so far read : 40000.
Progress update 2023-07-31 17:04:46.072539 : Number rows selected : 46564.
Progress update 2023-07-31 17:04:46.072539 : Number rows inserted : 46564.
Progress update 2023-07-31 17:04:46.074539 : -------------------------------------------------------------------------------.
Progress update 2023-07-31 17:04:46.074539 : 47,361,461,200 ns - Total time launcher.
Progress update 2023-07-31 17:04:46.074539 : INFO.00.006 End Launcher.
Progress update 2023-07-31 17:04:46.075541 : ===============================================================================.
-----------------------------------------------------------------------
The current time is: 17:04:46.20
Enter the new time:
-----------------------------------------------------------------------
End run_io_avstats
=======================================================================
2023-06-20¶
Script run_io_avstats is now running
=======================================================================
Start run_io_avstats
-----------------------------------------------------------------------
IO-AVSTATS - Aviation Event Statistics.
-----------------------------------------------------------------------
PYTHONPATH :
-----------------------------------------------------------------------
TASK : l_z_d
APPLICATION :
COMPOSE_TASK :
MSACCESS :
MSEXCEL :
-----------------------------------------------------------------------
The current time is: 12:26:32.17
Enter the new time:
=======================================================================
Progress update 2023-06-24 12:26:33.470339 : ===============================================================================.
Progress update 2023-06-24 12:26:33.470339 : INFO.00.004 Start Launcher.
Progress update 2023-06-24 12:26:33.472340 : INFO.00.001 The logger is configured and ready.
Progress update 2023-06-24 12:26:33.481848 : INFO.00.005 Argument task='l_z_d'.
Progress update 2023-06-24 12:26:33.481848 : -------------------------------------------------------------------------------.
Progress update 2023-06-24 12:26:33.481848 : INFO.00.056 Load ZIP Code Database data.
Progress update 2023-06-24 12:26:33.481848 : --------------------------------------------------------------------------------
Progress update 2023-06-24 12:26:33.481848 : INFO.00.081 User connect request host=localhost port=5432 dbname=io_avstats_db user=io_aero.
Progress update 2023-06-24 12:26:33.548853 : INFO.00.061 Database table io_lat_lng: Load the estimated zip code data.
Progress update 2023-06-24 12:26:33.548853 : --------------------------------------------------------------------------------
Progress update 2023-06-24 12:26:39.403838 : Number of rows so far read : 10000.
Progress update 2023-06-24 12:26:45.511114 : Number of rows so far read : 20000.
Progress update 2023-06-24 12:26:51.675398 : Number of rows so far read : 30000.
Progress update 2023-06-24 12:26:57.236698 : Number of rows so far read : 40000.
Progress update 2023-06-24 12:26:58.515447 : Number rows selected : 42736.
Progress update 2023-06-24 12:26:58.515447 : Number rows upserted : 13369.
Progress update 2023-06-24 12:26:58.515447 : --------------------------------------------------------------------------------
Progress update 2023-06-24 12:26:58.556862 : INFO.00.063 Processed data source 'average'.
Progress update 2023-06-24 12:26:58.556862 : Number rows deleted : 7537.
Progress update 2023-06-24 12:26:58.556862 : --------------------------------------------------------------------------------
Progress update 2023-06-24 12:26:58.556862 : INFO.00.062 Database table io_lat_lng: Load the averaged city data.
Progress update 2023-06-24 12:26:58.557361 : --------------------------------------------------------------------------------
Progress update 2023-06-24 12:26:58.557361 : INFO.00.081 User connect request host=localhost port=5432 dbname=io_avstats_db user=io_aero.
Progress update 2023-06-24 12:27:03.463951 : Number of rows so far read : 10000.
Progress update 2023-06-24 12:27:08.137453 : Number of rows so far read : 20000.
Progress update 2023-06-24 12:27:12.786236 : Number of rows so far read : 30000.
Progress update 2023-06-24 12:27:17.335109 : Number of rows so far read : 40000.
Progress update 2023-06-24 12:27:20.393044 : Number rows selected : 46564.
Progress update 2023-06-24 12:27:20.393547 : Number rows inserted : 46564.
Progress update 2023-06-24 12:27:20.396044 : -------------------------------------------------------------------------------.
Progress update 2023-06-24 12:27:20.396044 : 46,925,704,700 ns - Total time launcher.
Progress update 2023-06-24 12:27:20.396044 : INFO.00.006 End Launcher.
Progress update 2023-06-24 12:27:20.396544 : ===============================================================================.
-----------------------------------------------------------------------
The current time is: 12:27:20.51
Enter the new time:
-----------------------------------------------------------------------
End run_io_avstats
=======================================================================