Times Reported Time consuming queries #1

x Hide

[ User: developer - Total duration: 5s568ms - Times executed: 9549 ]

x Hide

[ Application: [unknown] - Total duration: 5s568ms - Times executed: 9549 ]

x Hide

SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(adbin, adrelid) AS adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = ( SELECT oid FROM pg_catalog.pg_class WHERE relname = 'konfigsystem_k' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;

Date: 2022-03-26 00:11:09
Duration: 12ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(adbin, adrelid) AS adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = ( SELECT oid FROM pg_catalog.pg_class WHERE relname = 'kelompokmenu_k' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;

Date: 2022-03-26 03:02:07
Duration: 12ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(adbin, adrelid) AS adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = ( SELECT oid FROM pg_catalog.pg_class WHERE relname = 'konfigsystem_k' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;

Date: 2022-03-26 01:00:01
Duration: 12ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: developer - Total duration: 2s719ms - Times executed: 9549 ]

x Hide

[ Application: [unknown] - Total duration: 2s719ms - Times executed: 9549 ]

x Hide

SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid = pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p'))) AS sub WHERE relid = ( SELECT oid FROM pg_catalog.pg_class WHERE relname = 'antrian_t' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'));

Date: 2022-03-26 00:53:29
Duration: 4ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid = pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p'))) AS sub WHERE relid = ( SELECT oid FROM pg_catalog.pg_class WHERE relname = 'jabatan_m' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'));

Date: 2022-03-26 01:29:57
Duration: 3ms
Database: db_rsbri_running
User: developer
Application: [unknown]
Bind query: yes

SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid = pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p'))) AS sub WHERE relid = ( SELECT oid FROM pg_catalog.pg_class WHERE relname = 'menumodul_k' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'));

Date: 2022-03-26 03:38:08
Duration: 3ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: developer - Total duration: 2s114ms - Times executed: 973 ]

x Hide

[ Application: [unknown] - Total duration: 2s114ms - Times executed: 973 ]

x Hide

SELECT count(nofitikasi_id) as total FROM notifikasi_r WHERE instalasi_id = 1 AND create_ruangan = 2 AND modul_id = 2 AND (pegawai_id IS NULL OR pegawai_id IN (1028));

Date: 2022-03-26 01:43:49
Duration: 4ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

SELECT count(nofitikasi_id) as total FROM notifikasi_r WHERE instalasi_id = 1 AND create_ruangan = 2 AND modul_id = 2 AND (pegawai_id IS NULL OR pegawai_id IN (1028));

Date: 2022-03-26 02:24:49
Duration: 4ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

SELECT count(nofitikasi_id) as total FROM notifikasi_r WHERE instalasi_id = 24 AND create_ruangan = 226 AND modul_id = 70 AND (pegawai_id IS NULL OR pegawai_id IN (1233));

Date: 2022-03-26 02:04:00
Duration: 3ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: developer - Total duration: 1s156ms - Times executed: 670 ]

x Hide

[ Application: [unknown] - Total duration: 1s156ms - Times executed: 670 ]

x Hide

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE instalasi_id = 1 AND create_ruangan = 2 AND modul_id = 2 AND date(tglnotifikasi) = '2022-03-26' AND (pegawai_id IS NULL OR pegawai_id IN (1028)) order by tglnotifikasi desc limit 20;

Date: 2022-03-26 00:25:49
Duration: 3ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE instalasi_id = 1 AND create_ruangan = 2 AND modul_id = 2 AND date(tglnotifikasi) = '2022-03-26' AND (pegawai_id IS NULL OR pegawai_id IN (1028)) order by tglnotifikasi desc limit 20;

Date: 2022-03-26 00:07:48
Duration: 3ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE instalasi_id = 1 AND create_ruangan = 2 AND modul_id = 2 AND date(tglnotifikasi) = '2022-03-26' AND (pegawai_id IS NULL OR pegawai_id IN (1028)) order by tglnotifikasi desc limit 20;

Date: 2022-03-26 01:52:49
Duration: 3ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #5

x Hide

[ User: developer - Total duration: 956ms - Times executed: 468 ]

x Hide

[ Application: [unknown] - Total duration: 956ms - Times executed: 468 ]

x Hide

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE isread = false AND instalasi_id = 1 AND create_ruangan = 2 AND modul_id = 2 AND date(tglnotifikasi) between '2022-03-26' AND '2022-03-27' AND (pegawai_id IS NULL OR pegawai_id IN (1369)) order by tglnotifikasi desc limit 20;

