Times Reported Time consuming queries #1

x Hide

[ User: developer - Total duration: 2m3s - Times executed: 11181 ]

x Hide

[ Application: pgAdmin 4 - DB:postgres - Total duration: 2m3s - Times executed: 11181 ]

x Hide

SELECT ( SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Returned";

Date: 2022-03-05 00:00:10
Duration: 14ms
Database: postgres
User: developer
Application: pgAdmin 4 - DB:postgres

SELECT ( SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Returned";

Date: 2022-03-05 01:27:56
Duration: 14ms
Database: postgres
User: developer
Application: pgAdmin 4 - DB:postgres

SELECT ( SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Returned";

Date: 2022-03-05 00:08:26
Duration: 12ms
Database: postgres
User: developer
Application: pgAdmin 4 - DB:postgres

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: developer - Total duration: 1s690ms - Times executed: 641 ]

x Hide

[ Application: [unknown] - Total duration: 1s690ms - Times executed: 641 ]

x Hide

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

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

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

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

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

Date: 2022-03-05 00:04:28
Duration: 14ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: developer - Total duration: 630ms - Times executed: 224 ]

x Hide

[ Application: [unknown] - Total duration: 630ms - Times executed: 224 ]

x Hide

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

Date: 2022-03-05 00:00:28
Duration: 14ms
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 = 2 AND create_ruangan = 452 AND modul_id = 5 AND date(tglnotifikasi) = '2022-03-05' AND (pegawai_id IS NULL OR pegawai_id IN (1028)) order by tglnotifikasi desc limit 20;

Date: 2022-03-05 00:04:28
Duration: 13ms
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 = 2 AND create_ruangan = 452 AND modul_id = 5 AND date(tglnotifikasi) = '2022-03-05' AND (pegawai_id IS NULL OR pegawai_id IN (1028)) order by tglnotifikasi desc limit 20;

Date: 2022-03-05 00:17:28
Duration: 12ms
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: 628ms - Times executed: 692 ]

x Hide

[ Application: [unknown] - Total duration: 628ms - Times executed: 692 ]

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 = 'loginpemakai_k' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;

Date: 2022-03-05 00:24:38
Duration: 2ms
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 = 'loginpemakai_k' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;

Date: 2022-03-05 00:19:25
Duration: 1ms
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 = 'loginpemakai_k' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;

Date: 2022-03-05 00:21:44
Duration: 1ms
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: 517ms - Times executed: 417 ]

x Hide

[ Application: [unknown] - Total duration: 517ms - Times executed: 417 ]

x Hide

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

Date: 2022-03-05 00:18:10
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 = 10 AND modul_id = 15 AND date(tglnotifikasi) between '2022-03-05' AND '2022-03-06' AND (pegawai_id IS NULL OR pegawai_id IN (1028)) order by tglnotifikasi desc limit 20;

Date: 2022-03-05 00:18:01
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 = 10 AND modul_id = 15 AND date(tglnotifikasi) between '2022-03-05' AND '2022-03-06' AND (pegawai_id IS NULL OR pegawai_id IN (1028)) order by tglnotifikasi desc limit 20;

Date: 2022-03-05 00:18:28
Duration: 2ms
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: 496ms - Times executed: 641 ]

x Hide

[ Application: [unknown] - Total duration: 496ms - Times executed: 641 ]

x Hide

UPDATE "loginpemakai_k" SET "statuslogin" = 't', "ruanganaktifitas" = '62', "crudaktifitas" = 'chat', "waktuterakhiraktifitas" = '2022-03-05 00:16:10' WHERE "loginpemakai_k"."loginpemakai_id" = 1;

Date: 2022-03-05 00:16:10
Duration: 3ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

UPDATE "loginpemakai_k" SET "statuslogin" = 't', "ruanganaktifitas" = '452', "crudaktifitas" = 'chat', "waktuterakhiraktifitas" = '2022-03-05 00:00:28' WHERE "loginpemakai_k"."loginpemakai_id" = 1;

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

