Uploaded image for project: 'Qt Quality Assurance Infrastructure'
  1. Qt Quality Assurance Infrastructure
  2. QTQAINFRA-6448

In postgresql testresults database, investigate how to query test results based on date of workitem

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Unresolved
    • Icon: P2: Important P2: Important
    • None
    • None
    • Metrics / Test Results
    • None

      The grafana queries to the new db will be based on workitem started_on date. For example "show the flaky runs of test X in the last 6 months" means "for all test workitems that started in the last 6 months".

      The tables (test_runs_raw, flaky_tests etc) that hold this information, do not hold the date that the workitem started, they only have the "workitem_n" id that links them to the workitems table with that date.

      How to write such queries so that they perform well, without adding extra indices if possible?

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

            jimis Dimitrios Apostolou
            jimis Dimitrios Apostolou
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:

                There are no open Gerrit changes