Date: 2022-03-26 03:43:43
Duration: 5ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE isread = false AND instalasi_id = 1 AND create_ruangan = 2 AND modul_id = 2 AND date(tglnotifikasi) between '2022-03-26' AND '2022-03-27' AND (pegawai_id IS NULL OR pegawai_id IN (1369)) order by tglnotifikasi desc limit 20;

Date: 2022-03-26 01:49:43
Duration: 3ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE isread = false AND instalasi_id = 1 AND create_ruangan = 2 AND modul_id = 2 AND date(tglnotifikasi) between '2022-03-26' AND '2022-03-27' AND (pegawai_id IS NULL OR pegawai_id IN (1028)) order by tglnotifikasi desc limit 20;

Date: 2022-03-26 00:32:49
Duration: 3ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #6

x Hide

[ User: developer - Total duration: 726ms - Times executed: 982 ]

x Hide

[ Application: [unknown] - Total duration: 726ms - Times executed: 982 ]

x Hide

UPDATE "loginpemakai_k" SET "statuslogin" = 't', "ruanganaktifitas" = '272', "crudaktifitas" = 'chat', "waktuterakhiraktifitas" = '2022-03-26 00:13:03' WHERE "loginpemakai_k"."loginpemakai_id" = 675;

Date: 2022-03-26 00:13:03
Duration: 1ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

UPDATE "loginpemakai_k" SET "statuslogin" = 't', "ruanganaktifitas" = '2', "crudaktifitas" = 'chat', "waktuterakhiraktifitas" = '2022-03-26 02:51:49' WHERE "loginpemakai_k"."loginpemakai_id" = 1;

Date: 2022-03-26 02:51:49
Duration: 1ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

UPDATE "loginpemakai_k" SET "statuslogin" = 't', "ruanganaktifitas" = '226', "crudaktifitas" = 'chat', "waktuterakhiraktifitas" = '2022-03-26 01:39:11' WHERE "loginpemakai_k"."loginpemakai_id" = 626;

Date: 2022-03-26 01:39:11
Duration: 1ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #7

x Hide

[ User: developer - Total duration: 449ms - Times executed: 28080 ]

x Hide

[ Application: [unknown] - Total duration: 449ms - Times executed: 28080 ]

x Hide

SELECT DISTINCT t0_st.pk FROM study t0_st, series t1_s WHERE ((t1_s.pps_iuid IS NULL AND t1_s.src_aet = 'FCR-CSL' AND t0_st.updated_time < '2022-03-26 00:01:59.006')) AND t0_st.pk = t1_s.study_fk;

Date: 2022-03-26 00:02:04
Duration: 0ms
Database: pacsdb
User: developer
Application: [unknown]
Bind query: yes

SELECT DISTINCT t0_st.pk FROM study t0_st, series t1_s WHERE ((t1_s.pps_iuid IS NULL AND t1_s.src_aet = 'MODALITY' AND t0_st.updated_time < '2022-03-26 00:00:03.991')) AND t0_st.pk = t1_s.study_fk;

Date: 2022-03-26 00:00:08
Duration: 0ms
Database: pacsdb
User: developer
Application: [unknown]
Bind query: yes

SELECT DISTINCT t0_st.pk FROM study t0_st, series t1_s WHERE ((t1_s.pps_iuid IS NULL AND t1_s.src_aet = 'MOD_AET' AND t0_st.updated_time < '2022-03-26 02:16:04.635')) AND t0_st.pk = t1_s.study_fk;

Date: 2022-03-26 02:16:09
Duration: 0ms
Database: pacsdb
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #8

x Hide

[ User: developer - Total duration: 440ms - Times executed: 2082 ]

x Hide

[ Application: [unknown] - Total duration: 440ms - Times executed: 2082 ]

x Hide