UPDATE "loginpemakai_k" SET "statuslogin" = 't', "ruanganaktifitas" = '62', "crudaktifitas" = 'chat', "waktuterakhiraktifitas" = '2022-03-05 00:22:29' WHERE "loginpemakai_k"."loginpemakai_id" = 1;

Date: 2022-03-05 00:22:29
Duration: 2ms
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: 470ms - Times executed: 417 ]

x Hide

[ Application: [unknown] - Total duration: 470ms - Times executed: 417 ]

x Hide

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE instalasi_id = 10 AND modul_id = 15 AND date(tglnotifikasi) between '2022-03-05' AND '2022-03-06' AND (pegawai_id IS NULL OR pegawai_id IN (1028)) order by tglnotifikasi desc limit 20;

Date: 2022-03-05 00:04:19
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 = 10 AND modul_id = 15 AND date(tglnotifikasi) between '2022-03-05' AND '2022-03-06' AND (pegawai_id IS NULL OR pegawai_id IN (1028)) order by tglnotifikasi desc limit 20;

Date: 2022-03-05 00:17:13
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 instalasi_id = 10 AND modul_id = 15 AND date(tglnotifikasi) between '2022-03-05' AND '2022-03-06' AND (pegawai_id IS NULL OR pegawai_id IN (1028)) order by tglnotifikasi desc limit 20;

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

x Hide

Times Reported Time consuming queries #8

x Hide

[ User: developer - Total duration: 417ms - Times executed: 201 ]

x Hide

[ Application: [unknown] - Total duration: 417ms - Times executed: 201 ]

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-05' AND '2022-03-06' AND (pegawai_id IS NULL OR pegawai_id IN (1369)) order by tglnotifikasi desc limit 20;

Date: 2022-03-05 00:22:36
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-05' AND '2022-03-06' AND (pegawai_id IS NULL OR pegawai_id IN (1369)) order by tglnotifikasi desc limit 20;

Date: 2022-03-05 03:15:36
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 = 1 AND create_ruangan = 2 AND modul_id = 2 AND date(tglnotifikasi) between '2022-03-05' AND '2022-03-06' AND (pegawai_id IS NULL OR pegawai_id IN (1369)) order by tglnotifikasi desc limit 20;

Date: 2022-03-05 01:00:36
Duration: 2ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #9

x Hide

[ User: developer - Total duration: 231ms - Times executed: 23 ]

x Hide

[ Application: [unknown] - Total duration: 231ms - Times executed: 23 ]

x Hide

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

Date: 2022-03-05 00:00:28
Duration: 14ms
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 = 2 AND create_ruangan = 452 AND modul_id = 5 AND date(tglnotifikasi) = '2022-03-05' AND (pegawai_id IS NULL OR pegawai_id IN (1028)) order by tglnotifikasi desc limit 20;

Date: 2022-03-05 00:04:28
Duration: 13ms
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 = 2 AND create_ruangan = 452 AND modul_id = 5 AND date(tglnotifikasi) = '2022-03-05' AND (pegawai_id IS NULL OR pegawai_id IN (1028)) order by tglnotifikasi desc limit 20;

Date: 2022-03-05 00:17:28
Duration: 12ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #10

x Hide

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

x Hide

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

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 = 'loginpemakai_k' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'));

Date: 2022-03-05 00:17:04
Duration: 0ms
Database: db_rskt_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 = 'profilrumahsakit_m' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'));

Date: 2022-03-05 03:17:32
Duration: 0ms
Database: db_ihospital
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 = 'loginpemakai_k' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'));

Date: 2022-03-05 00:08:07
Duration: 0ms
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: 104ms - Times executed: 1293 ]

x Hide

[ Application: [unknown] - Total duration: 104ms - Times executed: 1293 ]

x Hide

SET NAMES 'utf8';

Date: 2022-03-05 00:19:10
Duration: 0ms
Database: db_rskt_running
User: developer
Application: [unknown]

