pgFouine: PostgreSQL log analysis report

Overall statistics | Queries by type | Queries that took up the most time (N) | Slowest queries | Most frequent queries (N) | Slowest queries (N)

Normalized reports are marked with a "(N)".

Overall statistics ^

Queries by type ^

Type Count Percentage
SELECT 288,222 53.6
INSERT 25,974 4.8
UPDATE 39,347 7.3

Queries that took up the most time (N) ^

Rank Total duration Times executed Av. duration (s) Query
1 21m53s
80,103
Day Time Count Av. Duration
Jan 28 6am 688 0.05
  7am 1,498 0.05
  8am 1,511 0.05
  9am 1,264 0.06
  11am 654 0.01
  12pm 1,543 0.01
  1pm 1,543 0.01
  2pm 1,546 0.01
  3pm 1,543 0.01
  4pm 1,534 0.01
  5pm 1,477 0.01
  6pm 1,484 0.01
  7pm 1,484 0.01
  8pm 1,480 0.01
  9pm 1,485 0.01
  10pm 1,483 0.01
  11pm 1,484 0.01
Jan 29 12am 1,488 0.01
  1am 1,477 0.01
  2am 1,484 0.01
  3am 1,485 0.01
  4am 1,486 0.01
  5am 1,484 0.01
  6am 1,486 0.01
  7am 1,487 0.01
  8am 1,486 0.01
  9am 1,479 0.01
  10am 1,385 0.02
  11am 846 0.01
  12pm 1,479 0.01
  1pm 1,486 0.01
  2pm 1,483 0.01
  3pm 1,484 0.01
  4pm 1,345 0.03
  5pm 1,486 0.01
  6pm 1,481 0.01
  7pm 1,480 0.01
  8pm 1,481 0.01
  9pm 1,482 0.01
  10pm 1,478 0.01
  11pm 1,485 0.01
Jan 30 12am 1,479 0.01
  1am 1,484 0.01
  2am 1,482 0.01
  3am 1,481 0.01
  4am 1,489 0.01
  5am 1,486 0.01
  6am 1,475 0.01
  7am 1,483 0.01
  8am 1,486 0.01
  9am 1,474 0.02
  10am 1,225 0.04
  11am 1,422 0.10
  12pm 1,469 0.06
  1pm 1,475 0.02
  2pm 1,269 0.08
0.02
COMMIT;
2 9m48s
24,299
Day Time Count Av. Duration
Jan 28 6am 230 0.04
  7am 554 0.05
  8am 560 0.05
  9am 461 0.12
  11am 248 0.02
  12pm 597 0.02
  1pm 594 0.01
  2pm 594 0.01
  3pm 595 0.02
  4pm 582 0.02
  5pm 429 0.01
  6pm 432 0.01
  7pm 430 0.01
  8pm 430 0.02
  9pm 432 0.01
  10pm 431 0.01
  11pm 432 0.01
Jan 29 12am 431 0.01
  1am 430 0.01
  2am 431 0.01
  3am 431 0.01
  4am 430 0.01
  5am 430 0.01
  6am 429 0.01
  7am 432 0.01
  8am 431 0.01
  9am 396 0.01
  10am 425 0.03
  11am 250 0.02
  12pm 431 0.01
  1pm 431 0.01
  2pm 431 0.01
  3pm 431 0.02
  4pm 372 0.04
  5pm 423 0.02
  6pm 431 0.01
  7pm 431 0.01
  8pm 432 0.01
  9pm 432 0.01
  10pm 432 0.01
  11pm 430 0.01
Jan 30 12am 430 0.01
  1am 431 0.01
  2am 431 0.01
  3am 430 0.01
  4am 429 0.01
  5am 431 0.01
  6am 396 0.02
  7am 432 0.01
  8am 432 0.01
  9am 432 0.02
  10am 339 0.07
  11am 381 0.16
  12pm 412 0.08
  1pm 425 0.04
  2pm 384 0.07
0.02
commit;
3 3m2s
165,208
Day Time Count Av. Duration
Jan 28 6am 1,424 0.00
  7am 3,098 0.00
  8am 3,133 0.00
  9am 2,615 0.00
  11am 1,345 0.00
  12pm 3,172 0.00
  1pm 3,174 0.00
  2pm 3,178 0.00
  3pm 3,176 0.00
  4pm 3,150 0.00
  5pm 3,024 0.00
  6pm 3,042 0.00
  7pm 3,044 0.00
  8pm 3,032 0.00
  9pm 3,050 0.00
  10pm 3,048 0.00
  11pm 3,045 0.00
Jan 29 12am 3,075 0.00
  1am 3,028 0.00
  2am 3,046 0.00
  3am 3,056 0.00
  4am 3,054 0.00
  5am 3,046 0.00
  6am 3,062 0.00
  7am 3,066 0.00
  8am 3,060 0.00
  9am 3,042 0.00
  10am 2,846 0.00
  11am 1,748 0.00
  12pm 3,038 0.00
  1pm 3,054 0.00
  2pm 3,046 0.00
  3pm 3,056 0.00
  4pm 2,808 0.00
  5pm 3,043 0.00
  6pm 3,036 0.00
  7pm 3,034 0.00
  8pm 3,042 0.00
  9pm 3,038 0.00
  10pm 3,032 0.00
  11pm 3,050 0.00
Jan 30 12am 3,043 0.00
  1am 3,050 0.00
  2am 3,046 0.00
  3am 3,044 0.00
  4am 3,062 0.00
  5am 3,056 0.00
  6am 3,034 0.00
  7am 3,050 0.00
  8am 3,064 0.00
  9am 3,028 0.00
  10am 2,540 0.00
  11am 3,036 0.00
  12pm 3,285 0.00
  1pm 3,040 0.00
  2pm 2,674 0.00
0.00
SELECT tables.table_name FROM information_schema.tables WHERE lower(table_name) = '';
4 46.2s
2
Day Time Count Av. Duration
Jan 29 12am 1 24.39
Jan 30 12am 1 21.79
23.09
vacuum full archivedruddersysevents;
5 37.1s
3,247
Day Time Count Av. Duration
Jan 28 6am 25 0.02
  7am 60 0.02
  8am 60 0.01
  9am 55 0.02
  11am 27 0.01
  12pm 60 0.01
  1pm 60 0.01
  2pm 60 0.01
  3pm 60 0.01
  4pm 60 0.01
  5pm 60 0.01
  6pm 60 0.01
  7pm 60 0.01
  8pm 60 0.01
  9pm 60 0.01
  10pm 60 0.01
  11pm 60 0.01
Jan 29 12am 60 0.02
  1am 60 0.01
  2am 60 0.01
  3am 60 0.01
  4am 60 0.01
  5am 62 0.01
  6am 60 0.01
  7am 60 0.02
  8am 60 0.02
  9am 55 0.01
  10am 60 0.01
  11am 37 0.01
  12pm 60 0.01
  1pm 60 0.01
  2pm 60 0.01
  3pm 64 0.01
  4pm 56 0.03
  5pm 60 0.01
  6pm 60 0.01
  7pm 60 0.01
  8pm 60 0.01
  9pm 60 0.01
  10pm 60 0.01
  11pm 60 0.01
Jan 30 12am 60 0.01
  1am 60 0.01
  2am 60 0.01
  3am 60 0.01
  4am 60 0.01
  5am 62 0.01
  6am 55 0.01
  7am 60 0.02
  8am 60 0.01
  9am 60 0.01
  10am 52 0.01
  11am 60 0.05
  12pm 60 0.01
  1pm 60 0.01
  2pm 57 0.02
0.01
select id from ruddersysevents limit 0;
6 36.4s
4
Day Time Count Av. Duration
Jan 29 12am 2 10.89
Jan 30 12am 2 7.32
9.10
vacuum ruddersysevents;
7 35.9s
25,100
Day Time Count Av. Duration
Jan 28 6am 275 0.00
  7am 660 0.00
  8am 653 0.00
  9am 576 0.00
  11am 271 0.00
  12pm 648 0.00
  1pm 648 0.00
  2pm 648 0.00
  3pm 648 0.00
  4pm 630 0.00
  5pm 432 0.00
  6pm 432 0.00
  7pm 432 0.00
  8pm 432 0.00
  9pm 432 0.00
  10pm 432 0.00
  11pm 432 0.00
Jan 29 12am 431 0.00
  1am 431 0.00
  2am 431 0.00
  3am 431 0.00
  4am 431 0.00
  5am 431 0.00
  6am 432 0.00
  7am 432 0.00
  8am 432 0.00
  9am 396 0.00
  10am 432 0.00
  11am 252 0.00
  12pm 432 0.00
  1pm 432 0.00
  2pm 432 0.00
  3pm 432 0.00
  4pm 387 0.00
  5pm 432 0.00
  6pm 432 0.00
  7pm 432 0.00
  8pm 432 0.00
  9pm 432 0.00
  10pm 432 0.00
  11pm 432 0.00