SELECT "t"."menu_id" AS "t0_c0", "t"."kelmenu_id" AS "t0_c1", "t"."modul_id" AS "t0_c2", "t"."menu_nama" AS "t0_c3", "t"."menu_namalainnya" AS "t0_c4", "t"."menu_key" AS "t0_c5", "t"."menu_url" AS "t0_c6", "t"."menu_fungsi" AS "t0_c7", "t"."menu_urutan" AS "t0_c8", "t"."menu_aktif" AS "t0_c9", "t"."menu_icon" AS "t0_c10", "t"."menu_shortcut" AS "t0_c11", "kelompokmenu"."kelmenu_id" AS "t1_c0", "kelompokmenu"."kelmenu_nama" AS "t1_c1", "kelompokmenu"."kelmenu_namalainnya" AS "t1_c2", "kelompokmenu"."kelmenu_key" AS "t1_c3", "kelompokmenu"."kelmenu_url" AS "t1_c4", "kelompokmenu"."kelmenu_urutan" AS "t1_c5", "kelompokmenu"."kelmenu_aktif" AS "t1_c6", "kelompokmenu"."kelmenu_icon" AS "t1_c7", "modulk"."modul_id" AS "t2_c0", "modulk"."kelompokmodul_id" AS "t2_c1", "modulk"."modul_nama" AS "t2_c2", "modulk"."modul_namalainnya" AS "t2_c3", "modulk"."modul_fungsi" AS "t2_c4", "modulk"."tglrevisimodul" AS "t2_c5", "modulk"."tglupdatemodul" AS "t2_c6", "modulk"."url_modul" AS "t2_c7", "modulk"."icon_modul" AS "t2_c8", "modulk"."modul_key" AS "t2_c9", "modulk"."modul_urutan" AS "t2_c10", "modulk"."modul_kategori" AS "t2_c11", "modulk"."imagemodul" AS "t2_c12", "modulk"."modul_aktif" AS "t2_c13" FROM "menumodul_k" "t" LEFT OUTER JOIN "kelompokmenu_k" "kelompokmenu" ON ("t"."kelmenu_id" = "kelompokmenu"."kelmenu_id") LEFT OUTER JOIN "modul_k" "modulk" ON ("t"."modul_id" = "modulk"."modul_id") WHERE ((t.menu_aktif = true) AND (modulk.modul_id = '76')) ORDER BY kelompokmenu.kelmenu_urutan, menu_urutan;

Date: 2022-03-26 02:59:07
Duration: 2ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT "t"."menu_id" AS "t0_c0", "t"."kelmenu_id" AS "t0_c1", "t"."modul_id" AS "t0_c2", "t"."menu_nama" AS "t0_c3", "t"."menu_namalainnya" AS "t0_c4", "t"."menu_key" AS "t0_c5", "t"."menu_url" AS "t0_c6", "t"."menu_fungsi" AS "t0_c7", "t"."menu_urutan" AS "t0_c8", "t"."menu_aktif" AS "t0_c9", "t"."menu_icon" AS "t0_c10", "t"."menu_shortcut" AS "t0_c11", "kelompokmenu"."kelmenu_id" AS "t1_c0", "kelompokmenu"."kelmenu_nama" AS "t1_c1", "kelompokmenu"."kelmenu_namalainnya" AS "t1_c2", "kelompokmenu"."kelmenu_key" AS "t1_c3", "kelompokmenu"."kelmenu_url" AS "t1_c4", "kelompokmenu"."kelmenu_urutan" AS "t1_c5", "kelompokmenu"."kelmenu_aktif" AS "t1_c6", "kelompokmenu"."kelmenu_icon" AS "t1_c7", "modulk"."modul_id" AS "t2_c0", "modulk"."kelompokmodul_id" AS "t2_c1", "modulk"."modul_nama" AS "t2_c2", "modulk"."modul_namalainnya" AS "t2_c3", "modulk"."modul_fungsi" AS "t2_c4", "modulk"."tglrevisimodul" AS "t2_c5", "modulk"."tglupdatemodul" AS "t2_c6", "modulk"."url_modul" AS "t2_c7", "modulk"."icon_modul" AS "t2_c8", "modulk"."modul_key" AS "t2_c9", "modulk"."modul_urutan" AS "t2_c10", "modulk"."modul_kategori" AS "t2_c11", "modulk"."imagemodul" AS "t2_c12", "modulk"."modul_aktif" AS "t2_c13" FROM "menumodul_k" "t" LEFT OUTER JOIN "kelompokmenu_k" "kelompokmenu" ON ("t"."kelmenu_id" = "kelompokmenu"."kelmenu_id") LEFT OUTER JOIN "modul_k" "modulk" ON ("t"."modul_id" = "modulk"."modul_id") WHERE ((t.menu_aktif = true) AND (modulk.modul_id = '76')) ORDER BY kelompokmenu.kelmenu_urutan, menu_urutan;

