SELECT n.nspname, c.relname, a.attname, tp.typname FROM pg_attribute a JOIN pg_class c on a.attrelid = c.oid JOIN pg_namespace n on c.relnamespace = n.oid JOIN pg_type tp on tp.oid = a.atttypid WHERE a.attnum > 0 ORDER BY nspname, relname;

Date: 2022-01-01 01:44:49
Duration: 1s738ms
Database: db_ihospital
User: developer
Application: Navicat

SELECT n.nspname, c.relname, a.attname, tp.typname FROM pg_attribute a JOIN pg_class c on a.attrelid = c.oid JOIN pg_namespace n on c.relnamespace = n.oid JOIN pg_type tp on tp.oid = a.atttypid WHERE a.attnum > 0 ORDER BY nspname, relname;

Date: 2022-01-01 01:44:49
Duration: 0ms
Database: db_ihospital
User: developer
Application: Navicat

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: developer - Total duration: 2m25s - Times executed: 355 ]

x Hide

[ Application: [unknown] - Total duration: 2m25s - Times executed: 355 ]

x Hide

SELECT * FROM "reportbugs_r" "t" WHERE "t"."link_bugs" = 'http://165.22.51.146/ihospital-rscms-simulasi/index.php?r=chat&action=refreshchat&_=1640854279774' AND "t"."kodebugs" = '403' AND "t"."type_bugs" = 'CHttpException' LIMIT 1;

Date: 2022-01-01 01:06:51
Duration: 572ms
Database: db_rscms_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT * FROM "reportbugs_r" "t" WHERE "t"."link_bugs" = 'http://165.22.51.146/ihospital-rscms-simulasi/index.php?r=chat&action=refreshchat&_=1640854267802' AND "t"."kodebugs" = '403' AND "t"."type_bugs" = 'CHttpException' LIMIT 1;

Date: 2022-01-01 01:06:48
Duration: 572ms
Database: db_rscms_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT * FROM "reportbugs_r" "t" WHERE "t"."link_bugs" = 'http://165.22.51.146/ihospital-rscms-simulasi/index.php?r=chat&action=refreshchat&_=1640854287191' AND "t"."kodebugs" = '403' AND "t"."type_bugs" = 'CHttpException' LIMIT 1;

Date: 2022-01-01 01:06:36
Duration: 563ms
Database: db_rscms_simulasi
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: developer - Total duration: 27s330ms - Times executed: 1616 ]

x Hide

[ Application: pgAdmin 4 - DB:db_rscms_simulasi - Total duration: 24s337ms - Times executed: 1443 ]

[ Application: pgAdmin 4 - DB:db_ihospital - Total duration: 2s359ms - Times executed: 137 ]

[ Application: pgAdmin 4 - DB:db_rscms_running - Total duration: 634ms - Times executed: 36 ]

x Hide

/*pga4dash*/ SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_stat_activity WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Total", ( SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Active", ( SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( 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") t UNION ALL SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Hits") t;

Date: 2022-01-01 02:02:53
Duration: 31ms
Database: db_rscms_simulasi
User: developer
Application: pgAdmin 4 - DB:db_rscms_simulasi

/*pga4dash*/ SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_stat_activity WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287020)) AS "Total", ( SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_database WHERE oid = 287020)) AS "Active", ( SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_database WHERE oid = 287020)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287020)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287020)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287020)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287020)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287020)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287020)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287020)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287020)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287020)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287020)) AS "Hits") t;

Date: 2022-01-01 01:42:20
Duration: 27ms
Database: db_rscms_running
User: developer
Application: pgAdmin 4 - DB:db_rscms_running