Jan 30 12am 431 0.00
  1am 431 0.00
  2am 431 0.00
  3am 431 0.00
  4am 431 0.00
  5am 431 0.00
  6am 396 0.00
  7am 432 0.00
  8am 432 0.00
  9am 432 0.00
  10am 360 0.00
  11am 420 0.01
  12pm 432 0.01
  1pm 432 0.00
  2pm 396 0.00
0.00
insert into RudderSysEvents (executionDate, nodeId, ruleId, directiveId, serial, Component, KeyValue, executionTimeStamp, eventType, msg, Policy) values ('','', '' , '', '', '', '', '', '', '', '' );
8 16.0s
2
Day Time Count Av. Duration
Jan 29 12am 1 7.82
Jan 30 12am 1 8.14
7.98
: insert into archivedruddersysevents (id, executionDate, nodeId, directiveId, ruleId, serial, component, keyValue, executionTimeStamp, eventType, policy, msg) (select id, executionDate, nodeId, directiveId, ruleId, serial, component, keyValue, executionTimeStamp, eventType, policy, msg from ruddersysevents where executionTimeStamp < '');
9 5.5s
37,743
Day Time Count Av. Duration
Jan 28 6am 313 0.00
  7am 680 0.00
  8am 682 0.00
  9am 572 0.00
  11am 299 0.00
  12pm 705 0.00
  1pm 705 0.00
  2pm 705 0.00
  3pm 705 0.00
  4pm 705 0.00
  5pm 706 0.00
  6pm 707 0.00
  7pm 706 0.00
  8pm 707 0.00
  9pm 706 0.00
  10pm 706 0.00
  11pm 706 0.00
Jan 29 12am 704 0.00
  1am 705 0.00
  2am 706 0.00
  3am 706 0.00
  4am 706 0.00
  5am 706 0.00
  6am 705 0.00
  7am 704 0.00
  8am 704 0.00
  9am 706 0.00
  10am 657 0.00
  11am 399 0.00
  12pm 705 0.00
  1pm 706 0.00
  2pm 705 0.00
  3pm 704 0.00
  4pm 627 0.00
  5pm 703 0.00
  6pm 706 0.00
  7pm 706 0.00
  8pm 705 0.00
  9pm 706 0.00
  10pm 705 0.00
  11pm 706 0.00
Jan 30 12am 704 0.00
  1am 706 0.00
  2am 704 0.00
  3am 705 0.00
  4am 706 0.00
  5am 705 0.00
  6am 704 0.00
  7am 704 0.00
  8am 704 0.00
  9am 701 0.00
  10am 574 0.00
  11am 647 0.00
  12pm 685 0.00
  1pm 699 0.00
  2pm 588 0.00
0.00
update "statusupdate" set "lastid" = (0), "date" = ('') Where ("statusupdate"."key" = '');
10 5.3s
4
Day Time Count Av. Duration
Jan 29 12am 2 1.23
Jan 30 12am 2 1.42
1.32
: delete from ruddersysevents where executionTimeStamp < '';
11 2.9s
37,743
Day Time Count Av. Duration
Jan 28 6am 313 0.00
  7am 680 0.00
  8am 682 0.00
  9am 572 0.00
  11am 299 0.00
  12pm 705 0.00
  1pm 705 0.00
  2pm 705 0.00
  3pm 705 0.00
  4pm 705 0.00
  5pm 706 0.00
  6pm 707 0.00
  7pm 706 0.00
  8pm 707 0.00
  9pm 706 0.00
  10pm 706 0.00
  11pm 706 0.00
Jan 29 12am 704 0.00
  1am 705 0.00
  2am 706 0.00
  3am 706 0.00
  4am 706 0.00
  5am 706 0.00
  6am 705 0.00
  7am 704 0.00
  8am 704 0.00
  9am 706 0.00
  10am 657 0.00
  11am 399 0.00
  12pm 705 0.00
  1pm 706 0.00
  2pm 705 0.00
  3pm 704 0.00
  4pm 627 0.00
  5pm 703 0.00
  6pm 706 0.00
  7pm 706 0.00
  8pm 705 0.00
  9pm 706 0.00
  10pm 705 0.00
  11pm 706 0.00
Jan 30 12am 704 0.00
  1am 706 0.00
  2am 704 0.00
  3am 705 0.00
  4am 706 0.00
  5am 705 0.00
  6am 704 0.00
  7am 704 0.00
  8am 704 0.00
  9am 701 0.00
  10am 574 0.00
  11am 647 0.00
  12pm 685 0.00
  1pm 699 0.00
  2pm 588 0.00
0.00
Select "statusupdate4"."key" as "statusupdate4_key", "statusupdate4"."date" as "statusupdate4_date", "statusupdate4"."lastid" as "statusupdate4_lastid" From "statusupdate" "statusupdate4" Where ("statusupdate4"."key" = '');
12 2.6s
17
Day Time Count Av. Duration
Jan 28 11am 4 0.14
Jan 29 11am 3 0.16
  4pm 4 0.10
Jan 30 10am 3 0.16
  2pm 3 0.23
0.15
SELECT d.datname as "Name", pg_catalog.pg_get_userbyid(d.datdba) as "Owner", pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding", d.datcollate as "Collate", d.datctype as "Ctype", pg_catalog.array_to_string(d.datacl, E'') AS "Access privileges" FROM pg_catalog.pg_database d ORDER BY 0;
13 2.1s
37,743
Day Time Count Av. Duration
Jan 28 6am 313 0.00
  7am 680 0.00
  8am 682 0.00
  9am 572 0.00
  11am 299 0.00
  12pm 705 0.00
  1pm 705 0.00
  2pm 705 0.00
  3pm 705 0.00
  4pm 705 0.00
  5pm 706 0.00
  6pm 707 0.00
  7pm 706 0.00
  8pm 707 0.00
  9pm 706 0.00
  10pm 706 0.00
  11pm 706 0.00
Jan 29 12am 704 0.00
  1am 705 0.00
  2am 706 0.00
  3am 706 0.00
  4am 706 0.00
  5am 706 0.00
  6am 705 0.00
  7am 704 0.00
  8am 704 0.00
  9am 706 0.00
  10am 657 0.00
  11am 399 0.00
  12pm 705 0.00
  1pm 706 0.00
  2pm 705 0.00
  3pm 704 0.00
  4pm 627 0.00
  5pm 703 0.00
  6pm 706 0.00
  7pm 706 0.00
  8pm 705 0.00
  9pm 706 0.00
  10pm 705 0.00
  11pm 706 0.00
Jan 30 12am 704 0.00
  1am 706 0.00
  2am 704 0.00
  3am 705 0.00
  4am 706 0.00
  5am 705 0.00
  6am 704 0.00
  7am 704 0.00
  8am 704 0.00
  9am 701 0.00
  10am 574 0.00
  11am 647 0.00
  12pm 685 0.00
  1pm 699 0.00
  2pm 588 0.00
0.00
select T.nodeid, T.executiontimestamp, coalesce(C.iscomplete, false) as complete from (select distinct nodeid, executiontimestamp from ruddersysevents where id > 0 and id <= 0) as T left join (select true as isComplete, nodeid, executiontimestamp from ruddersysevents where id > 0 and id <= 0 and ruleId like '' and component = '' and keyValue = '') as C on T.nodeid = C.nodeid and T.executiontimestamp = C.executiontimestamp;
14 2.1s
80,105
Day Time Count Av. Duration
Jan 28 6am 688 0.00
  7am 1,498 0.00
  8am 1,511 0.00
  9am 1,264 0.00
  11am 654 0.00
  12pm 1,543 0.00
  1pm 1,543 0.00
  2pm 1,546 0.00
  3pm 1,543 0.00
  4pm 1,534 0.00
  5pm 1,477 0.00
  6pm 1,484 0.00
  7pm 1,484 0.00
  8pm 1,480 0.00
  9pm 1,485 0.00
  10pm 1,483 0.00
  11pm 1,484 0.00
Jan 29 12am 1,488 0.00
  1am 1,477 0.00
  2am 1,484 0.00
  3am 1,485 0.00
  4am 1,486 0.00
  5am 1,484 0.00
  6am 1,486 0.00
  7am 1,487 0.00
  8am 1,486 0.00
  9am 1,479 0.00
  10am 1,385 0.00
  11am 846 0.00
  12pm 1,479 0.00
  1pm 1,486 0.00
  2pm 1,483 0.00
  3pm 1,484 0.00
  4pm 1,345 0.00
  5pm 1,486 0.00
  6pm 1,481 0.00
  7pm 1,480 0.00
  8pm 1,481 0.00
  9pm 1,482 0.00
  10pm 1,478 0.00
  11pm 1,485 0.00
