Times Reported Time consuming queries #1

x Hide

[ User: developer - Total duration: 1s174ms - Times executed: 427 ]

x Hide

[ Application: [unknown] - Total duration: 1s174ms - Times executed: 427 ]

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 (1272));

Date: 2022-01-22 00:13:03
Duration: 6ms
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 (1272));

Date: 2022-01-22 01:00:03
Duration: 6ms
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 (1272));

Date: 2022-01-22 03:10:04
Duration: 5ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: developer - Total duration: 716ms - Times executed: 427 ]

x Hide

[ Application: [unknown] - Total duration: 716ms - Times executed: 427 ]

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-01-22' AND (pegawai_id IS NULL OR pegawai_id IN (1272)) order by tglnotifikasi desc limit 20;

Date: 2022-01-22 01:00:03
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 = 1 AND create_ruangan = 2 AND modul_id = 2 AND date(tglnotifikasi) = '2022-01-22' AND (pegawai_id IS NULL OR pegawai_id IN (1272)) order by tglnotifikasi desc limit 20;

Date: 2022-01-22 02:31:04
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 = 1 AND create_ruangan = 2 AND modul_id = 2 AND date(tglnotifikasi) = '2022-01-22' AND (pegawai_id IS NULL OR pegawai_id IN (1272)) order by tglnotifikasi desc limit 20;

Date: 2022-01-22 02:00:03
Duration: 3ms
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: 621ms - Times executed: 436 ]

x Hide

[ Application: [unknown] - Total duration: 621ms - Times executed: 436 ]

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

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

Date: 2022-01-22 00:21:15
Duration: 8ms
Database: db_rsbin_simulasi
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: developer - Total duration: 508ms - Times executed: 216 ]

x Hide

[ Application: [unknown] - Total duration: 508ms - Times executed: 216 ]

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-01-22' AND '2022-01-23' AND (pegawai_id IS NULL OR pegawai_id IN (1272)) order by tglnotifikasi desc limit 20;

Date: 2022-01-22 01:39:03
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 isread = false AND instalasi_id = 1 AND create_ruangan = 2 AND modul_id = 2 AND date(tglnotifikasi) between '2022-01-22' AND '2022-01-23' AND (pegawai_id IS NULL OR pegawai_id IN (1272)) order by tglnotifikasi desc limit 20;

Date: 2022-01-22 02:00:03
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 isread = false AND instalasi_id = 1 AND create_ruangan = 2 AND modul_id = 2 AND date(tglnotifikasi) between '2022-01-22' AND '2022-01-23' AND (pegawai_id IS NULL OR pegawai_id IN (1272)) order by tglnotifikasi desc limit 20;

Date: 2022-01-22 02:54:03
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: 329ms - Times executed: 427 ]

x Hide

[ Application: [unknown] - Total duration: 329ms - Times executed: 427 ]

x Hide

UPDATE "loginpemakai_k" SET "statuslogin" = 't', "ruanganaktifitas" = '2', "crudaktifitas" = 'chat', "waktuterakhiraktifitas" = '2022-01-22 03:26:04' WHERE "loginpemakai_k"."loginpemakai_id" = 874;

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

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

Date: 2022-01-22 00:05:31
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-01-22 00:00:01' WHERE "loginpemakai_k"."loginpemakai_id" = 874;

Date: 2022-01-22 00:00:01
Duration: 1ms
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: 228ms - Times executed: 211 ]

x Hide

[ Application: [unknown] - Total duration: 228ms - Times executed: 211 ]

x Hide

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

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

Date: 2022-01-22 02:54:31
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 = 79 AND create_ruangan = 1 AND modul_id = 1 AND date(tglnotifikasi) = '2022-01-22' AND (pegawai_id IS NULL OR pegawai_id IN (1372)) order by tglnotifikasi desc limit 20;

Date: 2022-01-22 02:01:31
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: 188ms - Times executed: 436 ]

x Hide

[ Application: [unknown] - Total duration: 188ms - Times executed: 436 ]

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

Date: 2022-01-22 00:21:15
Duration: 9ms
Database: db_rsbin_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 = 'profilrumahsakit_m' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'));

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

Date: 2022-01-22 02:00:03
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: 116ms - Times executed: 868 ]

x Hide

[ Application: [unknown] - Total duration: 116ms - Times executed: 868 ]

x Hide

SET NAMES 'utf8';

Date: 2022-01-22 02:39:04
Duration: 0ms
Database: db_rskt_running
User: developer
Application: [unknown]

SET NAMES 'utf8';

Date: 2022-01-22 02:22:04
Duration: 0ms
Database: db_rskt_running
User: developer
Application: [unknown]

SET NAMES 'utf8';

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

x Hide

Times Reported Time consuming queries #9

x Hide

[ User: developer - Total duration: 32ms - Times executed: 427 ]

x Hide

[ Application: [unknown] - Total duration: 32ms - Times executed: 427 ]

x Hide

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

Date: 2022-01-22 02:39:31
Duration: 0ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

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

Date: 2022-01-22 00:25:31
Duration: 0ms
Database: db_rskt_running
User: developer
Application: [unknown]
Bind query: yes

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

Date: 2022-01-22 00:24:31
Duration: 0ms
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: 17ms - Times executed: 3 ]

x Hide

[ Application: [unknown] - Total duration: 17ms - Times executed: 3 ]

x Hide

SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, ( SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval', false) OR attidentity != '' AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string(( SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = - 1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = - 1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST(information_schema._pg_char_max_length (information_schema._pg_truetypid (a, t), information_schema._pg_truetypmod (a, t)) AS numeric) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF (a.attndims, 0), NULLIF (t.typndims, 0), (t.typcategory = 'A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory = 'A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'profilrumahsakit_m' AND d.nspname = 'public' ORDER BY a.attnum;

Date: 2022-01-22 00:20:53
Duration: 10ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, ( SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval', false) OR attidentity != '' AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string(( SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = - 1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = - 1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST(information_schema._pg_char_max_length (information_schema._pg_truetypid (a, t), information_schema._pg_truetypmod (a, t)) AS numeric) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF (a.attndims, 0), NULLIF (t.typndims, 0), (t.typcategory = 'A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory = 'A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'profilrumahsakit_m' AND d.nspname = 'public' ORDER BY a.attnum;

Date: 2022-01-22 01:22:58
Duration: 3ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, ( SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval', false) OR attidentity != '' AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string(( SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = - 1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = - 1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST(information_schema._pg_char_max_length (information_schema._pg_truetypid (a, t), information_schema._pg_truetypmod (a, t)) AS numeric) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF (a.attndims, 0), NULLIF (t.typndims, 0), (t.typcategory = 'A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory = 'A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'profilrumahsakit_m' AND d.nspname = 'public' ORDER BY a.attnum;

Date: 2022-01-22 00:21:08
Duration: 3ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #11

x Hide

[ User: developer - Total duration: 15ms - Times executed: 436 ]

x Hide

[ Application: [unknown] - Total duration: 15ms - Times executed: 436 ]

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-01-22 00:52:04
Duration: 1ms
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-01-22 02:06:31
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-01-22 00:00:07
Duration: 0ms
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: 11ms - Times executed: 3 ]

x Hide

[ Application: [unknown] - Total duration: 11ms - Times executed: 3 ]

x Hide

select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from ( SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct) AS ct inner join pg_class c on c.oid = ct.conrelid inner join pg_namespace ns on c.relnamespace = ns.oid inner join pg_attribute a on a.attrelid = ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid = ct.confrelid left join pg_namespace fns on fc.relnamespace = fns.oid left join pg_attribute fa on fa.attrelid = ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype = 'f' and c.relname = 'profilrumahsakit_m' and ns.nspname = 'public' order by fns.nspname, fc.relname, a.attnum;

Date: 2022-01-22 00:20:53
Duration: 7ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from ( SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct) AS ct inner join pg_class c on c.oid = ct.conrelid inner join pg_namespace ns on c.relnamespace = ns.oid inner join pg_attribute a on a.attrelid = ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid = ct.confrelid left join pg_namespace fns on fc.relnamespace = fns.oid left join pg_attribute fa on fa.attrelid = ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype = 'f' and c.relname = 'profilrumahsakit_m' and ns.nspname = 'public' order by fns.nspname, fc.relname, a.attnum;

Date: 2022-01-22 00:21:08
Duration: 2ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from ( SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct) AS ct inner join pg_class c on c.oid = ct.conrelid inner join pg_namespace ns on c.relnamespace = ns.oid inner join pg_attribute a on a.attrelid = ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid = ct.confrelid left join pg_namespace fns on fc.relnamespace = fns.oid left join pg_attribute fa on fa.attrelid = ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype = 'f' and c.relname = 'profilrumahsakit_m' and ns.nspname = 'public' order by fns.nspname, fc.relname, a.attnum;

Date: 2022-01-22 01:22:58
Duration: 1ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #13

x Hide

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

x Hide

[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]

x Hide

SELECT * FROM "menu" WHERE "app_route" = 'ppi';

Date: 2022-01-22 01:22:59
Duration: 0ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

SELECT * FROM "menu" WHERE "app_route" = 'ppi';

Date: 2022-01-22 01:23:02
Duration: 0ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #14

x Hide

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

x Hide

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

x Hide

SELECT * FROM "profilrumahsakit_m" "t" WHERE "t"."profilrs_id" = 1 LIMIT 1;

Date: 2022-01-22 00:21:15
Duration: 0ms
Database: db_rsbin_simulasi
User: developer
Application: [unknown]
Bind query: yes

SELECT * FROM "profilrumahsakit_m" "t" WHERE "t"."profilrs_id" = 1 LIMIT 1;

Date: 2022-01-22 01:37:58
Duration: 0ms
Database: db_rscms_running
User: developer
Application: [unknown]
Bind query: yes

SELECT * FROM "profilrumahsakit_m" "t" WHERE "t"."profilrs_id" = 1 LIMIT 1;

Date: 2022-01-22 01:23:00
Duration: 0ms
Database: db_rsbin_running
User: developer
Application: [unknown]
Bind query: yes

x Hide