Date: 2022-03-26 01:12:06
Duration: 2ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT "t"."menu_id" AS "t0_c0", "t"."kelmenu_id" AS "t0_c1", "t"."modul_id" AS "t0_c2", "t"."menu_nama" AS "t0_c3", "t"."menu_namalainnya" AS "t0_c4", "t"."menu_key" AS "t0_c5", "t"."menu_url" AS "t0_c6", "t"."menu_fungsi" AS "t0_c7", "t"."menu_urutan" AS "t0_c8", "t"."menu_aktif" AS "t0_c9", "t"."menu_icon" AS "t0_c10", "t"."menu_shortcut" AS "t0_c11", "kelompokmenu"."kelmenu_id" AS "t1_c0", "kelompokmenu"."kelmenu_nama" AS "t1_c1", "kelompokmenu"."kelmenu_namalainnya" AS "t1_c2", "kelompokmenu"."kelmenu_key" AS "t1_c3", "kelompokmenu"."kelmenu_url" AS "t1_c4", "kelompokmenu"."kelmenu_urutan" AS "t1_c5", "kelompokmenu"."kelmenu_aktif" AS "t1_c6", "kelompokmenu"."kelmenu_icon" AS "t1_c7", "modulk"."modul_id" AS "t2_c0", "modulk"."kelompokmodul_id" AS "t2_c1", "modulk"."modul_nama" AS "t2_c2", "modulk"."modul_namalainnya" AS "t2_c3", "modulk"."modul_fungsi" AS "t2_c4", "modulk"."tglrevisimodul" AS "t2_c5", "modulk"."tglupdatemodul" AS "t2_c6", "modulk"."url_modul" AS "t2_c7", "modulk"."icon_modul" AS "t2_c8", "modulk"."modul_key" AS "t2_c9", "modulk"."modul_urutan" AS "t2_c10", "modulk"."modul_kategori" AS "t2_c11", "modulk"."imagemodul" AS "t2_c12", "modulk"."modul_aktif" AS "t2_c13" FROM "menumodul_k" "t" LEFT OUTER JOIN "kelompokmenu_k" "kelompokmenu" ON ("t"."kelmenu_id" = "kelompokmenu"."kelmenu_id") LEFT OUTER JOIN "modul_k" "modulk" ON ("t"."modul_id" = "modulk"."modul_id") WHERE ((t.menu_aktif = true) AND (modulk.modul_id = '76')) ORDER BY kelompokmenu.kelmenu_urutan, menu_urutan;

Date: 2022-03-26 02:00:07
Duration: 2ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #9

x Hide

[ User: developer - Total duration: 372ms - Times executed: 4067 ]

x Hide

[ Application: [unknown] - Total duration: 372ms - Times executed: 4067 ]

x Hide

SET NAMES 'utf8';

Date: 2022-03-26 02:03:07
Duration: 5ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]

SET NAMES 'utf8';

Date: 2022-03-26 02:53:07
Duration: 1ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]

SET NAMES 'utf8';

Date: 2022-03-26 01:35:06
Duration: 0ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]

x Hide

Times Reported Time consuming queries #10

x Hide

[ User: developer - Total duration: 350ms - Times executed: 303 ]

x Hide

[ Application: [unknown] - Total duration: 350ms - Times executed: 303 ]

x Hide

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE isread = false AND instalasi_id = 24 AND modul_id = 70 AND date(tglnotifikasi) between '2022-03-26' AND '2022-03-27' AND (pegawai_id IS NULL OR pegawai_id IN (1233)) order by tglnotifikasi desc limit 20;

Date: 2022-03-26 02:03:14
Duration: 1ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE isread = false AND instalasi_id = 24 AND modul_id = 70 AND date(tglnotifikasi) between '2022-03-26' AND '2022-03-27' AND (pegawai_id IS NULL OR pegawai_id IN (1233)) order by tglnotifikasi desc limit 20;

Date: 2022-03-26 02:08:55
Duration: 1ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE isread = false AND instalasi_id = 24 AND modul_id = 70 AND date(tglnotifikasi) between '2022-03-26' AND '2022-03-27' AND (pegawai_id IS NULL OR pegawai_id IN (1233)) order by tglnotifikasi desc limit 20;

Date: 2022-03-26 02:13:09
Duration: 1ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #11

x Hide

[ User: developer - Total duration: 326ms - Times executed: 303 ]

x Hide

[ Application: [unknown] - Total duration: 326ms - Times executed: 303 ]

x Hide

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE instalasi_id = 24 AND modul_id = 70 AND date(tglnotifikasi) between '2022-03-26' AND '2022-03-27' AND (pegawai_id IS NULL OR pegawai_id IN (1233)) order by tglnotifikasi desc limit 20;

Date: 2022-03-26 01:59:44
Duration: 3ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE instalasi_id = 24 AND modul_id = 70 AND date(tglnotifikasi) between '2022-03-26' AND '2022-03-27' AND (pegawai_id IS NULL OR pegawai_id IN (1233)) order by tglnotifikasi desc limit 20;

Date: 2022-03-26 02:11:15
Duration: 2ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE instalasi_id = 24 AND modul_id = 70 AND date(tglnotifikasi) between '2022-03-26' AND '2022-03-27' AND (pegawai_id IS NULL OR pegawai_id IN (1233)) order by tglnotifikasi desc limit 20;