Jan 30 12am 1,479 0.00
  1am 1,484 0.00
  2am 1,482 0.00
  3am 1,481 0.00
  4am 1,489 0.00
  5am 1,486 0.00
  6am 1,475 0.00
  7am 1,483 0.00
  8am 1,486 0.00
  9am 1,474 0.00
  10am 1,226 0.00
  11am 1,422 0.00
  12pm 1,469 0.00
  1pm 1,475 0.00
  2pm 1,270 0.00
0.00
BEGIN;
15 2.0s
37,743
Day Time Count Av. Duration
Jan 28 6am 313 0.00
  7am 680 0.00
  8am 682 0.00
  9am 572 0.00
  11am 299 0.00
  12pm 705 0.00
  1pm 705 0.00
  2pm 705 0.00
  3pm 705 0.00
  4pm 705 0.00
  5pm 706 0.00
  6pm 707 0.00
  7pm 706 0.00
  8pm 707 0.00
  9pm 706 0.00
  10pm 706 0.00
  11pm 706 0.00
Jan 29 12am 704 0.00
  1am 705 0.00
  2am 706 0.00
  3am 706 0.00
  4am 706 0.00
  5am 706 0.00
  6am 705 0.00
  7am 704 0.00
  8am 704 0.00
  9am 706 0.00
  10am 657 0.00
  11am 399 0.00
  12pm 705 0.00
  1pm 706 0.00
  2pm 705 0.00
  3pm 704 0.00
  4pm 627 0.00
  5pm 703 0.00
  6pm 706 0.00
  7pm 706 0.00
  8pm 705 0.00
  9pm 706 0.00
  10pm 705 0.00
  11pm 706 0.00
Jan 30 12am 704 0.00
  1am 706 0.00
  2am 704 0.00
  3am 705 0.00
  4am 706 0.00
  5am 705 0.00
  6am 704 0.00
  7am 704 0.00
  8am 704 0.00
  9am 701 0.00
  10am 574 0.00
  11am 647 0.00
  12pm 685 0.00
  1pm 699 0.00
  2pm 588 0.00
0.00
select max(id) as id from RudderSysEvents where id > 0 and executionTimeStamp < '';
16 1.7s
124
Day Time Count Av. Duration
Jan 28 11am 1 0.08
Jan 29 11am 1 0.07
  4pm 1 0.13
Jan 30 10am 1 0.08
  12pm 110 0.01
  2pm 10 0.01
0.01
insert into EventLog (creationDate, modificationId, principal, eventType, severity, data ) values ('', '', '', '', 0, '' ) RETURNING "id";
17 0.7s
1
Day Time Count Av. Duration
Jan 29 12pm 1 0.75
0.75
select executiondate, nodeid, ruleid, directiveid, serial, component, keyValue, executionTimeStamp, eventtype, policy, msg from RudderSysEvents where 1=1 and nodeId = '44870e14-7761-4bc4-a30c-bf78dae5ebbf' ORDER BY id desc LIMIT 1000;
18 0.7s
750
Day Time Count Av. Duration
Jan 28 6am 10 0.01
  7am 24 0.00
  8am 24 0.00
  9am 21 0.00
  11am 11 0.01
  12pm 24 0.00
  1pm 24 0.00
  2pm 24 0.00
  3pm 24 0.00
  4pm 23 0.00
  5pm 12 0.00
  6pm 12 0.00
  7pm 12 0.00
  8pm 12 0.00
  9pm 12 0.00
  10pm 12 0.00
  11pm 12 0.00
Jan 29 12am 12 0.00
  1am 12 0.00
  2am 12 0.00
  3am 12 0.00
  4am 12 0.00
  5am 12 0.00
  6am 12 0.00
  7am 12 0.00
  8am 12 0.00
  9am 11 0.00
  10am 12 0.00
  11am 7 0.00
  12pm 12 0.00
  1pm 12 0.00
  2pm 12 0.00
  3pm 12 0.00
  4pm 11 0.00
  5pm 12 0.00
  6pm 12 0.00
  7pm 12 0.00
  8pm 12 0.00
  9pm 12 0.00
  10pm 12 0.00
  11pm 12 0.00
Jan 30 12am 12 0.00
  1am 12 0.00
  2am 12 0.00
  3am 12 0.00
  4am 12 0.00
  5am 12 0.00
  6am 11 0.00
  7am 12 0.00
  8am 12 0.00
  9am 12 0.00
  10am 10 0.01
  11am 12 0.00
  12pm 12 0.00
  1pm 12 0.01
  2pm 11 0.01
0.00
insert into "reportsexecution" ("date", "complete", "nodeid") values ('','','');
19 0.6s
14
Day Time Count Av. Duration
Jan 29 4pm 1 0.09
  5pm 3 0.00
Jan 30 10am 2 0.02
  11am 3 0.11
  12pm 3 0.00
  2pm 2 0.07
0.04
SELECT id, creationDate, modificationId, principal, eventType, severity, data, reason, causeId FROM EventLog where 0=0 and eventType in (...);
20 0.5s
5
Day Time Count Av. Duration
Jan 28 11am 1 0.12
Jan 29 11am 1 0.11
  4pm 1 0.11
Jan 30 10am 1 0.10
  2pm 1 0.07
0.10
SELECT id, creationDate, modificationId, principal, eventType, severity, data, reason, causeId FROM EventLog where 0=0 and eventtype in (...) order by creationdate desc limit 0;

Slowest queries ^

Rank Duration (s) Query
1 26.50
COMMIT;
2 24.39
vacuum full archivedruddersysevents;
3 21.79
vacuum full archivedruddersysevents;
4 14.28
vacuum ruddersysevents;
5 11.09
vacuum ruddersysevents;
6 10.56
commit;
7 8.14
: insert into archivedruddersysevents (id, executionDate, nodeId, directiveId, ruleId, serial, component, keyValue, executionTimeStamp, eventType, policy, msg) (select id, executionDate, nodeId, directiveId, ruleId, serial, component, keyValue, executionTimeStamp, eventType, policy, msg from ruddersysevents where executionTimeStamp < '2013-12-31');
8 7.82
: insert into archivedruddersysevents (id, executionDate, nodeId, directiveId, ruleId, serial, component, keyValue, executionTimeStamp, eventType, policy, msg) (select id, executionDate, nodeId, directiveId, ruleId, serial, component, keyValue, executionTimeStamp, eventType, policy, msg from ruddersysevents where executionTimeStamp < '2013-12-30');
9 7.72
COMMIT;
10 7.49
vacuum ruddersysevents;
11 6.88
commit;
12 6.43
COMMIT;
13 6.24
COMMIT;
14 5.98
COMMIT;
15 5.70
COMMIT;
16 5.28
COMMIT;
17 5.18
COMMIT;
18 5.13
COMMIT;
19 3.96
commit;
20 3.87
COMMIT;

Most frequent queries (N) ^

Rank Times executed Total duration Av. duration (s) Query
1
165,208
Day Time Count Av. Duration
Jan 28 6am 1,424 0.00
  7am 3,098 0.00
  8am 3,133 0.00
  9am 2,615 0.00
  11am 1,345 0.00
  12pm 3,172 0.00
  1pm 3,174 0.00
  2pm 3,178 0.00
  3pm 3,176 0.00
  4pm 3,150 0.00
  5pm 3,024 0.00
  6pm 3,042 0.00
  7pm 3,044 0.00
  8pm 3,032 0.00
  9pm 3,050 0.00
  10pm 3,048 0.00
  11pm 3,045 0.00
Jan 29 12am 3,075 0.00
  1am 3,028 0.00
  2am 3,046 0.00
  3am 3,056 0.00
  4am 3,054 0.00
  5am 3,046 0.00
  6am 3,062 0.00
  7am 3,066 0.00
  8am 3,060 0.00
  9am 3,042 0.00
  10am 2,846 0.00
  11am 1,748 0.00
  12pm 3,038 0.00
  1pm 3,054 0.00
  2pm 3,046 0.00
  3pm 3,056 0.00
  4pm 2,808 0.00
  5pm 3,043 0.00
  6pm 3,036 0.00
  7pm 3,034 0.00
  8pm 3,042 0.00
  9pm 3,038 0.00
  10pm 3,032 0.00
  11pm 3,050 0.00
Jan 30 12am 3,043 0.00
  1am 3,050 0.00
  2am 3,046 0.00
  3am 3,044 0.00
  4am 3,062 0.00
  5am 3,056 0.00
  6am 3,034 0.00
  7am 3,050 0.00
  8am 3,064 0.00
  9am 3,028 0.00
  10am 2,540 0.00
  11am 3,036 0.00
  12pm 3,285 0.00
  1pm 3,040 0.00
  2pm 2,674 0.00
