Reports

To run the reports and view the performance of your tables month wise and day wise, navigate to the Reports tab.

Run Reports for Month

To run the reports of ingestion for a particular month, from the Reports list, select Run Reports for Month. From the Tables list, select the table and from the Months list, select the month. You can see the following in the report of the selected month:

  1. Date

  2. No. of Runs

  3. Records

  4. Extract Duration

  5. Load Duration

You can modify the report by selecting Modify and toggle off the metric that you do not want in your report. By default, all metrics are toggled on.

Run Reports for Day

To run the reports of ingestion for a particular date, from the Reports list, select Run Reports for Day. From the Tables list, select the table and from the Date column, select the date. You can see the following in the report of the selected date:

  1. Run Id

  2. File Id

  3. Extract Start

  4. Extract End

  5. Extract Duration

  6. Load Start

  7. Load End

  8. Load Duration

  9. Total Tables

  10. Loaded Tables

  11. Error Tables

  12. Initial

  13. Inserts

  14. Updates

  15. Deletes

  16. Status

You can modify the report by selecting Modify and toggle off the metric that you do not want in your report. By default, all metrics are toggled on.

Performance for Month

To view the performance of the ingestion for a particular month, from the Reports list, select Performance for Month. From the Months list, select the month. You can see the following for the selected month:

  1. A graph illustrating

    1. Total

    2. DB Delay is represented by Orange.

    3. Extract is represented by Blue.

    4. Load Wait is represented by Yellow.

    5. Load is represented by Green.

  2. Date

  3. No. of Runs

  4. Total Duration

  5. DB Delay Duration

  6. Extract Duration

  7. Load Wait Duration

  8. Load Duration

You can modify the performance view by selecting Modify and toggle off the metric that you do not want in your performance view. By default, all metrics are toggled on.

Performance for Day

To view the performance of the ingestion for a particular date, from the Reports list, select Performance for Day. From the Date column, select the date. You can see the following for the selected date:

  1. A graph illustrating

    1. Total

    2. DB Delay is represented by Orange.

    3. Extract is represented by Blue.

    4. Load Wait is represented by Yellow.

    5. Load is represented by Green.

  2. Run Id

  3. Load Finish

  4. Total Duration

  5. DB Delay Duration

  6. Extract Duration

  7. Load Wait Duration

  8. Load Duration

You can modify the performance view by selecting Modify and toggle off the metric that you do not want in your performance view. By default, all metrics are toggled on.

Last modified: January 14, 2025

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined
  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined
  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
    cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
    --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
    --bundle undefined \
    --new-bundle-format -
    Verified OK