SET NAMES 'utf8';

Date: 2022-03-05 00:18:46
Duration: 0ms
Database: db_rskt_running
User: developer
Application: [unknown]

SET NAMES 'utf8';

Date: 2022-03-05 00:54:36
Duration: 0ms
Database: db_rskt_running
User: developer
Application: [unknown]

x Hide

Times Reported Time consuming queries #12

x Hide

[ User: developer - Total duration: 46ms - Times executed: 641 ]

x Hide

[ Application: [unknown] - Total duration: 46ms - Times executed: 641 ]

x Hide

SELECT * FROM chat WHERE (chat_to = 'sysadmin' AND chat_recd = 0) ORDER BY chat_sent ASC;

Date: 2022-03-05 00:09:52
Duration: 0ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

SELECT * FROM chat WHERE (chat_to = 'sysadmin' AND chat_recd = 0) ORDER BY chat_sent ASC;

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

SELECT * FROM chat WHERE (chat_to = 'sysadmin' AND chat_recd = 0) ORDER BY chat_sent ASC;

Date: 2022-03-05 00:18:22
Duration: 0ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #13

x Hide

[ User: developer - Total duration: 19ms - Times executed: 692 ]

x Hide

[ Application: [unknown] - Total duration: 19ms - Times executed: 692 ]

x Hide

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-05 02:06:36
Duration: 0ms
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 = 'loginpemakai_k' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) AND attnum IN (1);

Date: 2022-03-05 02:50:36
Duration: 0ms
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 = 'ruanganpemakai_k' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) AND attnum IN (1, 2);

Date: 2022-03-05 00:03:22
Duration: 0ms
Database: db_rskt_simulasi
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #14

x Hide

[ User: developer - Total duration: 10ms - Times executed: 632 ]

x Hide

[ Application: [unknown] - Total duration: 10ms - Times executed: 632 ]

x Hide

SELECT * FROM "ruangan_m" "t" WHERE "t"."ruangan_id" = 512 AND (ruangan_aktif = TRUE) LIMIT 1;

Date: 2022-03-05 00:05:35
Duration: 0ms
Database: db_rskt_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT * FROM "ruangan_m" "t" WHERE "t"."ruangan_id" = 66 AND (ruangan_aktif = TRUE) LIMIT 1;

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

SELECT * FROM "ruangan_m" "t" WHERE "t"."ruangan_id" = 370 AND (ruangan_aktif = TRUE) LIMIT 1;

Date: 2022-03-05 00:03:22
Duration: 0ms
Database: db_rskt_simulasi
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #15

x Hide

[ User: developer - Total duration: 10ms - Times executed: 632 ]

x Hide

[ Application: [unknown] - Total duration: 10ms - Times executed: 632 ]

x Hide

SELECT "instalasi"."instalasi_id" AS "t1_c0", "instalasi"."riwayatruangan_id" AS "t1_c1", "instalasi"."instalasi_nama" AS "t1_c2", "instalasi"."instalasi_namalainnya" AS "t1_c3", "instalasi"."instalasi_singkatan" AS "t1_c4", "instalasi"."instalasi_lokasi" AS "t1_c5", "instalasi"."instalasirujukaninternal" AS "t1_c6", "instalasi"."instalasi_adakamar" AS "t1_c7", "instalasi"."instalasi_image" AS "t1_c8", "instalasi"."revenuecenter" AS "t1_c9", "instalasi"."instalasi_aktif" AS "t1_c10", "instalasi"."profilers_id" AS "t1_c11", "instalasi"."ispelayanan" AS "t1_c12", "instalasi"."ispenunjangmedis" AS "t1_c13", "instalasi"."ispenunjangnonmedis" AS "t1_c14", "instalasi"."isadministrasi" AS "t1_c15", "instalasi"."profilrs_id" AS "t1_c16" FROM "instalasi_m" "instalasi" WHERE ("instalasi"."instalasi_id" = '1');