3m2s 0.00
SELECT tables.table_name FROM information_schema.tables WHERE lower(table_name) = '';
2
80,105
Day Time Count Av. Duration
Jan 28 6am 688 0.00
  7am 1,498 0.00
  8am 1,511 0.00
  9am 1,264 0.00
  11am 654 0.00
  12pm 1,543 0.00
  1pm 1,543 0.00
  2pm 1,546 0.00
  3pm 1,543 0.00
  4pm 1,534 0.00
  5pm 1,477 0.00
  6pm 1,484 0.00
  7pm 1,484 0.00
  8pm 1,480 0.00
  9pm 1,485 0.00
  10pm 1,483 0.00
  11pm 1,484 0.00
Jan 29 12am 1,488 0.00
  1am 1,477 0.00
  2am 1,484 0.00
  3am 1,485 0.00
  4am 1,486 0.00
  5am 1,484 0.00
  6am 1,486 0.00
  7am 1,487 0.00
  8am 1,486 0.00
  9am 1,479 0.00
  10am 1,385 0.00
  11am 846 0.00
  12pm 1,479 0.00
  1pm 1,486 0.00
  2pm 1,483 0.00
  3pm 1,484 0.00
  4pm 1,345 0.00
  5pm 1,486 0.00
  6pm 1,481 0.00
  7pm 1,480 0.00
  8pm 1,481 0.00
  9pm 1,482 0.00
  10pm 1,478 0.00
  11pm 1,485 0.00
Jan 30 12am 1,479 0.00
  1am 1,484 0.00
  2am 1,482 0.00
  3am 1,481 0.00
  4am 1,489 0.00
  5am 1,486 0.00
  6am 1,475 0.00
  7am 1,483 0.00
  8am 1,486 0.00
  9am 1,474 0.00
  10am 1,226 0.00
  11am 1,422 0.00
  12pm 1,469 0.00
  1pm 1,475 0.00
  2pm 1,270 0.00
2.1s 0.00
BEGIN;
3
80,103
Day Time Count Av. Duration
Jan 28 6am 688 0.05
  7am 1,498 0.05
  8am 1,511 0.05
  9am 1,264 0.06
  11am 654 0.01
  12pm 1,543 0.01
  1pm 1,543 0.01
  2pm 1,546 0.01
  3pm 1,543 0.01
  4pm 1,534 0.01
  5pm 1,477 0.01
  6pm 1,484 0.01
  7pm 1,484 0.01
  8pm 1,480 0.01
  9pm 1,485 0.01
  10pm 1,483 0.01
  11pm 1,484 0.01
Jan 29 12am 1,488 0.01
  1am 1,477 0.01
  2am 1,484 0.01
  3am 1,485 0.01
  4am 1,486 0.01
  5am 1,484 0.01
  6am 1,486 0.01
  7am 1,487 0.01
  8am 1,486 0.01
  9am 1,479 0.01
  10am 1,385 0.02
  11am 846 0.01
  12pm 1,479 0.01
  1pm 1,486 0.01
  2pm 1,483 0.01
  3pm 1,484 0.01
  4pm 1,345 0.03
  5pm 1,486 0.01
  6pm 1,481 0.01
  7pm 1,480 0.01
  8pm 1,481 0.01
  9pm 1,482 0.01
  10pm 1,478 0.01
  11pm 1,485 0.01
Jan 30 12am 1,479 0.01
  1am 1,484 0.01
  2am 1,482 0.01
  3am 1,481 0.01
  4am 1,489 0.01
  5am 1,486 0.01
  6am 1,475 0.01
  7am 1,483 0.01
  8am 1,486 0.01
  9am 1,474 0.02
  10am 1,225 0.04
  11am 1,422 0.10
  12pm 1,469 0.06
  1pm 1,475 0.02
  2pm 1,269 0.08
21m53s 0.02
COMMIT;
4
37,743
Day Time Count Av. Duration
Jan 28 6am 313 0.00
  7am 680 0.00
  8am 682 0.00
  9am 572 0.00
  11am 299 0.00
  12pm 705 0.00
  1pm 705 0.00
  2pm 705 0.00
  3pm 705 0.00
  4pm 705 0.00
  5pm 706 0.00
  6pm 707 0.00
  7pm 706 0.00
  8pm 707 0.00
  9pm 706 0.00
  10pm 706 0.00
  11pm 706 0.00
Jan 29 12am 704 0.00
  1am 705 0.00
  2am 706 0.00
  3am 706 0.00
  4am 706 0.00
  5am 706 0.00
  6am 705 0.00
  7am 704 0.00
  8am 704 0.00
  9am 706 0.00
  10am 657 0.00
  11am 399 0.00
  12pm 705 0.00
  1pm 706 0.00
  2pm 705 0.00
  3pm 704 0.00
  4pm 627 0.00
  5pm 703 0.00
  6pm 706 0.00
  7pm 706 0.00
  8pm 705 0.00
  9pm 706 0.00
  10pm 705 0.00
  11pm 706 0.00
Jan 30 12am 704 0.00
  1am 706 0.00
  2am 704 0.00
  3am 705 0.00
  4am 706 0.00
  5am 705 0.00
  6am 704 0.00
  7am 704 0.00
  8am 704 0.00
  9am 701 0.00
  10am 574 0.00
  11am 647 0.00
  12pm 685 0.00
  1pm 699 0.00
  2pm 588 0.00
5.5s 0.00
update "statusupdate" set "lastid" = (0), "date" = ('') Where ("statusupdate"."key" = '');
5
37,743
Day Time Count Av. Duration
Jan 28 6am 313 0.00
  7am 680 0.00
  8am 682 0.00
  9am 572 0.00
  11am 299 0.00
  12pm 705 0.00
  1pm 705 0.00
  2pm 705 0.00
  3pm 705 0.00
  4pm 705 0.00
  5pm 706 0.00
  6pm 707 0.00
  7pm 706 0.00
  8pm 707 0.00
  9pm 706 0.00
  10pm 706 0.00
  11pm 706 0.00
Jan 29 12am 704 0.00
  1am 705 0.00
  2am 706 0.00
  3am 706 0.00
  4am 706 0.00
  5am 706 0.00
  6am 705 0.00
  7am 704 0.00
  8am 704 0.00
  9am 706 0.00
  10am 657 0.00
  11am 399 0.00
  12pm 705 0.00
  1pm 706 0.00
  2pm 705 0.00
  3pm 704 0.00
  4pm 627 0.00
  5pm 703 0.00
  6pm 706 0.00
  7pm 706 0.00
  8pm 705 0.00
  9pm 706 0.00
  10pm 705 0.00
  11pm 706 0.00
Jan 30 12am 704 0.00
  1am 706 0.00
  2am 704 0.00
  3am 705 0.00
  4am 706 0.00
  5am 705 0.00
  6am 704 0.00
  7am 704 0.00
  8am 704 0.00
  9am 701 0.00
  10am 574 0.00
  11am 647 0.00
  12pm 685 0.00
  1pm 699 0.00
  2pm 588 0.00
2.9s 0.00
Select "statusupdate4"."key" as "statusupdate4_key", "statusupdate4"."date" as "statusupdate4_date", "statusupdate4"."lastid" as "statusupdate4_lastid" From "statusupdate" "statusupdate4" Where ("statusupdate4"."key" = '');
6
37,743
Day Time Count Av. Duration
Jan 28 6am 313 0.00
  7am 680 0.00
  8am 682 0.00
  9am 572 0.00
  11am 299 0.00
  12pm 705 0.00
  1pm 705 0.00
  2pm 705 0.00
  3pm 705 0.00
  4pm 705 0.00
  5pm 706 0.00
  6pm 707 0.00
  7pm 706 0.00
  8pm 707 0.00
  9pm 706 0.00
  10pm 706 0.00
  11pm 706 0.00
Jan 29 12am 704 0.00
  1am 705 0.00
  2am 706 0.00
  3am 706 0.00
  4am 706 0.00
  5am 706 0.00
  6am 705 0.00
  7am 704 0.00
  8am 704 0.00
  9am 706 0.00
  10am 657 0.00
  11am 399 0.00
  12pm 705 0.00
  1pm 706 0.00
  2pm 705 0.00
  3pm 704 0.00
  4pm 627 0.00
  5pm 703 0.00
  6pm 706 0.00
  7pm 706 0.00
  8pm 705 0.00
  9pm 706 0.00
  10pm 705 0.00
  11pm 706 0.00
Jan 30 12am 704 0.00
  1am 706 0.00
  2am 704 0.00
  3am 705 0.00
  4am 706 0.00
  5am 705 0.00
  6am 704 0.00
  7am 704 0.00
  8am 704 0.00
  9am 701 0.00
  10am 574 0.00
  11am 647 0.00
  12pm 685 0.00
  1pm 699 0.00
  2pm 588 0.00
