Skip to content

SELECT * from `project_import_data` consumes a lot of DB time

The second most time-consuming queries in our system on a daily basis:

2) 5h37m42.436s - 3,204 - 2.002s/22.828s/6.324s - select "project_import_data".* from "project_import_data" where "project_import_data"."project_id" = '' limit 0;
--
        - Example 1: 22.828s - SELECT  "project_import_data".* FROM "project_import_data" WHERE "project_import_data"."project_id" = '62652' LIMIT 1;
        - Example 2: 20.170s - SELECT  "project_import_data".* FROM "project_import_data" WHERE "project_import_data"."project_id" = '955779' LIMIT 1;
        - Example 3: 19.234s - SELECT  "project_import_data".* FROM "project_import_data" WHERE "project_import_data"."project_id" = '1029452' LIMIT 1;

5 hours worth of queries in less than 24 hours.

/cc: @DouweM, @pcarranza