Tememons Dashboard, PostgreSQL

Tememons Dashboard

BEGIN TRANSACTION;

/* Create a table called NAMES */
CREATE TABLE uni_t24(
   batchname           TEXT    NOT NULL,
   stage            TEXT     NOT NULL,
   short_stage        TEXT  NOT NULL,
   status         TEXT  NOT NULL,
   batchdate	  TEXT  NOT NULL,
   startdate TIMESTAMP ,
   enddate TIMESTAMP ,
    elapsedtime int 
);

insert into uni_t24 values ( 'SGP/CARD.CHEQUE.EOD-CHEQUE.CHARGE.EOD.POST', 'A700-Application', 'Application', '0', '20150423',  '20150423 21:41:45',  '20150423 21:41:45', '1');
insert into uni_t24 values ( 'SGP/DX.END.OF.DAY-DX.COB.MARKET.PRICES', 'A100-Application', 'Application', '0', '20150423',  '20150423 21:39:07',  '20150423 21:39:09', '2');
insert into uni_t24 values ( 'SGP/EOD.BACKVALUE-BV.GET.TRANS', 'R045-Reporting', 'Reporting', '0', '20150423',  '20150423 22:12:35',  '20150423 22:12:36', '1');
insert into uni_t24 values ( 'SGP/EOD.BACKVALUE-BV.RELEASE.LOCKED.SEC.PRICE', 'R045-Reporting', 'Reporting', '0', '20150423',  '20150423 22:12:37',  '20150423 22:12:38', '2');
insert into uni_t24 values ( 'SGP/EOD.BACKVALUE-EOD.SECURITY.MASTER.HIST', 'R045-Reporting', 'Reporting', '0', '20150423',  '20150423 22:12:30',  '20150423 22:12:34', '4');
insert into uni_t24 values ( 'SGP/EOD.BENCHMARK.PERF-UPD.CALC.BM.PERF', 'S022-System-Wide', 'System-Wide', '0', '20150423',  '20150423 21:58:47',  '20150423 21:58:47', '1');
insert into uni_t24 values ( 'SGP/EOD.DATA.CAPTURE-DATA.CAPTURE.EOD', 'A100-Application', 'Application', '0', '20150423',  '20150423 21:39:05',  '20150423 21:39:06', '1');
insert into uni_t24 values ( 'SGP/FILE.TIDY.UP-EB.PRIME.FILES', 'D003-Start-of-Day', 'Start-of-Day', '0', '20150423',  '20150423 22:20:47',  '20150423 22:20:47', '1');
insert into uni_t24 values ( 'SGP/FIN.LIMITS.EOD2-UNUTILISED.LIMIT.SWEEP', 'S011-System-Wide', 'System-Wide', '0', '20150423',  '20150423 21:44:20',  '20150423 21:44:20', '1');
insert into uni_t24 values ( 'SGP/FIN.LIMITS.EOD-COLLATERAL.LIMIT.EOD', 'S021-System-Wide', 'System-Wide', '0', '20150423',  '20150423 21:58:42',  '20150423 21:58:43', '1');
insert into uni_t24 values ( 'SGP/FT.END.OF.DAY-FT.PROCESS.BULK.PAYMENT.PRE', 'A100-Application', 'Application', '0', '20150423',  '20150423 21:39:09',  '20150423 21:39:09', '1');
insert into uni_t24 values ( 'SGP/FT.START.OF.DAY-FT.INWD.BULK.STO.PAY', 'D100-Start-of-Day', 'Start-of-Day', '0', '20150423',  '20150423 06:58:20',  '20150423 06:58:20', '1');
insert into uni_t24 values ( 'SGP/FT.START.OF.DAY-FT.STO.PAY', 'D100-Start-of-Day', 'Start-of-Day', '0', '20150423',  '20150423 06:58:19',  '20150423 06:58:19', '1');
insert into uni_t24 values ( 'SGP/FX.END.OF.DAY-FX.EOD.AMORTISATION', 'A100-Application', 'Application', '0', '20150423',  '20150423 21:39:10',  '20150423 21:39:10', '1');
insert into uni_t24 values ( 'SGP/FX.END.OF.DAY-FX.NE.PROCESS', 'A100-Application', 'Application', '0', '20150423',  '20150423 21:39:11',  '20150423 21:39:11', '1');
insert into uni_t24 values ( 'SGP/LC.END.OF.DAY-LC.FILES.TIDY.UP', 'A100-Application', 'Application', '0', '20150423',  '20150423 21:39:13',  '20150423 21:39:13', '1');
insert into uni_t24 values ( 'SGP/LC.END.OF.DAY-LC.MATURE', 'A100-Application', 'Application', '0', '20150423',  '20150423 21:39:12',  '20150423 21:39:12', '1');
insert into uni_t24 values ( 'SGP/LD.END.OF.DAY-LD.END.OF.DAY.8', 'A100-Application', 'Application', '0', '20150423',  '20150423 21:39:14',  '20150423 21:39:14', '1');
insert into uni_t24 values ( 'SGP/LD.START.OF.DAY-LD.END.OF.DAY.8', 'D010-Start-of-Day', 'Start-of-Day', '0', '20150423',  '20150423 22:25:12',  '20150423 22:25:12', '1');
insert into uni_t24 values ( 'SGP/MD.START.OF.DAY-MD.SOD.ACCRUAL', 'D100-Start-of-Day', 'Start-of-Day', '0', '20150423',  '20150423 06:58:24',  '20150423 06:58:24', '1');
insert into uni_t24 values ( 'SGP/MF.SYS.END.OF.DAY-MF.UPD.TOTAL.UNITS.POST', 'S019-System-Wide', 'System-Wide', '0', '20150423',  '20150423 21:57:23',  '20150423 21:57:24', '1');
insert into uni_t24 values ( 'SGP/MM.END.OF.DAY-MM.EOD.ONLINE.MATURITY', 'A201-Application', 'Application', '0', '20150423',  '20150423 21:41:29',  '20150423 21:41:29', '1');
insert into uni_t24 values ( 'SGP/MM.START.OF.DAY-MM.START.OF.DAY.2', 'D201-Start-of-Day', 'Start-of-Day', '0', '20150423',  '20150423 12:15:02',  '20150423 12:15:02', '1');
insert into uni_t24 values ( 'SGP/PM.BATCH.START-PM.SC.ONITE.POS', 'D920-Start-of-Day', 'Start-of-Day', '0', '20150423',  '20150423 12:19:18',  '20150423 12:19:18', '1');
insert into uni_t24 values ( 'SGP/RE.BUILD.SLC-RE.UPDT.STAT.LINE.CONT', 'R001-Reporting', 'Reporting', '0', '20150423',  '20150423 22:09:42',  '20150423 22:09:53', '11');
insert into uni_t24 values ( 'SGP/RE.BUILD.SLC.WORK-RE.BUILD.SLC.WORK', 'A006-Application', 'Application', '0', '20150423',  '20150423 21:29:15',  '20150423 21:29:17', '3');
insert into uni_t24 values ( 'SGP/REPORT.PRINT.APPLICATION-EB.EOD.REPORT.PRINT', 'A999-Application', 'Application', '0', '20150423',  '20150423 21:43:16',  '20150423 21:43:18', '2');
insert into uni_t24 values ( 'SGP/REPORT.PRINT.REPORTING-EB.EOD.REPORT.PRINT', 'R999-Reporting', 'Reporting', '0', '20150423',  '20150423 22:20:02',  '20150423 22:20:12', '10');
insert into uni_t24 values ( 'SGP/REPORT.PRINT.SOD-EB.EOD.REPORT.PRINT', 'D999-Start-of-Day', 'Start-of-Day', '0', '20150423',  '20150423 12:19:36',  '20150423 12:19:37', '1');
insert into uni_t24 values ( 'SGP/REPORT.PRINT.SYSTEM-EB.EOD.REPORT.PRINT', 'S999-System-Wide', 'System-Wide', '0', '20150423',  '20150423 22:08:05',  '20150423 22:08:06', '1');
insert into uni_t24 values ( 'SGP/RE.UPDATE.SLC.LINE.BAL-RE.UPDATE.LINE.BAL.MVMT', 'R799-Reporting', 'Reporting', '0', '20150423',  '20150423 22:15:51',  '20150423 22:15:58', '8');
insert into uni_t24 values ( 'SGP/RP.END.OF.DAY-RP.EOD.DETERMINE.ACTIVITY', 'A100-Application', 'Application', '0', '20150423',  '20150423 21:39:17',  '20150423 21:39:17', '1');
insert into uni_t24 values ( 'SGP/SC.BATCH.REP-SC.BATCH.DATE.CYCLE', 'R040-Reporting', 'Reporting', '0', '20150423',  '20150423 22:10:17',  '20150423 22:10:18', '1');
insert into uni_t24 values ( 'SGP/SC.BATCH.START-SC.ACCR.DATE.UPDATE', 'D910-Start-of-Day', 'Start-of-Day', '0', '20150423',  '20150423 12:19:04',  '20150423 12:19:04', '1');
insert into uni_t24 values ( 'SGP/SC.BATCH.START-SC.UPDATE.SM.PRICE', 'D910-Start-of-Day', 'Start-of-Day', '0', '20150423',  '20150423 12:19:04',  '20150423 12:19:05', '1');
insert into uni_t24 values ( 'SGP/SC.ONLINE-SC.SOD.APPLY.DEF.INSTR', 'O006-Online', 'Online', '0', '20150423',  '20150423 12:20:21',  '20150423 12:20:22', '2');
insert into uni_t24 values ( 'SGP/SC.VAL.EXTRACT-WRITE.SC.VAL.EXTRACT', 'S020-System-Wide', 'System-Wide', '0', '20150423',  '20150423 21:57:54',  '20150423 21:57:56', '2');
insert into uni_t24 values ( 'SGP/SC.VAL.EXTRACT-WRITE.SC.VAL.PEND', 'S020-System-Wide', 'System-Wide', '0', '20150423',  '20150423 21:57:57',  '20150423 21:57:57', '1');
insert into uni_t24 values ( 'SGP/SEAT.SYSTEM.CHECKS-BALANCE.REGISTER', 'D005-Start-of-Day', 'Start-of-Day', '0', '20150423',  '20150423 22:25:01',  '20150423 22:25:02', '1');
insert into uni_t24 values ( 'SGP/SL.START.OF.DAY-SL.SOD.PROCESS.SCHEDULES', 'D101-Start-of-Day', 'Start-of-Day', '0', '20150423', '20150423 06:58:40', '20150423 06:58:40', '1');
insert into uni_t24 values ( 'SGP/SYSTEM.END.OF.DAY3-ICA.BLD.ACCT.ACT.CORR', 'S012-System-Wide', 'System-Wide', '0', '20150423', '20150423 21:45:55', '20150423 21:45:55', '1');
insert into uni_t24 values ( 'SGP/UNAUTH.PROCESSING-UNAUTH.PROCESSING', 'A001-Application', 'Application', '0', '20150423', '20150423 21:28:25', '20150423 21:28:25', '3');
insert into uni_t24 values ( 'SGP/RE.BUILD.SLC.WORK-RE.BUILD.SLC.WORK', 'A006-Application', 'Application', '0', '20150422',  '20150422 21:29:15',  '20150422 21:29:17', '3');
insert into uni_t24 values ( 'SGP/REPORT.PRINT.APPLICATION-EB.EOD.REPORT.PRINT', 'A999-Application', 'Application', '0', '20150422',  '20150422 21:43:16',  '20150422 21:43:18', '2');
insert into uni_t24 values ( 'SGP/REPORT.PRINT.REPORTING-EB.EOD.REPORT.PRINT', 'R999-Reporting', 'Reporting', '0', '20150422',  '20150422 22:20:02',  '20150422 22:20:12', '10');
insert into uni_t24 values ( 'SGP/REPORT.PRINT.SOD-EB.EOD.REPORT.PRINT', 'D999-Start-of-Day', 'Start-of-Day', '0', '20150422',  '20150422 12:19:36',  '20150422 12:19:37', '1');
insert into uni_t24 values ( 'SGP/REPORT.PRINT.SYSTEM-EB.EOD.REPORT.PRINT', 'S999-System-Wide', 'System-Wide', '0', '20150422',  '20150422 22:08:05',  '20150422 22:08:06', '1');
insert into uni_t24 values ( 'SGP/RE.UPDATE.SLC.LINE.BAL-RE.UPDATE.LINE.BAL.MVMT', 'R799-Reporting', 'Reporting', '0', '20150422',  '20150422 22:15:51',  '20150422 22:15:58', '8');
insert into uni_t24 values ( 'SGP/RP.END.OF.DAY-RP.EOD.DETERMINE.ACTIVITY', 'A100-Application', 'Application', '0', '20150422',  '20150422 21:39:17',  '20150422 21:39:17', '1');
insert into uni_t24 values ( 'SGP/SC.BATCH.REP-SC.BATCH.DATE.CYCLE', 'R040-Reporting', 'Reporting', '0', '20150422',  '20150422 22:10:17',  '20150422 22:10:18', '1');
insert into uni_t24 values ( 'SGP/SC.BATCH.START-SC.ACCR.DATE.UPDATE', 'D910-Start-of-Day', 'Start-of-Day', '0', '20150422',  '20150422 12:19:04',  '20150422 12:19:04', '1');
insert into uni_t24 values ( 'SGP/SC.BATCH.START-SC.UPDATE.SM.PRICE', 'D910-Start-of-Day', 'Start-of-Day', '0', '20150422',  '20150422 12:19:04',  '20150422 12:19:05', '1');
insert into uni_t24 values ( 'SGP/SC.ONLINE-SC.SOD.APPLY.DEF.INSTR', 'O006-Online', 'Online', '0', '20150422',  '20150422 12:20:21',  '20150422 12:20:22', '2');
insert into uni_t24 values ( 'SGP/SC.VAL.EXTRACT-WRITE.SC.VAL.EXTRACT', 'S020-System-Wide', 'System-Wide', '0', '20150422',  '20150422 21:57:54',  '20150422 21:57:56', '2');
insert into uni_t24 values ( 'SGP/SC.VAL.EXTRACT-WRITE.SC.VAL.PEND', 'S020-System-Wide', 'System-Wide', '0', '20150422',  '20150422 21:57:57',  '20150422 21:57:57', '1');
insert into uni_t24 values ( 'SGP/SEAT.SYSTEM.CHECKS-BALANCE.REGISTER', 'D005-Start-of-Day', 'Start-of-Day', '0', '20150422',  '20150422 22:25:01',  '20150422 22:25:02', '1');
insert into uni_t24 values ( 'SGP/SL.START.OF.DAY-SL.SOD.PROCESS.SCHEDULES', 'D101-Start-of-Day', 'Start-of-Day', '0', '20150422', '20150422 06:58:40', '20150422 06:58:40', '1');
insert into uni_t24 values ( 'SGP/SYSTEM.END.OF.DAY3-ICA.BLD.ACCT.ACT.CORR', 'S012-System-Wide', 'System-Wide', '0', '20150422', '20150422 21:45:55', '20150422 21:45:55', '1');
insert into uni_t24 values ( 'SGP/UNAUTH.PROCESSING-UNAUTH.PROCESSING', 'A001-Application', 'Application', '0', '20150422', '20150422 21:28:25', '20150422 21:28:25', '3');

select count(batchname),short_stage, ROUND(avg(elapsedtime)) as average_time from uni_t24 where batchdate between '20150422' and '20150423' group by short_stage;


run \| edit \| history \| help	0