2.1s 0.00
select T.nodeid, T.executiontimestamp, coalesce(C.iscomplete, false) as complete from (select distinct nodeid, executiontimestamp from ruddersysevents where id > 0 and id <= 0) as T left join (select true as isComplete, nodeid, executiontimestamp from ruddersysevents where id > 0 and id <= 0 and ruleId like '' and component = '' and keyValue = '') as C on T.nodeid = C.nodeid and T.executiontimestamp = C.executiontimestamp;
7
37,743
Day Time Count Av. Duration
Jan 28 6am 313 0.00
  7am 680 0.00
  8am 682 0.00
  9am 572 0.00
  11am 299 0.00
  12pm 705 0.00
  1pm 705 0.00
  2pm 705 0.00
  3pm 705 0.00
  4pm 705 0.00
  5pm 706 0.00
  6pm 707 0.00
  7pm 706 0.00
  8pm 707 0.00
  9pm 706 0.00
  10pm 706 0.00
  11pm 706 0.00
Jan 29 12am 704 0.00
  1am 705 0.00
  2am 706 0.00
  3am 706 0.00
  4am 706 0.00
  5am 706 0.00
  6am 705 0.00
  7am 704 0.00
  8am 704 0.00
  9am 706 0.00
  10am 657 0.00
  11am 399 0.00
  12pm 705 0.00
  1pm 706 0.00
  2pm 705 0.00
  3pm 704 0.00
  4pm 627 0.00
  5pm 703 0.00
  6pm 706 0.00
  7pm 706 0.00
  8pm 705 0.00
  9pm 706 0.00
  10pm 705 0.00
  11pm 706 0.00
Jan 30 12am 704 0.00
  1am 706 0.00
  2am 704 0.00
  3am 705 0.00
  4am 706 0.00
  5am 705 0.00
  6am 704 0.00
  7am 704 0.00
  8am 704 0.00
  9am 701 0.00
  10am 574 0.00
  11am 647 0.00
  12pm 685 0.00
  1pm 699 0.00
  2pm 588 0.00
2.0s 0.00
select max(id) as id from RudderSysEvents where id > 0 and executionTimeStamp < '';
8
25,100
Day Time Count Av. Duration
Jan 28 6am 275 0.00
  7am 660 0.00
  8am 653 0.00
  9am 576 0.00
  11am 271 0.00
  12pm 648 0.00
  1pm 648 0.00
  2pm 648 0.00
  3pm 648 0.00
  4pm 630 0.00
  5pm 432 0.00
  6pm 432 0.00
  7pm 432 0.00
  8pm 432 0.00
  9pm 432 0.00
  10pm 432 0.00
  11pm 432 0.00
Jan 29 12am 431 0.00
  1am 431 0.00
  2am 431 0.00
  3am 431 0.00
  4am 431 0.00
  5am 431 0.00
  6am 432 0.00
  7am 432 0.00
  8am 432 0.00
  9am 396 0.00
  10am 432 0.00
  11am 252 0.00
  12pm 432 0.00
  1pm 432 0.00
  2pm 432 0.00
  3pm 432 0.00
  4pm 387 0.00
  5pm 432 0.00
  6pm 432 0.00
  7pm 432 0.00
  8pm 432 0.00
  9pm 432 0.00
  10pm 432 0.00
  11pm 432 0.00
Jan 30 12am 431 0.00
  1am 431 0.00
  2am 431 0.00
  3am 431 0.00
  4am 431 0.00
  5am 431 0.00
  6am 396 0.00
  7am 432 0.00
  8am 432 0.00
  9am 432 0.00
  10am 360 0.00
  11am 420 0.01
  12pm 432 0.01
  1pm 432 0.00
  2pm 396 0.00
35.9s 0.00
insert into RudderSysEvents (executionDate, nodeId, ruleId, directiveId, serial, Component, KeyValue, executionTimeStamp, eventType, msg, Policy) values ('','', '' , '', '', '', '', '', '', '', '' );
9
24,299
Day Time Count Av. Duration
Jan 28 6am 230 0.04
  7am 554 0.05
  8am 560 0.05
  9am 461 0.12
  11am 248 0.02
  12pm 597 0.02
  1pm 594 0.01
  2pm 594 0.01
  3pm 595 0.02
  4pm 582 0.02
  5pm 429 0.01
  6pm 432 0.01
  7pm 430 0.01
  8pm 430 0.02
  9pm 432 0.01
  10pm 431 0.01
  11pm 432 0.01
Jan 29 12am 431 0.01
  1am 430 0.01
  2am 431 0.01
  3am 431 0.01
  4am 430 0.01
  5am 430 0.01
  6am 429 0.01
  7am 432 0.01
  8am 431 0.01
  9am 396 0.01
  10am 425 0.03
  11am 250 0.02
  12pm 431 0.01
  1pm 431 0.01
  2pm 431 0.01
  3pm 431 0.02
  4pm 372 0.04
  5pm 423 0.02
  6pm 431 0.01
  7pm 431 0.01
  8pm 432 0.01
  9pm 432 0.01
  10pm 432 0.01
  11pm 430 0.01
Jan 30 12am 430 0.01
  1am 431 0.01
  2am 431 0.01
  3am 430 0.01
  4am 429 0.01
  5am 431 0.01
  6am 396 0.02
  7am 432 0.01
  8am 432 0.01
  9am 432 0.02
  10am 339 0.07
  11am 381 0.16
  12pm 412 0.08
  1pm 425 0.04
  2pm 384 0.07
9m48s 0.02
commit;
10
3,247
Day Time Count Av. Duration
Jan 28 6am 25 0.02
  7am 60 0.02
  8am 60 0.01
  9am 55 0.02
  11am 27 0.01
  12pm 60 0.01
  1pm 60 0.01
  2pm 60 0.01
  3pm 60 0.01
  4pm 60 0.01
  5pm 60 0.01
  6pm 60 0.01
  7pm 60 0.01
  8pm 60 0.01
  9pm 60 0.01
  10pm 60 0.01
  11pm 60 0.01
Jan 29 12am 60 0.02
  1am 60 0.01
  2am 60 0.01
  3am 60 0.01
  4am 60 0.01
  5am 62 0.01
  6am 60 0.01
  7am 60 0.02
  8am 60 0.02
  9am 55 0.01
  10am 60 0.01
  11am 37 0.01
  12pm 60 0.01
  1pm 60 0.01
  2pm 60 0.01
  3pm 64 0.01
  4pm 56 0.03
  5pm 60 0.01
  6pm 60 0.01
  7pm 60 0.01
  8pm 60 0.01
  9pm 60 0.01
  10pm 60 0.01
  11pm 60 0.01
Jan 30 12am 60 0.01
  1am 60 0.01
  2am 60 0.01
  3am 60 0.01
  4am 60 0.01
  5am 62 0.01
  6am 55 0.01
  7am 60 0.02
  8am 60 0.01
  9am 60 0.01
  10am 52 0.01
  11am 60 0.05
  12pm 60 0.01
  1pm 60 0.01
  2pm 57 0.02
37.1s 0.01
select id from ruddersysevents limit 0;
11
3,231
Day Time Count Av. Duration
Jan 28 6am 28 0.00
  7am 60 0.00
  8am 59 0.00
  9am 51 0.00
  11am 26 0.00
  12pm 60 0.00
  1pm 60 0.00
  2pm 60 0.00
  3pm 60 0.00
  4pm 60 0.00
  5pm 60 0.00
  6pm 60 0.00
  7pm 60 0.00
  8pm 60 0.00
  9pm 60 0.00
  10pm 60 0.00
  11pm 59 0.00
Jan 29 12am 60 0.00
  1am 60 0.00
  2am 60 0.00
  3am 60 0.00
  4am 60 0.00
  5am 60 0.00
  6am 60 0.00
  7am 60 0.00
  8am 60 0.00
  9am 60 0.00
  10am 56 0.00
  11am 34 0.00
  12pm 60 0.00
  1pm 60 0.00
  2pm 60 0.00
  3pm 60 0.00
  4pm 55 0.00
  5pm 60 0.00
  6pm 60 0.00
  7pm 60 0.00
  8pm 60 0.00
  9pm 60 0.00
  10pm 60 0.00
  11pm 60 0.00
Jan 30 12am 60 0.00
  1am 60 0.00
  2am 60 0.00
  3am 60 0.00
  4am 60 0.00
  5am 60 0.00
  6am 60 0.00
  7am 60 0.00
  8am 60 0.00
  9am 60 0.00
  10am 51 0.00
  11am 59 0.00
  12pm 60 0.00
  1pm 60 0.00
  2pm 53 0.00
0.4s 0.00
select id from RudderSysEvents order by id desc limit 0;
12
2,244
Day Time Count Av. Duration
Jan 28 6am 30 0.00
  7am 71 0.00
  8am 74 0.00
  9am 61 0.00
  11am 25 0.00
  12pm 62 0.00
  1pm 62 0.00
  2pm 61 0.00
  3pm 64 0.00
  4pm 58 0.00
  5pm 29 0.00
  6pm 31 0.00
  7pm 32 0.00
  8pm 30 0.00
  9pm 34 0.00
  10pm 35 0.00
  11pm 33 0.00
Jan 29 12am 40 0.00
  1am 31 0.00
  2am 33 0.00
  3am 37 0.00
  4am 35 0.00
  5am 33 0.00
  6am 39 0.00
  7am 40 0.00
  8am 38 0.00
  9am 34 0.00
  10am 34 0.00
  11am 23 0.00
  12pm 31 0.00
  1pm 35 0.00
  2pm 34 0.00
  3pm 38 0.00
  4pm 49 0.00
  5pm 33 0.00
  6pm 31 0.00
  7pm 31 0.00
  8pm 34 0.00
  9pm 31 0.00
  10pm 32 0.00
  11pm 34 0.00
Jan 30 12am 33 0.00
  1am 35 0.00
  2am 35 0.00
  3am 35 0.00
  4am 36 0.00
  5am 36 0.00
  6am 34 0.00
  7am 36 0.00
  8am 40 0.00
  9am 34 0.00
  10am 37 0.00
  11am 85 0.00
  12pm 56 0.00
  1pm 39 0.00
  2pm 51 0.00
0.4s 0.00
Select "reportsexecution4"."date" as "reportsexecution4_date", "reportsexecution4"."complete" as "reportsexecution4_complete", "reportsexecution4"."nodeid" as "reportsexecution4_nodeid" From "reportsexecution" "reportsexecution4" Where (("reportsexecution4"."nodeid" = '') and ("reportsexecution4"."date" = ''));
13
863
Day Time Count Av. Duration
Jan 28 6am 12 0.00
  7am 21 0.00
  8am 25 0.00
  9am 20 0.00
  11am 8 0.00
  12pm 24 0.00
  1pm 23 0.00
  2pm 27 0.00
  3pm 22 0.00
  4pm 21 0.00
  5pm 12 0.00
  6pm 15 0.00
  7pm 16 0.00
  8pm 12 0.00
  9pm 15 0.00
  10pm 12 0.00
  11pm 15 0.00
Jan 29 12am 16 0.00
  1am 12 0.00
  2am 15 0.00
  3am 12 0.00
  4am 15 0.00
  5am 15 0.00
  6am 13 0.00
  7am 15 0.00
  8am 16 0.00
  9am 11 0.00
  10am 13 0.00
  11am 9 0.00
  12pm 12 0.00
  1pm 15 0.00
  2pm 15 0.00
  3pm 14 0.00
  4pm 19 0.00
  5pm 13 0.00
  6pm 14 0.00
  7pm 13 0.00
  8pm 13 0.00
  9pm 15 0.00
  10pm 12 0.00
  11pm 15 0.00
Jan 30 12am 14 0.00
  1am 13 0.00
  2am 15 0.00
  3am 12 0.00
  4am 17 0.00
  5am 16 0.00
  6am 11 0.00
  7am 15 0.00
  8am 14 0.00
  9am 14 0.00
  10am 16 0.00
  11am 23 0.00
  12pm 19 0.00
  1pm 14 0.00
  2pm 18 0.00
0.2s 0.00
update "rudderproperties" set "value" = (0) Where ("rudderproperties"."name" = '');
14
863
Day Time Count Av. Duration
Jan 28 6am 12 0.00
  7am 21 0.00
  8am 25 0.00
  9am 20 0.00
  11am 8 0.00
  12pm 24 0.00
  1pm 23 0.00
  2pm 27 0.00
  3pm 22 0.00
  4pm 21 0.00
  5pm 12 0.00
  6pm 15 0.00
  7pm 16 0.00
  8pm 12 0.00
  9pm 15 0.00
  10pm 12 0.00
  11pm 15 0.00
Jan 29 12am 16 0.00
  1am 12 0.00
  2am 15 0.00
  3am 12 0.00
  4am 15 0.00
  5am 15 0.00
  6am 13 0.00
  7am 15 0.00
  8am 16 0.00
  9am 11 0.00
  10am 13 0.00
  11am 9 0.00
  12pm 12 0.00
  1pm 15 0.00
  2pm 15 0.00
  3pm 14 0.00
  4pm 19 0.00
  5pm 13 0.00
  6pm 14 0.00
  7pm 13 0.00
  8pm 13 0.00
  9pm 15 0.00
  10pm 12 0.00
  11pm 15 0.00
Jan 30 12am 14 0.00
  1am 13 0.00
  2am 15 0.00
  3am 12 0.00
  4am 17 0.00
  5am 16 0.00
  6am 11 0.00
  7am 15 0.00
  8am 14 0.00
  9am 14 0.00
  10am 16 0.00
  11am 23 0.00
  12pm 19 0.00
  1pm 14 0.00
  2pm 18 0.00
0.2s 0.00
select executiondate, nodeid, ruleid, directiveid, serial, component, keyValue, executionTimeStamp, eventtype, policy, msg from RudderSysEvents where 0=0 and id between '' and '' and (eventtype='' or eventtype='' or eventtype='' or eventtype='') order by executiondate asc;
15
750
Day Time Count Av. Duration
Jan 28 6am 10 0.01
  7am 24 0.00
  8am 24 0.00
  9am 21 0.00
  11am 11 0.01
  12pm 24 0.00
  1pm 24 0.00
  2pm 24 0.00
  3pm 24 0.00
  4pm 23 0.00
  5pm 12 0.00
  6pm 12 0.00
  7pm 12 0.00
  8pm 12 0.00
  9pm 12 0.00
  10pm 12 0.00
  11pm 12 0.00
Jan 29 12am 12 0.00
  1am 12 0.00
  2am 12 0.00
  3am 12 0.00
  4am 12 0.00
  5am 12 0.00
  6am 12 0.00
  7am 12 0.00
  8am 12 0.00
  9am 11 0.00
  10am 12 0.00
  11am 7 0.00
  12pm 12 0.00
  1pm 12 0.00
  2pm 12 0.00
  3pm 12 0.00
  4pm 11 0.00
  5pm 12 0.00
  6pm 12 0.00
  7pm 12 0.00
  8pm 12 0.00
  9pm 12 0.00
  10pm 12 0.00
  11pm 12 0.00
Jan 30 12am 12 0.00
  1am 12 0.00
  2am 12 0.00
  3am 12 0.00
  4am 12 0.00
  5am 12 0.00
  6am 11 0.00
  7am 12 0.00
  8am 12 0.00
  9am 12 0.00
  10am 10 0.01
  11am 12 0.00
  12pm 12 0.00
  1pm 12 0.01
  2pm 11 0.01
0.7s 0.00
insert into "reportsexecution" ("date", "complete", "nodeid") values ('','','');
16
741
Day Time Count Av. Duration
Jan 28 6am 10 0.00
  7am 24 0.00
  8am 24 0.00
  9am 20 0.00
  11am 10 0.00
  12pm 24 0.00
  1pm 24 0.00
  2pm 24 0.00
  3pm 24 0.00
  4pm 23 0.00
  5pm 12 0.00
  6pm 12 0.00
  7pm 12 0.00
  8pm 12 0.00
  9pm 12 0.00
  10pm 12 0.00
  11pm 12 0.00
Jan 29 12am 12 0.00
  1am 12 0.00
  2am 12 0.00
  3am 12 0.00
  4am 12 0.00
  5am 12 0.00
  6am 12 0.00
  7am 12 0.00
  8am 12 0.00
  9am 11 0.00
  10am 12 0.00
  11am 7 0.00
  12pm 12 0.00
  1pm 12 0.00
  2pm 12 0.00
  3pm 12 0.00
  4pm 8 0.00
  5pm 12 0.00
  6pm 12 0.00
  7pm 12 0.00
  8pm 12 0.00
  9pm 12 0.00
  10pm 12 0.00
  11pm 12 0.00
Jan 30 12am 12 0.00
  1am 12 0.00
  2am 12 0.00
  3am 12 0.00
  4am 12 0.00
  5am 12 0.00
  6am 11 0.00
  7am 12 0.00
  8am 12 0.00
  9am 12 0.00
  10am 10 0.00
  11am 8 0.00
  12pm 12 0.00
  1pm 12 0.00
  2pm 11 0.00
0.1s 0.00
update "reportsexecution" set "complete" = ('') Where (("reportsexecution"."nodeid" = '') and ("reportsexecution"."date" = ''));
17
124
Day Time Count Av. Duration
Jan 28 11am 1 0.08
Jan 29 11am 1 0.07
  4pm 1 0.13
Jan 30 10am 1 0.08
  12pm 110 0.01
  2pm 10 0.01
1.7s 0.01
insert into EventLog (creationDate, modificationId, principal, eventType, severity, data ) values ('', '', '', '', 0, '' ) RETURNING "id";
18
124
Day Time Count Av. Duration
Jan 28 11am 1 0.00
Jan 29 11am 1 0.00
  4pm 1 0.00
Jan 30 10am 1 0.00
  12pm 110 0.00
  2pm 10 0.00
