Based on the information provided, there could be several reasons why your Airbyte connection is taking a long time to extract and load data from MongoDB to Postgres. Here are a few possibilities: 1.
Network Latency: If your source (MongoDB) and destination (Postgres) are located in different regions or networks, network latency could slow down the data transfer process. 2.
Resource Constraints: If your Airbyte instance or your destination database (Postgres) doesn't have enough resources (CPU, memory, disk I/O), it could slow down the data extraction and loading process. 3.
Large Amount of Data: Even though you mentioned that it extracted 480 records, the size of each record could also impact the performance. If each record is large in size, it could take longer to process. 4.
Errors or Bugs: There could be errors or bugs in the Airbyte connectors you're using. For example, in one of the knowledge sources, there's an open issue on Github where records get extracted but not loaded in a MongoDB to Postgres connection ([source](
https://github.com/airbytehq/airbyte/issues/45133)). To troubleshoot this issue, you could: - Check the logs of your Airbyte instance to see if there are any error messages or warnings. - Monitor the resource usage of your Airbyte instance and your Postgres database during the data extraction and loading process. - Test the network latency between your source and destination. - If possible, try to reduce the size of each record or the number of records being processed at a time. - Check for any updates or bug fixes for the Airbyte connectors you're using. If none of these steps help, you might want to consider reaching out to the Airbyte community or support for further assistance.