/*pga4dash*/ SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_stat_activity WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Total", ( SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Active", ( SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( 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") t UNION ALL SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = ( SELECT datname FROM pg_database WHERE oid = 287023)) AS "Hits") t;

Date: 2022-01-01 01:43:20
Duration: 26ms
Database: db_rscms_simulasi
User: developer
Application: pgAdmin 4 - DB:db_rscms_simulasi

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: developer - Total duration: 22s230ms - Times executed: 9573 ]

x Hide

[ Application: [unknown] - Total duration: 22s230ms - Times executed: 9573 ]

x Hide

SELECT count(nofitikasi_id) as total FROM notifikasi_r WHERE instalasi_id = 4 AND create_ruangan = 356 AND modul_id = 7 AND (pegawai_id IS NULL OR pegawai_id IN (44));

Date: 2022-01-01 01:06:29
Duration: 17ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

SELECT count(nofitikasi_id) as total FROM notifikasi_r WHERE instalasi_id = 4 AND create_ruangan = 356 AND modul_id = 7 AND (pegawai_id IS NULL OR pegawai_id IN (44));

Date: 2022-01-01 01:07:29
Duration: 15ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

SELECT count(nofitikasi_id) as total FROM notifikasi_r WHERE instalasi_id = 4 AND create_ruangan = 356 AND modul_id = 7 AND (pegawai_id IS NULL OR pegawai_id IN (44));

Date: 2022-01-01 03:03:28
Duration: 12ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: developer - Total duration: 9s611ms - Times executed: 8949 ]

x Hide

[ Application: [unknown] - Total duration: 9s611ms - Times executed: 8949 ]

x Hide

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi, is_segera FROM notifikasi_r WHERE isread = false AND instalasi_id = 6 AND create_ruangan = 56 AND modul_id = 9 AND date(tglnotifikasi) = '2022-01-01' AND (pegawai_id IS NULL OR pegawai_id IN (1227)) order by tglnotifikasi desc limit 20;

Date: 2022-01-01 01:07:05
Duration: 9ms
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 = 6 AND create_ruangan = 56 AND modul_id = 9 AND date(tglnotifikasi) = '2022-01-01' AND (pegawai_id IS NULL OR pegawai_id IN (1227)) order by tglnotifikasi desc limit 20;

Date: 2022-01-01 02:04:35
Duration: 8ms
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 = 6 AND create_ruangan = 56 AND modul_id = 9 AND date(tglnotifikasi) = '2022-01-01' AND (pegawai_id IS NULL OR pegawai_id IN (1227)) order by tglnotifikasi desc limit 20;

Date: 2022-01-01 00:01:17
Duration: 7ms
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: 9s485ms - Times executed: 9723 ]

x Hide

[ Application: [unknown] - Total duration: 9s485ms - Times executed: 9723 ]

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

Date: 2022-01-01 01:07:43
Duration: 15ms
Database: db_rscms_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 = 'loginpemakai_k' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;

Date: 2022-01-01 01:06:29
Duration: 11ms
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 = 'reportbugs_r' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;

Date: 2022-01-01 01:06:59
Duration: 10ms
Database: db_rscms_simulasi
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #6

x Hide

[ User: developer - Total duration: 8s736ms - Times executed: 8949 ]

x Hide

[ Application: [unknown] - Total duration: 8s736ms - Times executed: 8949 ]

x Hide

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

Date: 2022-01-01 01:06:22
Duration: 6ms
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 = 79 AND create_ruangan = 1 AND modul_id = 1 AND date(tglnotifikasi) = '2022-01-01' AND (pegawai_id IS NULL OR pegawai_id IN (1028)) order by tglnotifikasi desc limit 20;

Date: 2022-01-01 01:20:58
Duration: 4ms
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 = 6 AND create_ruangan = 56 AND modul_id = 9 AND date(tglnotifikasi) = '2022-01-01' AND (pegawai_id IS NULL OR pegawai_id IN (1227)) order by tglnotifikasi desc limit 20;

Date: 2022-01-01 02:34:56
Duration: 3ms
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: 6s554ms - Times executed: 9365 ]

x Hide

[ Application: [unknown] - Total duration: 6s554ms - Times executed: 9365 ]

x Hide

UPDATE "loginpemakai_k" SET "statuslogin" = 't', "ruanganaktifitas" = '1', "crudaktifitas" = 'chat', "waktuterakhiraktifitas" = '2022-01-01 01:07:16' WHERE "loginpemakai_k"."loginpemakai_id" = 1;

Date: 2022-01-01 01:07:16
Duration: 5ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

UPDATE "loginpemakai_k" SET "statuslogin" = 't', "ruanganaktifitas" = '56', "crudaktifitas" = 'chat', "waktuterakhiraktifitas" = '2022-01-01 02:01:41' WHERE "loginpemakai_k"."loginpemakai_id" = 658;

Date: 2022-01-01 02:01:41
Duration: 4ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

UPDATE "loginpemakai_k" SET "statuslogin" = 't', "ruanganaktifitas" = '356', "crudaktifitas" = 'chat', "waktuterakhiraktifitas" = '2022-01-01 03:26:28' WHERE "loginpemakai_k"."loginpemakai_id" = 662;

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

x Hide

Times Reported Time consuming queries #8

x Hide

[ User: developer - Total duration: 3s115ms - Times executed: 624 ]

x Hide

[ Application: [unknown] - Total duration: 3s115ms - Times executed: 624 ]

x Hide

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi FROM notifikasi_r WHERE isread = false AND instalasi_id = 4 AND create_ruangan = 356 AND modul_id = 7 AND date(tglnotifikasi) = '2022-01-01' AND (pegawai_id IS NULL OR pegawai_id IN (44)) order by tglnotifikasi desc limit 20;

Date: 2022-01-01 01:07:29
Duration: 28ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi FROM notifikasi_r WHERE isread = false AND instalasi_id = 4 AND create_ruangan = 356 AND modul_id = 7 AND date(tglnotifikasi) = '2022-01-01' AND (pegawai_id IS NULL OR pegawai_id IN (44)) order by tglnotifikasi desc limit 20;

Date: 2022-01-01 02:04:28
Duration: 8ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi FROM notifikasi_r WHERE isread = false AND instalasi_id = 4 AND create_ruangan = 356 AND modul_id = 7 AND date(tglnotifikasi) = '2022-01-01' AND (pegawai_id IS NULL OR pegawai_id IN (44)) order by tglnotifikasi desc limit 20;

Date: 2022-01-01 02:13:28
Duration: 8ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #9

x Hide

[ User: developer - Total duration: 3s32ms - Times executed: 624 ]

x Hide

[ Application: [unknown] - Total duration: 3s32ms - Times executed: 624 ]

x Hide

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi FROM notifikasi_r WHERE instalasi_id = 4 AND create_ruangan = 356 AND modul_id = 7 AND date(tglnotifikasi) = '2022-01-01' AND (pegawai_id IS NULL OR pegawai_id IN (44)) order by tglnotifikasi desc limit 20;

Date: 2022-01-01 01:06:28
Duration: 13ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi FROM notifikasi_r WHERE instalasi_id = 4 AND create_ruangan = 356 AND modul_id = 7 AND date(tglnotifikasi) = '2022-01-01' AND (pegawai_id IS NULL OR pegawai_id IN (44)) order by tglnotifikasi desc limit 20;

Date: 2022-01-01 03:06:28
Duration: 8ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

SELECT isread, nofitikasi_id, judulnotifikasi, tglnotifikasi, isinotifikasi FROM notifikasi_r WHERE instalasi_id = 4 AND create_ruangan = 356 AND modul_id = 7 AND date(tglnotifikasi) = '2022-01-01' AND (pegawai_id IS NULL OR pegawai_id IN (44)) order by tglnotifikasi desc limit 20;

Date: 2022-01-01 02:40:28
Duration: 7ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #10

x Hide

[ User: developer - Total duration: 3s9ms - Times executed: 9723 ]

x Hide

[ Application: [unknown] - Total duration: 3s9ms - Times executed: 9723 ]

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-01-01 01:06:43
Duration: 11ms
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 = 'reportbugs_r' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'));

Date: 2022-01-01 01:06:41
Duration: 5ms
Database: db_rscms_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 = 'loginpemakai_k' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'));

Date: 2022-01-01 00:52:43
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: 2s297ms - Times executed: 19505 ]

x Hide

[ Application: [unknown] - Total duration: 2s297ms - Times executed: 19505 ]

x Hide

SET NAMES 'utf8';

Date: 2022-01-01 03:03:38
Duration: 2ms
Database: db_rskt_running
User: developer
Application: [unknown]

SET NAMES 'utf8';

Date: 2022-01-01 01:58:22
Duration: 1ms
Database: db_rskt_running
User: developer
Application: [unknown]

SET NAMES 'utf8';

Date: 2022-01-01 00:31:01
Duration: 1ms
Database: db_rskt_running
User: developer
Application: [unknown]

x Hide

Times Reported Time consuming queries #12

x Hide

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

x Hide

[ Application: Navicat - Total duration: 1s738ms - Times executed: 1 ]

x Hide

SELECT n.nspname, c.relname, a.attname, tp.typname FROM pg_attribute a JOIN pg_class c on a.attrelid = c.oid JOIN pg_namespace n on c.relnamespace = n.oid JOIN pg_type tp on tp.oid = a.atttypid WHERE a.attnum > 0 ORDER BY nspname, relname;

Date: 2022-01-01 01:44:49
Duration: 1s738ms
Database: db_ihospital
User: developer
Application: Navicat

SELECT n.nspname, c.relname, a.attname, tp.typname FROM pg_attribute a JOIN pg_class c on a.attrelid = c.oid JOIN pg_namespace n on c.relnamespace = n.oid JOIN pg_type tp on tp.oid = a.atttypid WHERE a.attnum > 0 ORDER BY nspname, relname;

Date: 2022-01-01 01:44:49
Duration: 0ms
Database: db_ihospital
User: developer
Application: Navicat

x Hide

Times Reported Time consuming queries #13

x Hide

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

x Hide

[ Application: Navicat - Total duration: 1s55ms - Times executed: 1 ]

x Hide

SELECT r.routine_schema, r.routine_name, string_agg(p.udt_name, ', ' ORDER BY p.ordinal_position) AS object_info FROM information_schema.routines r LEFT JOIN information_schema.parameters p ON r.specific_name = p.specific_name GROUP BY p.specific_name, r.routine_schema, r.routine_name ORDER BY r.routine_schema;

Date: 2022-01-01 01:45:02
Duration: 1s55ms
Database: db_ihospital
User: developer
Application: Navicat

x Hide

Times Reported Time consuming queries #14

x Hide

[ User: developer - Total duration: 770ms - Times executed: 52 ]

x Hide

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

x Hide

/*pga4dash*/ SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_stat_activity) AS "Total", ( SELECT count(*) FROM pg_stat_activity WHERE state = 'active') AS "Active", ( SELECT count(*) FROM pg_stat_activity WHERE state = 'idle') AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_stat_database) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_stat_database) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_stat_database) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_stat_database) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_stat_database) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_stat_database) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_stat_database) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_stat_database) AS "Reads", ( SELECT sum(blks_hit) FROM pg_stat_database) AS "Hits") t;

Date: 2022-01-01 01:39:26
Duration: 16ms
Database: postgres
User: developer
Application: pgAdmin 4 - DB:postgres

/*pga4dash*/ SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_stat_activity) AS "Total", ( SELECT count(*) FROM pg_stat_activity WHERE state = 'active') AS "Active", ( SELECT count(*) FROM pg_stat_activity WHERE state = 'idle') AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_stat_database) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_stat_database) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_stat_database) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_stat_database) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_stat_database) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_stat_database) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_stat_database) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_stat_database) AS "Reads", ( SELECT sum(blks_hit) FROM pg_stat_database) AS "Hits") t;

Date: 2022-01-01 01:39:21
Duration: 16ms
Database: postgres
User: developer
Application: pgAdmin 4 - DB:postgres

/*pga4dash*/ SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_stat_activity) AS "Total", ( SELECT count(*) FROM pg_stat_activity WHERE state = 'active') AS "Active", ( SELECT count(*) FROM pg_stat_activity WHERE state = 'idle') AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_stat_database) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_stat_database) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_stat_database) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_stat_database) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_stat_database) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_stat_database) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_stat_database) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_stat_database) AS "Reads", ( SELECT sum(blks_hit) FROM pg_stat_database) AS "Hits") t;

Date: 2022-01-01 01:39:04
Duration: 16ms
Database: postgres
User: developer
Application: pgAdmin 4 - DB:postgres