0.0s 0.00
SELECT id, creationDate, modificationId, principal, eventType, severity, data, reason, causeId FROM EventLog where 0=0 and id = 0;
19
17
Day Time Count Av. Duration
Jan 28 11am 4 0.14
Jan 29 11am 3 0.16
  4pm 4 0.10
Jan 30 10am 3 0.16
  2pm 3 0.23
2.6s 0.15
SELECT d.datname as "Name", pg_catalog.pg_get_userbyid(d.datdba) as "Owner", pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding", d.datcollate as "Collate", d.datctype as "Ctype", pg_catalog.array_to_string(d.datacl, E'') AS "Access privileges" FROM pg_catalog.pg_database d ORDER BY 0;
20
16
Day Time Count Av. Duration
Jan 29 12pm 2 0.05
  4pm 2 0.02
  5pm 10 0.00
Jan 30 10am 2 0.03
0.2s 0.01
Select "reportsexecution4"."date" as "reportsexecution4_date", "reportsexecution4"."complete" as "reportsexecution4_complete", "reportsexecution4"."nodeid" as "reportsexecution4_nodeid" From "reportsexecution" "reportsexecution4" Where ("reportsexecution4"."nodeid" = '') Order By "reportsexecution4"."date" Desc limit 0 offset 0;

Slowest queries (N) ^

Rank Av. duration (s) Times executed Total duration Query
1 23.09
2
Day Time Count Av. Duration
Jan 29 12am 1 24.39
Jan 30 12am 1 21.79
46.2s
vacuum full archivedruddersysevents;
2 9.10
4
Day Time Count Av. Duration
Jan 29 12am 2 10.89
Jan 30 12am 2 7.32
36.4s
vacuum ruddersysevents;
3 7.98
2
Day Time Count Av. Duration
Jan 29 12am 1 7.82
Jan 30 12am 1 8.14
16.0s
: insert into archivedruddersysevents (id, executionDate, nodeId, directiveId, ruleId, serial, component, keyValue, executionTimeStamp, eventType, policy, msg) (select id, executionDate, nodeId, directiveId, ruleId, serial, component, keyValue, executionTimeStamp, eventType, policy, msg from ruddersysevents where executionTimeStamp < '');
4 1.32
4
Day Time Count Av. Duration
Jan 29 12am 2 1.23
Jan 30 12am 2 1.42
5.3s
: delete from ruddersysevents where executionTimeStamp < '';
5 0.75
1
Day Time Count Av. Duration
Jan 29 12pm 1 0.75
0.7s
select executiondate, nodeid, ruleid, directiveid, serial, component, keyValue, executionTimeStamp, eventtype, policy, msg from RudderSysEvents where 1=1 and nodeId = '44870e14-7761-4bc4-a30c-bf78dae5ebbf' ORDER BY id desc LIMIT 1000;
6 0.15
17
Day Time Count Av. Duration
Jan 28 11am 4 0.14
Jan 29 11am 3 0.16
  4pm 4 0.10
Jan 30 10am 3 0.16
  2pm 3 0.23
2.6s
SELECT d.datname as "Name", pg_catalog.pg_get_userbyid(d.datdba) as "Owner", pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding", d.datcollate as "Collate", d.datctype as "Ctype", pg_catalog.array_to_string(d.datacl, E'') AS "Access privileges" FROM pg_catalog.pg_database d ORDER BY 0;
7 0.10
5
Day Time Count Av. Duration
Jan 28 11am 1 0.12
Jan 29 11am 1 0.11
  4pm 1 0.11
Jan 30 10am 1 0.10
  2pm 1 0.07
0.5s
SELECT id, creationDate, modificationId, principal, eventType, severity, data, reason, causeId FROM EventLog where 0=0 and eventtype in (...) order by creationdate desc limit 0;
8 0.06
1
Day Time Count Av. Duration
Jan 29 12pm 1 0.06
0.1s
select pkid, expectedreports.nodejoinkey, ruleid,directiveid, serial, component, componentsvalues, unexpandedComponentsValues, cardinality, begindate, enddate from expectedreports join expectedreportsnodes on expectedreportsnodes.nodejoinkey = expectedreports.nodejoinkey where enddate is null and expectedreportsnodes.nodeId = '44870e14-7761-4bc4-a30c-bf78dae5ebbf';
9 0.04
14
Day Time Count Av. Duration
Jan 29 4pm 1 0.09
  5pm 3 0.00
Jan 30 10am 2 0.02
  11am 3 0.11
  12pm 3 0.00
  2pm 2 0.07
0.6s
SELECT id, creationDate, modificationId, principal, eventType, severity, data, reason, causeId FROM EventLog where 0=0 and eventType in (...);
10 0.02
24,299
Day Time Count Av. Duration
Jan 28 6am 230 0.04
  7am 554 0.05
  8am 560 0.05
  9am 461 0.12
  11am 248 0.02
  12pm 597 0.02
  1pm 594 0.01
  2pm 594 0.01
  3pm 595 0.02
  4pm 582 0.02
  5pm 429 0.01
  6pm 432 0.01
  7pm 430 0.01
  8pm 430 0.02
  9pm 432 0.01
  10pm 431 0.01
  11pm 432 0.01
Jan 29 12am 431 0.01
  1am 430 0.01
  2am 431 0.01
  3am 431 0.01
  4am 430 0.01
  5am 430 0.01
  6am 429 0.01
  7am 432 0.01
  8am 431 0.01
  9am 396 0.01
  10am 425 0.03
  11am 250 0.02
  12pm 431 0.01
  1pm 431 0.01
  2pm 431 0.01
  3pm 431 0.02
  4pm 372 0.04
  5pm 423 0.02
  6pm 431 0.01
  7pm 431 0.01
  8pm 432 0.01
  9pm 432 0.01
  10pm 432 0.01
  11pm 430 0.01
Jan 30 12am 430 0.01
  1am 431 0.01
  2am 431 0.01
  3am 430 0.01
  4am 429 0.01
  5am 431 0.01
  6am 396 0.02
  7am 432 0.01
  8am 432 0.01
  9am 432 0.02
  10am 339 0.07
  11am 381 0.16
  12pm 412 0.08
  1pm 425 0.04
  2pm 384 0.07
9m48s
commit;
11 0.02
80,103
Day Time Count Av. Duration
Jan 28 6am 688 0.05
  7am 1,498 0.05
  8am 1,511 0.05
  9am 1,264 0.06
  11am 654 0.01
  12pm 1,543 0.01
  1pm 1,543 0.01
  2pm 1,546 0.01
  3pm 1,543 0.01
  4pm 1,534 0.01
  5pm 1,477 0.01
  6pm 1,484 0.01
  7pm 1,484 0.01
  8pm 1,480 0.01
  9pm 1,485 0.01
  10pm 1,483 0.01
  11pm 1,484 0.01
Jan 29 12am 1,488 0.01
  1am 1,477 0.01
  2am 1,484 0.01
  3am 1,485 0.01
  4am 1,486 0.01
  5am 1,484 0.01
  6am 1,486 0.01
  7am 1,487 0.01
  8am 1,486 0.01
  9am 1,479 0.01
  10am 1,385 0.02
  11am 846 0.01
  12pm 1,479 0.01
  1pm 1,486 0.01
  2pm 1,483 0.01
  3pm 1,484 0.01
  4pm 1,345 0.03
  5pm 1,486 0.01
  6pm 1,481 0.01
  7pm 1,480 0.01
  8pm 1,481 0.01
  9pm 1,482 0.01
  10pm 1,478 0.01
  11pm 1,485 0.01
Jan 30 12am 1,479 0.01
  1am 1,484 0.01
  2am 1,482 0.01
  3am 1,481 0.01
  4am 1,489 0.01
  5am 1,486 0.01
  6am 1,475 0.01
  7am 1,483 0.01
  8am 1,486 0.01
  9am 1,474 0.02
  10am 1,225 0.04
  11am 1,422 0.10
  12pm 1,469 0.06
  1pm 1,475 0.02
  2pm 1,269 0.08
21m53s
COMMIT;
12 0.01
5
Day Time Count Av. Duration
Jan 28 11am 1 0.01
Jan 29 11am 1 0.01
  4pm 1 0.03
Jan 30 10am 1 0.01
  2pm 1 0.01
0.1s
Select "migrationeventlog8"."migrationfileformat" as "migrationeventlog8_migrationfileformat", "migrationeventlog8"."detectedfileformat" as "migrationeventlog8_detectedfileformat", "migrationeventlog8"."description" as "migrationeventlog8_description", "migrationeventlog8"."migrationendtime" as "migrationeventlog8_migrationendtime", "migrationeventlog8"."migrationstarttime" as "migrationeventlog8_migrationstarttime", "migrationeventlog8"."id" as "migrationeventlog8_id", "migrationeventlog8"."detectiontime" as "migrationeventlog8_detectiontime" From "migrationeventlog" "migrationeventlog8" Order By "migrationeventlog8"."id" Desc limit 0 offset 0;
13 0.01
124
Day Time Count Av. Duration
Jan 28 11am 1 0.08
Jan 29 11am 1 0.07
  4pm 1 0.13
Jan 30 10am 1 0.08
  12pm 110 0.01
  2pm 10 0.01
1.7s
insert into EventLog (creationDate, modificationId, principal, eventType, severity, data ) values ('', '', '', '', 0, '' ) RETURNING "id";
14 0.01
16
Day Time Count Av. Duration
Jan 29 12pm 2 0.05
  4pm 2 0.02
  5pm 10 0.00
Jan 30 10am 2 0.03
0.2s
Select "reportsexecution4"."date" as "reportsexecution4_date", "reportsexecution4"."complete" as "reportsexecution4_complete", "reportsexecution4"."nodeid" as "reportsexecution4_nodeid" From "reportsexecution" "reportsexecution4" Where ("reportsexecution4"."nodeid" = '') Order By "reportsexecution4"."date" Desc limit 0 offset 0;
15 0.01
3,247
Day Time Count Av. Duration
Jan 28 6am 25 0.02
  7am 60 0.02
  8am 60 0.01
  9am 55 0.02
  11am 27 0.01
  12pm 60 0.01
  1pm 60 0.01
  2pm 60 0.01
  3pm 60 0.01
  4pm 60 0.01
  5pm 60 0.01
  6pm 60 0.01
  7pm 60 0.01
  8pm 60 0.01
  9pm 60 0.01
  10pm 60 0.01
  11pm 60 0.01
Jan 29 12am 60 0.02
  1am 60 0.01
  2am 60 0.01
  3am 60 0.01
  4am 60 0.01
  5am 62 0.01
  6am 60 0.01
  7am 60 0.02
  8am 60 0.02
  9am 55 0.01
  10am 60 0.01
  11am 37 0.01
  12pm 60 0.01
  1pm 60 0.01
  2pm 60 0.01
  3pm 64 0.01
  4pm 56 0.03
  5pm 60 0.01
  6pm 60 0.01
  7pm 60 0.01
  8pm 60 0.01
  9pm 60 0.01
  10pm 60 0.01
  11pm 60 0.01
Jan 30 12am 60 0.01
  1am 60 0.01
  2am 60 0.01
  3am 60 0.01
  4am 60 0.01
  5am 62 0.01
  6am 55 0.01
  7am 60 0.02
  8am 60 0.01
  9am 60 0.01
  10am 52 0.01
  11am 60 0.05
  12pm 60 0.01
  1pm 60 0.01
  2pm 57 0.02
37.1s
select id from ruddersysevents limit 0;
16 0.00
5
Day Time Count Av. Duration
Jan 28 11am 1 0.00
Jan 29 11am 1 0.00
  4pm 1 0.00
Jan 30 10am 1 0.01
  2pm 1 0.01
0.0s
Select "rudderproperties3"."name" as "rudderproperties3_name", "rudderproperties3"."value" as "rudderproperties3_value" From "rudderproperties" "rudderproperties3" Where ("rudderproperties3"."name" = '');
17 0.00
25,100
Day Time Count Av. Duration
Jan 28 6am 275 0.00
  7am 660 0.00
  8am 653 0.00
  9am 576 0.00
  11am 271 0.00
  12pm 648 0.00
  1pm 648 0.00
  2pm 648 0.00
  3pm 648 0.00
  4pm 630 0.00
  5pm 432 0.00
  6pm 432 0.00
  7pm 432 0.00
  8pm 432 0.00
  9pm 432 0.00
  10pm 432 0.00
  11pm 432 0.00
Jan 29 12am 431 0.00
  1am 431 0.00
  2am 431 0.00
  3am 431 0.00
  4am 431 0.00
  5am 431 0.00
  6am 432 0.00
  7am 432 0.00
  8am 432 0.00
  9am 396 0.00
  10am 432 0.00
  11am 252 0.00
  12pm 432 0.00
  1pm 432 0.00
  2pm 432 0.00
  3pm 432 0.00
  4pm 387 0.00
  5pm 432 0.00
  6pm 432 0.00
  7pm 432 0.00
  8pm 432 0.00
  9pm 432 0.00
  10pm 432 0.00
  11pm 432 0.00
Jan 30 12am 431 0.00
  1am 431 0.00
  2am 431 0.00
  3am 431 0.00
  4am 431 0.00
  5am 431 0.00
  6am 396 0.00
  7am 432 0.00
  8am 432 0.00
  9am 432 0.00
  10am 360 0.00
  11am 420 0.01
  12pm 432 0.01
  1pm 432 0.00
  2pm 396 0.00
35.9s
insert into RudderSysEvents (executionDate, nodeId, ruleId, directiveId, serial, Component, KeyValue, executionTimeStamp, eventType, msg, Policy) values ('','', '' , '', '', '', '', '', '', '', '' );
18 0.00
165,208
Day Time Count Av. Duration
Jan 28 6am 1,424 0.00
  7am 3,098 0.00
  8am 3,133 0.00
  9am 2,615 0.00
  11am 1,345 0.00
  12pm 3,172 0.00
  1pm 3,174 0.00
  2pm 3,178 0.00
  3pm 3,176 0.00
  4pm 3,150 0.00
  5pm 3,024 0.00
  6pm 3,042 0.00
  7pm 3,044 0.00
  8pm 3,032 0.00
  9pm 3,050 0.00
  10pm 3,048 0.00
  11pm 3,045 0.00
Jan 29 12am 3,075 0.00
  1am 3,028 0.00
  2am 3,046 0.00
  3am 3,056 0.00
  4am 3,054 0.00
  5am 3,046 0.00
  6am 3,062 0.00
  7am 3,066 0.00
  8am 3,060 0.00
  9am 3,042 0.00
  10am 2,846 0.00
  11am 1,748 0.00
  12pm 3,038 0.00
  1pm 3,054 0.00
  2pm 3,046 0.00
  3pm 3,056 0.00
  4pm 2,808 0.00
  5pm 3,043 0.00
  6pm 3,036 0.00
  7pm 3,034 0.00
  8pm 3,042 0.00
  9pm 3,038 0.00
  10pm 3,032 0.00
  11pm 3,050 0.00
Jan 30 12am 3,043 0.00
  1am 3,050 0.00
  2am 3,046 0.00
  3am 3,044 0.00
  4am 3,062 0.00
  5am 3,056 0.00
  6am 3,034 0.00
  7am 3,050 0.00
  8am 3,064 0.00
  9am 3,028 0.00
  10am 2,540 0.00
  11am 3,036 0.00
  12pm 3,285 0.00
  1pm 3,040 0.00
  2pm 2,674 0.00
3m2s
SELECT tables.table_name FROM information_schema.tables WHERE lower(table_name) = '';
19 0.00
1
Day Time Count Av. Duration
Jan 28 9am 1 0.00
0.0s
SELECT tables.table_name FROM information_schema.tables WHERE lower(table_name) = 'eventlog'2014-01-28 09:51:00 CET [2401]: [348049-1] user=rudder,db=rudderJan 28 11:33:01 rudder kernel: imklog 5.8.11, log source = /proc/kmsg started.;
20 0.00
750
Day Time Count Av. Duration
Jan 28 6am 10 0.01
  7am 24 0.00
  8am 24 0.00
  9am 21 0.00
  11am 11 0.01
  12pm 24 0.00
  1pm 24 0.00
  2pm 24 0.00
  3pm 24 0.00
  4pm 23 0.00
  5pm 12 0.00
  6pm 12 0.00
  7pm 12 0.00
  8pm 12 0.00
  9pm 12 0.00
  10pm 12 0.00
  11pm 12 0.00
Jan 29 12am 12 0.00
  1am 12 0.00
  2am 12 0.00
  3am 12 0.00
  4am 12 0.00
  5am 12 0.00
  6am 12 0.00
  7am 12 0.00
  8am 12 0.00
  9am 11 0.00
  10am 12 0.00
  11am 7 0.00
  12pm 12 0.00
  1pm 12 0.00
  2pm 12 0.00
  3pm 12 0.00
  4pm 11 0.00
  5pm 12 0.00
  6pm 12 0.00
  7pm 12 0.00
  8pm 12 0.00
  9pm 12 0.00
  10pm 12 0.00
  11pm 12 0.00
Jan 30 12am 12 0.00
  1am 12 0.00
  2am 12 0.00
  3am 12 0.00
  4am 12 0.00
  5am 12 0.00
  6am 11 0.00
  7am 12 0.00
  8am 12 0.00
  9am 12 0.00
  10am 10 0.01
  11am 12 0.00
  12pm 12 0.00
  1pm 12 0.01
  2pm 11 0.01
0.7s
insert into "reportsexecution" ("date", "complete", "nodeid") values ('','','');
Report generated by pgFouine 1.2. pgFouine is free software.
Table of contents