Date: 2022-03-05 00:03:51
Duration: 0ms
Database: db_rskt_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT "instalasi"."instalasi_id" AS "t1_c0", "instalasi"."riwayatruangan_id" AS "t1_c1", "instalasi"."instalasi_nama" AS "t1_c2", "instalasi"."instalasi_namalainnya" AS "t1_c3", "instalasi"."instalasi_singkatan" AS "t1_c4", "instalasi"."instalasi_lokasi" AS "t1_c5", "instalasi"."instalasirujukaninternal" AS "t1_c6", "instalasi"."instalasi_adakamar" AS "t1_c7", "instalasi"."instalasi_image" AS "t1_c8", "instalasi"."revenuecenter" AS "t1_c9", "instalasi"."instalasi_aktif" AS "t1_c10", "instalasi"."profilers_id" AS "t1_c11", "instalasi"."ispelayanan" AS "t1_c12", "instalasi"."ispenunjangmedis" AS "t1_c13", "instalasi"."ispenunjangnonmedis" AS "t1_c14", "instalasi"."isadministrasi" AS "t1_c15", "instalasi"."profilrs_id" AS "t1_c16" FROM "instalasi_m" "instalasi" WHERE ("instalasi"."instalasi_id" = '2');

Date: 2022-03-05 00:02:49
Duration: 0ms
Database: db_rskt_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT "instalasi"."instalasi_id" AS "t1_c0", "instalasi"."riwayatruangan_id" AS "t1_c1", "instalasi"."instalasi_nama" AS "t1_c2", "instalasi"."instalasi_namalainnya" AS "t1_c3", "instalasi"."instalasi_singkatan" AS "t1_c4", "instalasi"."instalasi_lokasi" AS "t1_c5", "instalasi"."instalasirujukaninternal" AS "t1_c6", "instalasi"."instalasi_adakamar" AS "t1_c7", "instalasi"."instalasi_image" AS "t1_c8", "instalasi"."revenuecenter" AS "t1_c9", "instalasi"."instalasi_aktif" AS "t1_c10", "instalasi"."profilers_id" AS "t1_c11", "instalasi"."ispelayanan" AS "t1_c12", "instalasi"."ispenunjangmedis" AS "t1_c13", "instalasi"."ispenunjangnonmedis" AS "t1_c14", "instalasi"."isadministrasi" AS "t1_c15", "instalasi"."profilrs_id" AS "t1_c16" FROM "instalasi_m" "instalasi" WHERE ("instalasi"."instalasi_id" = '1');

Date: 2022-03-05 00:03:22
Duration: 0ms
Database: db_rskt_simulasi
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #16

x Hide

[ User: developer - Total duration: 9ms - Times executed: 632 ]

x Hide

[ Application: [unknown] - Total duration: 9ms - Times executed: 632 ]

x Hide

SELECT "ruangan"."ruangan_id" AS "t1_c0", "ruangan"."instalasi_id" AS "t1_c1", "ruangan"."riwayatruangan_id" AS "t1_c2", "ruangan"."ruangan_nama" AS "t1_c3", "ruangan"."ruangan_namalainnya" AS "t1_c4", "ruangan"."ruangan_jenispelayanan" AS "t1_c5", "ruangan"."ruangan_singkatan" AS "t1_c6", "ruangan"."ruangan_fasilitas" AS "t1_c7", "ruangan"."ruangan_lokasi" AS "t1_c8", "ruangan"."ruangan_image" AS "t1_c9", "ruangan"."ruangan_aktif" AS "t1_c10", "ruangan"."ruangan_nourut" AS "t1_c11", "ruangan"."ruangan_filesuara" AS "t1_c12", "ruangan"."estimasipelayanan" AS "t1_c13", "ruangan"."image_mobile" AS "t1_c14", "ruangan"."warnadokrm_id" AS "t1_c15", "ruangan"."modul_id" AS "t1_c16", "ruangan"."kode_bpjs" AS "t1_c17", "ruangan"."is_klinikanak" AS "t1_c18", "ruangan"."is_jiwa" AS "t1_c19", "ruangan"."is_saraf" AS "t1_c20", "ruangan"."is_nicu" AS "t1_c21", "ruangan"."isrevenuecenter" AS "t1_c22", "ruangan"."gedung_id" AS "t1_c23", "ruangan"."area_id" AS "t1_c24", "ruangan"."kode_ruanganaset" AS "t1_c25" FROM "ruangan_m" "ruangan" WHERE ("ruangan"."ruangan_id" = '446');

Date: 2022-03-05 00:03:22
Duration: 0ms
Database: db_rskt_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT "ruangan"."ruangan_id" AS "t1_c0", "ruangan"."instalasi_id" AS "t1_c1", "ruangan"."riwayatruangan_id" AS "t1_c2", "ruangan"."ruangan_nama" AS "t1_c3", "ruangan"."ruangan_namalainnya" AS "t1_c4", "ruangan"."ruangan_jenispelayanan" AS "t1_c5", "ruangan"."ruangan_singkatan" AS "t1_c6", "ruangan"."ruangan_fasilitas" AS "t1_c7", "ruangan"."ruangan_lokasi" AS "t1_c8", "ruangan"."ruangan_image" AS "t1_c9", "ruangan"."ruangan_aktif" AS "t1_c10", "ruangan"."ruangan_nourut" AS "t1_c11", "ruangan"."ruangan_filesuara" AS "t1_c12", "ruangan"."estimasipelayanan" AS "t1_c13", "ruangan"."image_mobile" AS "t1_c14", "ruangan"."warnadokrm_id" AS "t1_c15", "ruangan"."modul_id" AS "t1_c16", "ruangan"."kode_bpjs" AS "t1_c17", "ruangan"."is_klinikanak" AS "t1_c18", "ruangan"."is_jiwa" AS "t1_c19", "ruangan"."is_saraf" AS "t1_c20", "ruangan"."is_nicu" AS "t1_c21", "ruangan"."isrevenuecenter" AS "t1_c22", "ruangan"."gedung_id" AS "t1_c23", "ruangan"."area_id" AS "t1_c24", "ruangan"."kode_ruanganaset" AS "t1_c25" FROM "ruangan_m" "ruangan" WHERE ("ruangan"."ruangan_id" = '56');

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

SELECT "ruangan"."ruangan_id" AS "t1_c0", "ruangan"."instalasi_id" AS "t1_c1", "ruangan"."riwayatruangan_id" AS "t1_c2", "ruangan"."ruangan_nama" AS "t1_c3", "ruangan"."ruangan_namalainnya" AS "t1_c4", "ruangan"."ruangan_jenispelayanan" AS "t1_c5", "ruangan"."ruangan_singkatan" AS "t1_c6", "ruangan"."ruangan_fasilitas" AS "t1_c7", "ruangan"."ruangan_lokasi" AS "t1_c8", "ruangan"."ruangan_image" AS "t1_c9", "ruangan"."ruangan_aktif" AS "t1_c10", "ruangan"."ruangan_nourut" AS "t1_c11", "ruangan"."ruangan_filesuara" AS "t1_c12", "ruangan"."estimasipelayanan" AS "t1_c13", "ruangan"."image_mobile" AS "t1_c14", "ruangan"."warnadokrm_id" AS "t1_c15", "ruangan"."modul_id" AS "t1_c16", "ruangan"."kode_bpjs" AS "t1_c17", "ruangan"."is_klinikanak" AS "t1_c18", "ruangan"."is_jiwa" AS "t1_c19", "ruangan"."is_saraf" AS "t1_c20", "ruangan"."is_nicu" AS "t1_c21", "ruangan"."isrevenuecenter" AS "t1_c22", "ruangan"."gedung_id" AS "t1_c23", "ruangan"."area_id" AS "t1_c24", "ruangan"."kode_ruanganaset" AS "t1_c25" FROM "ruangan_m" "ruangan" WHERE ("ruangan"."ruangan_id" = '46');

Date: 2022-03-05 00:02:49
Duration: 0ms
Database: db_rskt_simulasi
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #17

x Hide

[ User: developer - Total duration: 4ms - Times executed: 264 ]

x Hide

[ Application: [unknown] - Total duration: 4ms - Times executed: 264 ]

x Hide

SELECT * FROM "modul_k" "t" WHERE "t"."modul_id" = 72 AND (modul_aktif = TRUE) LIMIT 1;

Date: 2022-03-05 00:04:51
Duration: 0ms
Database: db_rskt_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT * FROM "modul_k" "t" WHERE "t"."modul_id" = 74 AND (modul_aktif = TRUE) LIMIT 1;

Date: 2022-03-05 00:04:51
Duration: 0ms
Database: db_rskt_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT * FROM "modul_k" "t" WHERE "t"."modul_id" = 15 AND (modul_aktif = TRUE) LIMIT 1;

Date: 2022-03-05 00:03:51
Duration: 0ms
Database: db_rskt_simulasi
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #18

x Hide

[ User: developer - Total duration: 1ms - Times executed: 8 ]

x Hide

[ Application: [unknown] - Total duration: 1ms - Times executed: 8 ]

x Hide

SELECT * FROM "ruanganpemakai_k" "t" WHERE "t"."loginpemakai_id" = '1';

Date: 2022-03-05 00:03:22
Duration: 0ms
Database: db_rskt_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT * FROM "ruanganpemakai_k" "t" WHERE "t"."loginpemakai_id" = '1';

Date: 2022-03-05 00:04:51
Duration: 0ms
Database: db_rskt_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT * FROM "ruanganpemakai_k" "t" WHERE "t"."loginpemakai_id" = '1';

Date: 2022-03-05 00:04:14
Duration: 0ms
Database: db_rskt_simulasi
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #19

x Hide

[ User: developer - Total duration: 1ms - Times executed: 1 ]

x Hide

[ Application: pgAdmin 4 - DB:postgres - Total duration: 1ms - Times executed: 1 ]

x Hide

SELECT db.oid as did, db.datname, db.datallowconn, pg_encoding_to_char(db.encoding) AS serverencoding, has_database_privilege(db.oid, 'CREATE') as cancreate, datlastsysoid FROM pg_database db WHERE db.datname = current_database();

Date: 2022-03-05 02:40:28
Duration: 1ms
Database: postgres
User: developer
Application: pgAdmin 4 - DB:postgres

x Hide

Times Reported Time consuming queries #20

x Hide

[ User: developer - Total duration: 0ms - Times executed: 1 ]

x Hide

[ Application: pgAdmin 4 - DB:postgres - Total duration: 0ms - Times executed: 1 ]

x Hide

SELECT oid as id, rolname as name, rolsuper as is_superuser, rolcreaterole as can_create_role, rolcreatedb as can_create_db FROM pg_catalog.pg_roles WHERE rolname = current_user;

Date: 2022-03-05 02:40:28
Duration: 0ms
Database: postgres
User: developer
Application: pgAdmin 4 - DB:postgres

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: developer - Total duration: 2m3s - Times executed: 11181 ]

x Hide

[ Application: pgAdmin 4 - DB:postgres - Total duration: 2m3s - Times executed: 11181 ]

x Hide

SELECT ( SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Returned";

Date: 2022-03-05 00:00:10
Duration: 14ms
Database: postgres
User: developer
Application: pgAdmin 4 - DB:postgres

SELECT ( SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Returned";

Date: 2022-03-05 01:27:56
Duration: 14ms
Database: postgres
User: developer
Application: pgAdmin 4 - DB:postgres

SELECT ( SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Returned";

Date: 2022-03-05 00:08:26
Duration: 12ms
Database: postgres
User: developer
Application: pgAdmin 4 - DB:postgres

x Hide