Date: 2022-03-26 02:08:12
Duration: 1ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #12

x Hide

[ User: developer - Total duration: 319ms - Times executed: 9545 ]

x Hide

[ Application: [unknown] - Total duration: 319ms - Times executed: 9545 ]

x Hide

SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid = ( SELECT oid FROM pg_catalog.pg_class WHERE relname = 'antrian_t' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) AND attnum IN (1);

Date: 2022-03-26 01:54:07
Duration: 5ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid = ( SELECT oid FROM pg_catalog.pg_class WHERE relname = 'loginpemakai_k' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) AND attnum IN (1);

Date: 2022-03-26 00:15:29
Duration: 2ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid = ( SELECT oid FROM pg_catalog.pg_class WHERE relname = 'modul_k' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) AND attnum IN (1);

Date: 2022-03-26 02:00:07
Duration: 1ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #13

x Hide

[ User: developer - Total duration: 253ms - Times executed: 28782 ]

x Hide

[ Application: [unknown] - Total duration: 253ms - Times executed: 28782 ]

x Hide

COMMIT;

Date: 2022-03-26 00:09:29
Duration: 1ms
Database: pacsdb
User: developer
Application: [unknown]
Bind query: yes

COMMIT;

Date: 2022-03-26 03:35:30
Duration: 0ms
Database: pacsdb
User: developer
Application: [unknown]
Bind query: yes

COMMIT;

Date: 2022-03-26 01:46:54
Duration: 0ms
Database: pacsdb
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #14

x Hide

[ User: developer - Total duration: 242ms - Times executed: 202 ]

x Hide

[ Application: [unknown] - Total duration: 242ms - Times executed: 202 ]

x Hide

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE isread = false AND instalasi_id = 8 AND create_ruangan = 272 AND modul_id = 78 AND date(tglnotifikasi) = '2022-03-26' AND (pegawai_id IS NULL OR pegawai_id IN (1233)) order by tglnotifikasi desc limit 20;

Date: 2022-03-26 00:19:12
Duration: 3ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE isread = false AND instalasi_id = 8 AND create_ruangan = 272 AND modul_id = 78 AND date(tglnotifikasi) = '2022-03-26' AND (pegawai_id IS NULL OR pegawai_id IN (1233)) order by tglnotifikasi desc limit 20;

Date: 2022-03-26 00:15:06
Duration: 2ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE isread = false AND instalasi_id = 8 AND create_ruangan = 272 AND modul_id = 78 AND date(tglnotifikasi) = '2022-03-26' AND (pegawai_id IS NULL OR pegawai_id IN (1233)) order by tglnotifikasi desc limit 20;

Date: 2022-03-26 00:16:06
Duration: 1ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #15

x Hide

[ User: developer - Total duration: 162ms - Times executed: 2084 ]

x Hide

[ Application: [unknown] - Total duration: 162ms - Times executed: 2084 ]

x Hide

SELECT * FROM "kelompokmenu_k" "t" WHERE kelmenu_aktif = 't' ORDER BY kelmenu_urutan;

Date: 2022-03-26 01:53:06
Duration: 3ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT * FROM "kelompokmenu_k" "t" WHERE kelmenu_aktif = 't' ORDER BY kelmenu_urutan;

Date: 2022-03-26 03:43:07
Duration: 1ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT * FROM "kelompokmenu_k" "t" WHERE kelmenu_aktif = 't' ORDER BY kelmenu_urutan;

Date: 2022-03-26 02:00:06
Duration: 0ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #16

x Hide

[ User: developer - Total duration: 105ms - Times executed: 2073 ]

x Hide

[ Application: [unknown] - Total duration: 105ms - Times executed: 2073 ]

x Hide

SELECT * FROM "antrian_t" "t" WHERE (DATE(tglantrian) = '2022-03-26') AND (modelantrian_id = 1) ORDER BY modelantrian_id DESC, noantrian DESC;

Date: 2022-03-26 01:36:06
Duration: 1ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT * FROM "antrian_t" "t" WHERE (DATE(tglantrian) = '2022-03-26') AND (modelantrian_id = 1) ORDER BY modelantrian_id DESC, noantrian DESC;

Date: 2022-03-26 01:01:06
Duration: 0ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT * FROM "antrian_t" "t" WHERE (DATE(tglantrian) = '2022-03-26') AND (modelantrian_id = 2) ORDER BY modelantrian_id DESC, noantrian DESC;

Date: 2022-03-26 02:39:07
Duration: 0ms
Database: db_rsih_simulasi
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #17