select id, executiondate, ruleid, directiveid, nodeid, reportid, component, keyvalue, executiontimestamp, eventtype, msg from ruddersysevents where 1=1 and id >= '0' and (eventtype='report_json') order by id asc limit 1000;
."event_report_json_idx" btree (id) WHERE eventtype = 'report_json'::text