pgBadger-
Global information
- Generated on Sat Jan 15 03:13:38 2022
- Log file: /var/log/postgresql/postgresql-12-main.log
- Parsed 2,644 log entries in 13m36s
- Log start from 2022-01-15 01:23:12 to 2022-01-15 02:22:43
-
Overview
Global Stats
- 24 Number of unique normalized queries
- 88 Number of queries
- 167ms Total query duration
- 2022-01-15 01:23:12 First query
- 2022-01-15 02:22:43 Last query
- 81 queries/s at 2022-01-15 02:22:43 Query peak
- 167ms Total query duration
- 34ms Prepare/parse total duration
- 92ms Bind total duration
- 40ms Execute total duration
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 3 Total number of sessions
- 1 sessions at 2022-01-15 02:22:42 Session peak
- 384ms Total duration of sessions
- 128ms Average duration of sessions
- 29 Average queries per session
- 55ms Average queries duration per session
- 3 Total number of connections
- 1 connections/s at 2022-01-15 02:22:42 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 81 queries/s Query Peak
- 2022-01-15 02:22:43 Date
SELECT Traffic
Key values
- 0 queries/s Query Peak
- Date
INSERT/UPDATE/DELETE Traffic
Key values
- 80 queries/s Query Peak
- 2022-01-15 02:22:43 Date
Queries duration
Key values
- 167ms Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 15 01 5 0ms 10ms 3ms 19ms 19ms 19ms 02 83 0ms 3ms 0ms 21ms 21ms 21ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 15 01 4 0 4ms 19ms 19ms 19ms 02 81 0 0ms 20ms 20ms 20ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 15 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jan 15 01 4 4 1.00 100.00% 02 81 81 1.00 100.00% Day Hour Count Average / Second Jan 15 01 1 0.00/s 02 2 0.00/s Day Hour Count Average Duration Jan 15 01 1 96ms 02 2 144ms -
Connections
Established Connections
Key values
- 1 connections Connection Peak
- 2022-01-15 02:22:42 Date
Connections per database
Key values
- db_rsbin_running Main Database
- 3 connections Total
Connections per user
Key values
- developer Main User
- 3 connections Total
-
Sessions
Simultaneous sessions
Key values
- 1 sessions Session Peak
- 2022-01-15 02:22:42 Date
Histogram of session times
Key values
- 3 0-500ms duration
Sessions per database
Key values
- db_rsbin_running Main Database
- 3 sessions Total
Sessions per user
Key values
- developer Main User
- 3 sessions Total
Sessions per host
Key values
- 165.22.51.146 Main Host
- 3 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 0 buffers Checkpoint Peak
- Date
- seconds Highest write time
- seconds Sync time
Checkpoint write buffers (5 minutes period)
NO DATASET
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- Date
Checkpoint Wal files usage (5 minutes period)
NO DATASET
Checkpoints distance
Key values
- 0 Mo Distance Peak
- Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jan 15 01 0 0s 0s 0s 02 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jan 15 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jan 15 01 0 0s 02 0 0s Day Hour Mean distance Mean estimate Jan 15 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jan 15 01 0 0 0 02 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jan 15 01 0 0 02 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 85 Total read queries
- 0 Total write queries
Queries by database
Key values
- website_rsbin Main database
- 72 Requests
- 19ms (db_rscms_running)
- Main time consuming database
Queries by user
Key values
- developer Main user
- 2,614,468 Requests
User Request type Count Duration developer Total 2,614,468 28m35s BEGIN 386 3ms COMMIT 284 492ms DELETE 47 7ms INSERT 1,157 6s89ms ROLLBACK 102 25ms SELECT 2,102,197 25m24s UPDATE 169,943 2m22s others 340,352 41s374ms Duration by user
Key values
- 28m35s (developer) Main time consuming user
User Request type Count Duration developer Total 2,614,468 28m35s BEGIN 386 3ms COMMIT 284 492ms DELETE 47 7ms INSERT 1,157 6s89ms ROLLBACK 102 25ms SELECT 2,102,197 25m24s UPDATE 169,943 2m22s others 340,352 41s374ms Queries by host
Key values
- unknown Main host
- 2,614,468 Requests
- 28m35s (unknown)
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 88 Requests
- 40ms ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2022-01-15 02:22:42 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 84 0-1ms duration
Slowest individual queries
Rank Duration Query 1 10ms 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-15 01:23:12 - Database: db_rscms_running - User: developer - Application: [unknown] - Bind query: yes ]
2 8ms 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-15 01:23:12 - Database: db_rscms_running - User: developer - Application: [unknown] - Bind query: yes ]
3 3ms 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 = 'slider_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;[ Date: 2022-01-15 02:22:42 - Database: website_rsbin - User: developer - Application: [unknown] - Bind query: yes ]
4 1ms 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 = 'post' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;[ Date: 2022-01-15 02:22:43 - Database: website_rsbin - User: developer - Application: [unknown] - Bind query: yes ]
5 0ms 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 = 'fitur_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;[ Date: 2022-01-15 02:22:43 - Database: website_rsbin - User: developer - Application: [unknown] - Bind query: yes ]
6 0ms 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 = 'profil_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;[ Date: 2022-01-15 02:22:43 - Database: website_rsbin - User: developer - Application: [unknown] - Bind query: yes ]
7 0ms 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 = 'slider_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'));[ Date: 2022-01-15 02:22:43 - Database: website_rsbin - User: developer - Application: [unknown] - Bind query: yes ]
8 0ms 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 = 'static_page' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;[ Date: 2022-01-15 02:22:43 - Database: website_rsbin - User: developer - Application: [unknown] - Bind query: yes ]
9 0ms 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-01-15 02:22:43 - Database: db_rsbin_running - User: developer - Application: [unknown] - Bind query: yes ]
10 0ms 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 = 'testimonial_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;[ Date: 2022-01-15 02:22:43 - Database: website_rsbin - User: developer - Application: [unknown] - Bind query: yes ]
11 0ms 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 = 'post' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'));[ Date: 2022-01-15 02:22:43 - Database: website_rsbin - User: developer - Application: [unknown] - Bind query: yes ]
12 0ms 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 = 'dokter_v' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;[ Date: 2022-01-15 02:22:43 - Database: db_rsbin_running - User: developer - Application: [unknown] - Bind query: yes ]
13 0ms 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 = 'social_media' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;[ Date: 2022-01-15 02:22:43 - Database: website_rsbin - User: developer - Application: [unknown] - Bind query: yes ]
14 0ms 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 = 'metadata' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;[ Date: 2022-01-15 02:22:43 - Database: website_rsbin - User: developer - Application: [unknown] - Bind query: yes ]
15 0ms 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 = 'kategori_gallery' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;[ Date: 2022-01-15 02:22:43 - Database: website_rsbin - User: developer - Application: [unknown] - Bind query: yes ]
16 0ms 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 = 'gallery' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;[ Date: 2022-01-15 02:22:43 - Database: website_rsbin - User: developer - Application: [unknown] - Bind query: yes ]
17 0ms 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 = 'kategori_gallery' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'));[ Date: 2022-01-15 02:22:43 - Database: website_rsbin - User: developer - Application: [unknown] - Bind query: yes ]
18 0ms SELECT * FROM "static_page" "t" WHERE LOWER(nama_static_page) LIKE '%beranda%' LIMIT 1;[ Date: 2022-01-15 02:22:43 - Database: website_rsbin - User: developer - Application: [unknown] - Bind query: yes ]
19 0ms 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 = 'sub_menu' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;[ Date: 2022-01-15 02:22:43 - Database: website_rsbin - User: developer - Application: [unknown] - Bind query: yes ]
20 0ms 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 = 'jabatan_m' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;[ Date: 2022-01-15 02:22:43 - Database: db_rsbin_running - User: developer - Application: [unknown] - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 23ms 16 0ms 10ms 1ms 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 > ? and not a.attisdropped and a.attrelid = ( select oid from pg_catalog.pg_class where relname = ? and relnamespace = ( select oid from pg_catalog.pg_namespace where nspname = ?)) order by a.attnum;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 15 01 1 10ms 10ms 02 15 12ms 0ms [ User: developer - Total duration: 23ms - Times executed: 16 ]
[ Application: [unknown] - Total duration: 23ms - Times executed: 16 ]
-
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-15 01:23:12 Duration: 10ms 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 = 'slider_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;
Date: 2022-01-15 02:22:42 Duration: 3ms Database: website_rsbin 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 = 'post' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;
Date: 2022-01-15 02:22:43 Duration: 1ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
2 12ms 16 0ms 8ms 0ms 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 (...) union all select pc.relname, null, case when indisprimary then ? else ? end, pi.indrelid, indkey from pg_catalog.pg_class pc, pg_catalog.pg_index pi where pc.oid = pi.indexrelid and exists ( select ? 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 = ? and c.contype in (...))) as sub where relid = ( select oid from pg_catalog.pg_class where relname = ? and relnamespace = ( select oid from pg_catalog.pg_namespace where nspname = ?));Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 15 01 1 8ms 8ms 02 15 3ms 0ms [ User: developer - Total duration: 12ms - Times executed: 16 ]
[ Application: [unknown] - Total duration: 12ms - Times executed: 16 ]
-
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-15 01:23:12 Duration: 8ms 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 = 'slider_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'));
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin 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-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown] Bind query: yes
3 0ms 2 0ms 0ms 0ms select * from "static_page" "t" where lower(nama_static_page) like ? limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 15 02 2 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]
-
SELECT * FROM "static_page" "t" WHERE LOWER(nama_static_page) LIKE '%beranda%' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "static_page" "t" WHERE LOWER(nama_static_page) LIKE '%beranda%' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
4 0ms 15 0ms 0ms 0ms select attnum, attname from pg_catalog.pg_attribute where attrelid = ( select oid from pg_catalog.pg_class where relname = ? and relnamespace = ( select oid from pg_catalog.pg_namespace where nspname = ?)) and attnum in (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 15 01 1 0ms 0ms 02 14 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 15 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 15 ]
-
SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid = ( SELECT oid FROM pg_catalog.pg_class WHERE relname = 'mitra_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) AND attnum IN (1);
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin 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 = 'profil_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) AND attnum IN (1);
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin 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 = 'menu' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) AND attnum IN (1);
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
5 0ms 3 0ms 0ms 0ms set names ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 15 01 1 0ms 0ms 02 2 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 3 ]
-
SET NAMES 'utf8';
Date: 2022-01-15 02:22:42 Duration: 0ms Database: website_rsbin User: developer Application: [unknown]
-
SET NAMES 'utf8';
Date: 2022-01-15 01:23:12 Duration: 0ms Database: db_rscms_running User: developer Application: [unknown]
-
SET NAMES 'utf8';
Date: 2022-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown]
6 0ms 8 0ms 0ms 0ms select * from "sub_menu" "t" where "t"."sub_menu_aktif" = ? and "t"."menu_id" = ? order by urutan_sub_menu;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 15 02 8 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 8 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 8 ]
-
SELECT * FROM "sub_menu" "t" WHERE "t"."sub_menu_aktif" = 't' AND "t"."menu_id" = '12' ORDER BY urutan_sub_menu;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "sub_menu" "t" WHERE "t"."sub_menu_aktif" = 't' AND "t"."menu_id" = '16' ORDER BY urutan_sub_menu;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "sub_menu" "t" WHERE "t"."sub_menu_aktif" = 't' AND "t"."menu_id" = '4' ORDER BY urutan_sub_menu;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
7 0ms 1 0ms 0ms 0ms select * from "post" "t" order by post_id desc limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "post" "t" ORDER BY post_id desc LIMIT 4;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
8 0ms 1 0ms 0ms 0ms select * from "mitra_s" "t";Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "mitra_s" "t";
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
9 0ms 3 0ms 0ms 0ms select * from "profil_s" "t" where "t"."profilperusahaan_id" = ? limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 15 02 3 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 3 ]
-
SELECT * FROM "profil_s" "t" WHERE "t"."profilperusahaan_id" = 4 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "profil_s" "t" WHERE "t"."profilperusahaan_id" = 4 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "profil_s" "t" WHERE "t"."profilperusahaan_id" = 4 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
10 0ms 1 0ms 0ms 0ms select * from "fitur_s" "t" order by fitur_id desc limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "fitur_s" "t" ORDER BY fitur_id desc LIMIT 4;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
11 0ms 1 0ms 0ms 0ms select * from "kategori_gallery" "t" where "t"."kategori_gallery_aktif" = ? order by kategori_gallery_id desc;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "kategori_gallery" "t" WHERE "t"."kategori_gallery_aktif" = 't' ORDER BY kategori_gallery_id desc;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
12 0ms 1 0ms 0ms 0ms select * from "menu" "t" where "t"."menu_aktif" = ? order by urutan_menu;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "menu" "t" WHERE "t"."menu_aktif" = 't' ORDER BY urutan_menu;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
13 0ms 3 0ms 0ms 0ms select * from "metadata" "t" where nama_metadata = ? limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 15 02 3 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 3 ]
-
SELECT * FROM "metadata" "t" WHERE nama_metadata = 'keywords' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "metadata" "t" WHERE nama_metadata = 'description' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "metadata" "t" WHERE nama_metadata = 'author' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
14 0ms 2 0ms 0ms 0ms select * from "slider_s" "t";Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 15 02 2 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]
-
SELECT * FROM "slider_s" "t";
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "slider_s" "t";
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
15 0ms 1 0ms 0ms 0ms select * from "gallery" "t" where "t"."gallery_aktif" = ? order by gallery_id desc;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "gallery" "t" WHERE "t"."gallery_aktif" = 't' ORDER BY gallery_id desc;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
16 0ms 1 0ms 0ms 0ms select * from "profilrumahsakit_m" "t" where "t"."profilrs_id" = ? limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 15 01 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "profilrumahsakit_m" "t" WHERE "t"."profilrs_id" = 1 LIMIT 1;
Date: 2022-01-15 01:23:12 Duration: 0ms Database: db_rscms_running User: developer Application: [unknown] Bind query: yes
17 0ms 2 0ms 0ms 0ms select * from "social_media" "t" where "t"."social_media_aktif" = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 15 02 2 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]
-
SELECT * FROM "social_media" "t" WHERE "t"."social_media_aktif" = 't';
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "social_media" "t" WHERE "t"."social_media_aktif" = 't';
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
18 0ms 1 0ms 0ms 0ms select * from "dokter_v" "t" limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "dokter_v" "t" LIMIT 4;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown] Bind query: yes
19 0ms 2 0ms 0ms 0ms select * from "static_page" "t" where header_static_page = ? limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 15 02 2 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]
-
SELECT * FROM "static_page" "t" WHERE header_static_page = 'about' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "static_page" "t" WHERE header_static_page = 'opening_testimonial' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
20 0ms 4 0ms 0ms 0ms select * from "jabatan_m" "t" where "t"."jabatan_id" = ? limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 15 02 4 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 4 ]
-
SELECT * FROM "jabatan_m" "t" WHERE "t"."jabatan_id" = 29 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "jabatan_m" "t" WHERE "t"."jabatan_id" = 116 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "jabatan_m" "t" WHERE "t"."jabatan_id" = 23 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown] Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 16 23ms 0ms 10ms 1ms 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 > ? and not a.attisdropped and a.attrelid = ( select oid from pg_catalog.pg_class where relname = ? and relnamespace = ( select oid from pg_catalog.pg_namespace where nspname = ?)) order by a.attnum;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 15 01 1 10ms 10ms 02 15 12ms 0ms [ User: developer - Total duration: 23ms - Times executed: 16 ]
[ Application: [unknown] - Total duration: 23ms - Times executed: 16 ]
-
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-15 01:23:12 Duration: 10ms 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 = 'slider_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;
Date: 2022-01-15 02:22:42 Duration: 3ms Database: website_rsbin 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 = 'post' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;
Date: 2022-01-15 02:22:43 Duration: 1ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
2 16 12ms 0ms 8ms 0ms 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 (...) union all select pc.relname, null, case when indisprimary then ? else ? end, pi.indrelid, indkey from pg_catalog.pg_class pc, pg_catalog.pg_index pi where pc.oid = pi.indexrelid and exists ( select ? 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 = ? and c.contype in (...))) as sub where relid = ( select oid from pg_catalog.pg_class where relname = ? and relnamespace = ( select oid from pg_catalog.pg_namespace where nspname = ?));Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 15 01 1 8ms 8ms 02 15 3ms 0ms [ User: developer - Total duration: 12ms - Times executed: 16 ]
[ Application: [unknown] - Total duration: 12ms - Times executed: 16 ]
-
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-15 01:23:12 Duration: 8ms 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 = 'slider_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'));
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin 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-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown] Bind query: yes
3 15 0ms 0ms 0ms 0ms select attnum, attname from pg_catalog.pg_attribute where attrelid = ( select oid from pg_catalog.pg_class where relname = ? and relnamespace = ( select oid from pg_catalog.pg_namespace where nspname = ?)) and attnum in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 15 01 1 0ms 0ms 02 14 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 15 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 15 ]
-
SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid = ( SELECT oid FROM pg_catalog.pg_class WHERE relname = 'mitra_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) AND attnum IN (1);
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin 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 = 'profil_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) AND attnum IN (1);
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin 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 = 'menu' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) AND attnum IN (1);
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
4 8 0ms 0ms 0ms 0ms select * from "sub_menu" "t" where "t"."sub_menu_aktif" = ? and "t"."menu_id" = ? order by urutan_sub_menu;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 15 02 8 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 8 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 8 ]
-
SELECT * FROM "sub_menu" "t" WHERE "t"."sub_menu_aktif" = 't' AND "t"."menu_id" = '12' ORDER BY urutan_sub_menu;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "sub_menu" "t" WHERE "t"."sub_menu_aktif" = 't' AND "t"."menu_id" = '16' ORDER BY urutan_sub_menu;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "sub_menu" "t" WHERE "t"."sub_menu_aktif" = 't' AND "t"."menu_id" = '4' ORDER BY urutan_sub_menu;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
5 4 0ms 0ms 0ms 0ms select * from "jabatan_m" "t" where "t"."jabatan_id" = ? limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 15 02 4 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 4 ]
-
SELECT * FROM "jabatan_m" "t" WHERE "t"."jabatan_id" = 29 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "jabatan_m" "t" WHERE "t"."jabatan_id" = 116 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "jabatan_m" "t" WHERE "t"."jabatan_id" = 23 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown] Bind query: yes
6 3 0ms 0ms 0ms 0ms set names ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 15 01 1 0ms 0ms 02 2 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 3 ]
-
SET NAMES 'utf8';
Date: 2022-01-15 02:22:42 Duration: 0ms Database: website_rsbin User: developer Application: [unknown]
-
SET NAMES 'utf8';
Date: 2022-01-15 01:23:12 Duration: 0ms Database: db_rscms_running User: developer Application: [unknown]
-
SET NAMES 'utf8';
Date: 2022-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown]
7 3 0ms 0ms 0ms 0ms select * from "profil_s" "t" where "t"."profilperusahaan_id" = ? limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 15 02 3 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 3 ]
-
SELECT * FROM "profil_s" "t" WHERE "t"."profilperusahaan_id" = 4 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "profil_s" "t" WHERE "t"."profilperusahaan_id" = 4 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "profil_s" "t" WHERE "t"."profilperusahaan_id" = 4 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
8 3 0ms 0ms 0ms 0ms select * from "metadata" "t" where nama_metadata = ? limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 15 02 3 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 3 ]
-
SELECT * FROM "metadata" "t" WHERE nama_metadata = 'keywords' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "metadata" "t" WHERE nama_metadata = 'description' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "metadata" "t" WHERE nama_metadata = 'author' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
9 2 0ms 0ms 0ms 0ms select * from "static_page" "t" where lower(nama_static_page) like ? limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 15 02 2 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]
-
SELECT * FROM "static_page" "t" WHERE LOWER(nama_static_page) LIKE '%beranda%' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "static_page" "t" WHERE LOWER(nama_static_page) LIKE '%beranda%' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
10 2 0ms 0ms 0ms 0ms select * from "slider_s" "t";Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 15 02 2 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]
-
SELECT * FROM "slider_s" "t";
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "slider_s" "t";
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
11 2 0ms 0ms 0ms 0ms select * from "social_media" "t" where "t"."social_media_aktif" = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 15 02 2 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]
-
SELECT * FROM "social_media" "t" WHERE "t"."social_media_aktif" = 't';
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "social_media" "t" WHERE "t"."social_media_aktif" = 't';
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
12 2 0ms 0ms 0ms 0ms select * from "static_page" "t" where header_static_page = ? limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 15 02 2 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]
-
SELECT * FROM "static_page" "t" WHERE header_static_page = 'about' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "static_page" "t" WHERE header_static_page = 'opening_testimonial' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
13 1 0ms 0ms 0ms 0ms select * from "post" "t" order by post_id desc limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "post" "t" ORDER BY post_id desc LIMIT 4;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
14 1 0ms 0ms 0ms 0ms select * from "mitra_s" "t";Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "mitra_s" "t";
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
15 1 0ms 0ms 0ms 0ms select * from "fitur_s" "t" order by fitur_id desc limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "fitur_s" "t" ORDER BY fitur_id desc LIMIT 4;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
16 1 0ms 0ms 0ms 0ms select * from "kategori_gallery" "t" where "t"."kategori_gallery_aktif" = ? order by kategori_gallery_id desc;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "kategori_gallery" "t" WHERE "t"."kategori_gallery_aktif" = 't' ORDER BY kategori_gallery_id desc;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
17 1 0ms 0ms 0ms 0ms select * from "menu" "t" where "t"."menu_aktif" = ? order by urutan_menu;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "menu" "t" WHERE "t"."menu_aktif" = 't' ORDER BY urutan_menu;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
18 1 0ms 0ms 0ms 0ms select * from "gallery" "t" where "t"."gallery_aktif" = ? order by gallery_id desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "gallery" "t" WHERE "t"."gallery_aktif" = 't' ORDER BY gallery_id desc;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
19 1 0ms 0ms 0ms 0ms select * from "profilrumahsakit_m" "t" where "t"."profilrs_id" = ? limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 15 01 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "profilrumahsakit_m" "t" WHERE "t"."profilrs_id" = 1 LIMIT 1;
Date: 2022-01-15 01:23:12 Duration: 0ms Database: db_rscms_running User: developer Application: [unknown] Bind query: yes
20 1 0ms 0ms 0ms 0ms select * from "dokter_v" "t" limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "dokter_v" "t" LIMIT 4;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown] Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 10ms 1ms 16 23ms 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 > ? and not a.attisdropped and a.attrelid = ( select oid from pg_catalog.pg_class where relname = ? and relnamespace = ( select oid from pg_catalog.pg_namespace where nspname = ?)) order by a.attnum;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 15 01 1 10ms 10ms 02 15 12ms 0ms [ User: developer - Total duration: 23ms - Times executed: 16 ]
[ Application: [unknown] - Total duration: 23ms - Times executed: 16 ]
-
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-15 01:23:12 Duration: 10ms 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 = 'slider_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;
Date: 2022-01-15 02:22:42 Duration: 3ms Database: website_rsbin 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 = 'post' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) ORDER BY a.attnum;
Date: 2022-01-15 02:22:43 Duration: 1ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
2 0ms 8ms 0ms 16 12ms 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 (...) union all select pc.relname, null, case when indisprimary then ? else ? end, pi.indrelid, indkey from pg_catalog.pg_class pc, pg_catalog.pg_index pi where pc.oid = pi.indexrelid and exists ( select ? 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 = ? and c.contype in (...))) as sub where relid = ( select oid from pg_catalog.pg_class where relname = ? and relnamespace = ( select oid from pg_catalog.pg_namespace where nspname = ?));Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 15 01 1 8ms 8ms 02 15 3ms 0ms [ User: developer - Total duration: 12ms - Times executed: 16 ]
[ Application: [unknown] - Total duration: 12ms - Times executed: 16 ]
-
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-15 01:23:12 Duration: 8ms 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 = 'slider_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public'));
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin 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-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown] Bind query: yes
3 0ms 0ms 0ms 1 0ms select * from "post" "t" order by post_id desc limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "post" "t" ORDER BY post_id desc LIMIT 4;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
4 0ms 0ms 0ms 1 0ms select * from "mitra_s" "t";Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "mitra_s" "t";
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
5 0ms 0ms 0ms 1 0ms select * from "fitur_s" "t" order by fitur_id desc limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "fitur_s" "t" ORDER BY fitur_id desc LIMIT 4;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
6 0ms 0ms 0ms 1 0ms select * from "kategori_gallery" "t" where "t"."kategori_gallery_aktif" = ? order by kategori_gallery_id desc;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "kategori_gallery" "t" WHERE "t"."kategori_gallery_aktif" = 't' ORDER BY kategori_gallery_id desc;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
7 0ms 0ms 0ms 1 0ms select * from "menu" "t" where "t"."menu_aktif" = ? order by urutan_menu;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "menu" "t" WHERE "t"."menu_aktif" = 't' ORDER BY urutan_menu;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
8 0ms 0ms 0ms 2 0ms select * from "static_page" "t" where lower(nama_static_page) like ? limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 15 02 2 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]
-
SELECT * FROM "static_page" "t" WHERE LOWER(nama_static_page) LIKE '%beranda%' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "static_page" "t" WHERE LOWER(nama_static_page) LIKE '%beranda%' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
9 0ms 0ms 0ms 1 0ms select * from "gallery" "t" where "t"."gallery_aktif" = ? order by gallery_id desc;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "gallery" "t" WHERE "t"."gallery_aktif" = 't' ORDER BY gallery_id desc;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
10 0ms 0ms 0ms 1 0ms select * from "profilrumahsakit_m" "t" where "t"."profilrs_id" = ? limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 15 01 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "profilrumahsakit_m" "t" WHERE "t"."profilrs_id" = 1 LIMIT 1;
Date: 2022-01-15 01:23:12 Duration: 0ms Database: db_rscms_running User: developer Application: [unknown] Bind query: yes
11 0ms 0ms 0ms 1 0ms select * from "dokter_v" "t" limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 15 02 1 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SELECT * FROM "dokter_v" "t" LIMIT 4;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown] Bind query: yes
12 0ms 0ms 0ms 3 0ms set names ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 15 01 1 0ms 0ms 02 2 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 3 ]
-
SET NAMES 'utf8';
Date: 2022-01-15 02:22:42 Duration: 0ms Database: website_rsbin User: developer Application: [unknown]
-
SET NAMES 'utf8';
Date: 2022-01-15 01:23:12 Duration: 0ms Database: db_rscms_running User: developer Application: [unknown]
-
SET NAMES 'utf8';
Date: 2022-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown]
13 0ms 0ms 0ms 3 0ms select * from "profil_s" "t" where "t"."profilperusahaan_id" = ? limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 15 02 3 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 3 ]
-
SELECT * FROM "profil_s" "t" WHERE "t"."profilperusahaan_id" = 4 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "profil_s" "t" WHERE "t"."profilperusahaan_id" = 4 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "profil_s" "t" WHERE "t"."profilperusahaan_id" = 4 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
14 0ms 0ms 0ms 2 0ms select * from "slider_s" "t";Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 15 02 2 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]
-
SELECT * FROM "slider_s" "t";
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "slider_s" "t";
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
15 0ms 0ms 0ms 3 0ms select * from "metadata" "t" where nama_metadata = ? limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 15 02 3 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 3 ]
-
SELECT * FROM "metadata" "t" WHERE nama_metadata = 'keywords' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "metadata" "t" WHERE nama_metadata = 'description' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "metadata" "t" WHERE nama_metadata = 'author' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
16 0ms 0ms 0ms 2 0ms select * from "social_media" "t" where "t"."social_media_aktif" = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 15 02 2 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]
-
SELECT * FROM "social_media" "t" WHERE "t"."social_media_aktif" = 't';
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "social_media" "t" WHERE "t"."social_media_aktif" = 't';
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
17 0ms 0ms 0ms 2 0ms select * from "static_page" "t" where header_static_page = ? limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 15 02 2 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]
-
SELECT * FROM "static_page" "t" WHERE header_static_page = 'about' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "static_page" "t" WHERE header_static_page = 'opening_testimonial' LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
18 0ms 0ms 0ms 8 0ms select * from "sub_menu" "t" where "t"."sub_menu_aktif" = ? and "t"."menu_id" = ? order by urutan_sub_menu;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 15 02 8 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 8 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 8 ]
-
SELECT * FROM "sub_menu" "t" WHERE "t"."sub_menu_aktif" = 't' AND "t"."menu_id" = '12' ORDER BY urutan_sub_menu;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "sub_menu" "t" WHERE "t"."sub_menu_aktif" = 't' AND "t"."menu_id" = '16' ORDER BY urutan_sub_menu;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "sub_menu" "t" WHERE "t"."sub_menu_aktif" = 't' AND "t"."menu_id" = '4' ORDER BY urutan_sub_menu;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
19 0ms 0ms 0ms 15 0ms select attnum, attname from pg_catalog.pg_attribute where attrelid = ( select oid from pg_catalog.pg_class where relname = ? and relnamespace = ( select oid from pg_catalog.pg_namespace where nspname = ?)) and attnum in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 15 01 1 0ms 0ms 02 14 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 15 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 15 ]
-
SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid = ( SELECT oid FROM pg_catalog.pg_class WHERE relname = 'mitra_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) AND attnum IN (1);
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin 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 = 'profil_s' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) AND attnum IN (1);
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin 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 = 'menu' AND relnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'public')) AND attnum IN (1);
Date: 2022-01-15 02:22:43 Duration: 0ms Database: website_rsbin User: developer Application: [unknown] Bind query: yes
20 0ms 0ms 0ms 4 0ms select * from "jabatan_m" "t" where "t"."jabatan_id" = ? limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 15 02 4 0ms 0ms [ User: developer - Total duration: 0ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 4 ]
-
SELECT * FROM "jabatan_m" "t" WHERE "t"."jabatan_id" = 29 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "jabatan_m" "t" WHERE "t"."jabatan_id" = 116 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown] Bind query: yes
-
SELECT * FROM "jabatan_m" "t" WHERE "t"."jabatan_id" = 23 LIMIT 1;
Date: 2022-01-15 02:22:43 Duration: 0ms Database: db_rsbin_running User: developer Application: [unknown] Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 4m24s 494,656 0ms 21ms 0ms ;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Jan 15 03 297 142ms 0ms 04 360 160ms 0ms 05 198 84ms 0ms 06 180 74ms 0ms 07 1,351 602ms 0ms 08 1,901 943ms 0ms 09 8,013 4s222ms 0ms 10 10,808 5s988ms 0ms 11 8,327 4s566ms 0ms 12 8,852 4s864ms 0ms 13 11,082 6s126ms 0ms 14 15,905 8s727ms 0ms 15 13,076 7s251ms 0ms 16 13,723 7s482ms 0ms 17 5,048 2s770ms 0ms 18 3,619 2s16ms 0ms 19 11,124 5s766ms 0ms 20 3,739 2s183ms 0ms 21 3,615 2s95ms 0ms 22 3,579 2s45ms 0ms 23 3,034 1s746ms 0ms Jan 15 00 180 82ms 0ms 01 180 81ms 0ms 02 180 84ms 0ms 03 339 151ms 0ms 04 360 161ms 0ms 05 360 164ms 0ms 06 1,440 726ms 0ms 07 10,468 5s102ms 0ms 08 29,618 14s476ms 0ms 09 41,522 22s18ms 0ms 10 79,934 45s162ms 0ms 11 57,758 31s355ms 0ms 12 29,648 15s176ms 0ms 13 34,708 19s94ms 0ms 14 33,216 18s16ms 0ms 15 29,346 15s322ms 0ms 16 3,834 1s731ms 0ms 17 7,554 3s394ms 0ms 18 5,514 2s480ms 0ms 19 360 166ms 0ms 20 306 139ms 0ms [ User: developer - Total duration: 15m - Times executed: 494656 ]
[ Application: [unknown] - Total duration: 15m - Times executed: 494656 ]
-
;
Date: 2022-01-14 10:49:55 Duration: 21ms Database: postgres User: db_rsrib_running Remote: developer
-
;
Date: 2022-01-14 15:05:16 Duration: 20ms Database: postgres User: db_rsrib_running Remote: developer
-
;
Date: 2022-01-14 10:35:43 Duration: 19ms Database: postgres User: db_rsrib_running Remote: developer
2 3m55s 533,161 0ms 14ms 0ms SELECT ;Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 03 198 99ms 0ms 04 241 120ms 0ms 05 140 69ms 0ms 06 120 54ms 0ms 07 1,284 541ms 0ms 08 1,396 697ms 0ms 09 5,750 2s949ms 0ms 10 7,886 4s119ms 0ms 11 5,580 2s992ms 0ms 12 6,624 3s391ms 0ms 13 11,884 5s351ms 0ms 14 21,028 8s664ms 0ms 15 10,024 5s155ms 0ms 16 12,384 6s156ms 0ms 17 3,428 1s891ms 0ms 18 2,944 1s515ms 0ms 19 12,912 6s115ms 0ms 20 3,110 1s603ms 0ms 21 2,420 1s376ms 0ms 22 2,398 1s339ms 0ms 23 2,164 1s158ms 0ms 00 120 59ms 0ms 01 120 59ms 0ms 02 120 57ms 0ms 03 226 111ms 0ms 04 240 116ms 0ms 05 240 121ms 0ms 06 1,316 597ms 0ms 07 14,236 5s530ms 0ms 08 37,628 14s704ms 0ms 09 41,844 19s68ms 0ms 10 118,078 47s884ms 0ms 11 76,176 31s17ms 0ms 12 27,916 12s479ms 0ms 13 28,128 14s299ms 0ms 14 28,640 13s827ms 0ms 15 32,108 14s134ms 0ms 16 2,596 1s285ms 0ms 17 5,308 2s498ms 0ms 18 3,676 1s776ms 0ms 19 240 123ms 0ms 20 210 112ms 0ms 21 24 12ms 0ms 22 24 13ms 0ms 01 2 4ms 2ms 02 30 22ms 0ms [ User: developer - Total duration: 6m19s - Times executed: 533161 ]
[ Application: [unknown] - Total duration: 6m19s - Times executed: 533161 ]
-
SELECT ;
Date: 2022-01-15 02:22:42 Duration: 14ms Database: postgres User: website_rsbin Remote: developer
-
SELECT ;
Date: 2022-01-14 10:26:49 Duration: 12ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT ;
Date: 2022-01-14 08:50:08 Duration: 11ms Database: postgres User: db_ihospital Remote: developer
3 45s617ms 28,899 1ms 10ms 1ms SELECT * FROM chat WHERE (chat_to = 'meiny' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 13 400 645ms 1ms 14 2,222 3s514ms 1ms 15 2,313 3s609ms 1ms 16 1,182 1s836ms 1ms 17 1,125 1s722ms 1ms 18 1,006 1s567ms 1ms 19 1,139 1s847ms 1ms 20 1,142 1s829ms 1ms 21 1,145 1s803ms 1ms 22 1,133 1s760ms 1ms 23 932 1s456ms 1ms 09 1,936 3s102ms 1ms 10 3,590 5s765ms 1ms 11 2,124 3s394ms 1ms 12 2,394 3s727ms 1ms 13 2,076 3s247ms 1ms 14 1,940 3s35ms 1ms 15 1,100 1s750ms 1ms [ User: developer - Total duration: 1s866ms - Times executed: 28899 ]
[ Application: [unknown] - Total duration: 1s866ms - Times executed: 28899 ]
-
SELECT * FROM chat WHERE (chat_to = 'meiny' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 15:24:25 Duration: 10ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'meiny' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 14:44:39 Duration: 5ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'meiny' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 14:24:56 Duration: 5ms Database: postgres User: db_rsrib_running Remote: developer
4 38s263ms 29,593 0ms 7ms 1ms SELECT * FROM chat WHERE (chat_to = 'sysadmin' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 03 68 83ms 1ms 04 60 71ms 1ms 05 6 6ms 1ms 14 6 7ms 1ms 15 220 345ms 1ms 16 1,887 3s2ms 1ms 17 197 319ms 1ms 18 86 103ms 1ms 19 1,662 2s50ms 1ms 20 39 50ms 1ms 23 16 19ms 1ms 08 2,762 3s712ms 1ms 09 2,394 2s917ms 1ms 10 2,394 2s927ms 1ms 11 1,400 1s685ms 1ms 12 1,370 1s597ms 1ms 13 4,244 5s865ms 1ms 14 4,432 6s25ms 1ms 15 2,238 2s780ms 1ms 17 2,394 2s719ms 1ms 18 1,718 1s971ms 1ms [ User: developer - Total duration: 1s294ms - Times executed: 29593 ]
[ Application: [unknown] - Total duration: 1s294ms - Times executed: 29593 ]
-
SELECT * FROM chat WHERE (chat_to = 'sysadmin' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 13:15:18 Duration: 7ms Database: postgres User: db_ihospital Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'sysadmin' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 16:14:10 Duration: 7ms Database: postgres User: db_rsbri_simulasi Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'sysadmin' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 08:35:00 Duration: 6ms Database: postgres User: db_ihospital Remote: developer
5 33s618ms 21,066 1ms 10ms 1ms SELECT * FROM chat WHERE (chat_to = 'sartono' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 09 2,472 3s981ms 1ms 10 7,026 11s386ms 1ms 11 4,108 6s574ms 1ms 13 2,992 4s732ms 1ms 14 3,678 5s690ms 1ms 15 790 1s252ms 1ms [ User: developer - Total duration: 1s367ms - Times executed: 21066 ]
[ Application: [unknown] - Total duration: 1s367ms - Times executed: 21066 ]
-
SELECT * FROM chat WHERE (chat_to = 'sartono' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 11:15:22 Duration: 10ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'sartono' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 10:47:26 Duration: 7ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'sartono' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 13:56:57 Duration: 5ms Database: postgres User: db_rsrib_running Remote: developer
6 32s667ms 104,652 0ms 9ms 0ms SELECT "pegawai"."pegawai_id" AS "t1_c0", "pegawai"."kabupaten_id" AS "t1_c1", "pegawai"."pangkat_id" AS "t1_c2", "pegawai"."pendkualifikasi_id" AS "t1_c3", "pegawai"."kelurahan_id" AS "t1_c4", "pegawai"."kelompokpegawai_id" AS "t1_c5", "pegawai"."profilrs_id" AS "t1_c6", "pegawai"."pengangkatantphl_id" AS "t1_c7", "pegawai"."pendidikan_id" AS "t1_c8", "pegawai"."loginpemakai_id" AS "t1_c9", "pegawai"."kecamatan_id" AS "t1_c10", "pegawai"."registerpensiun_id" AS "t1_c11", "pegawai"."suku_id" AS "t1_c12", "pegawai"."jabatan_id" AS "t1_c13", "pegawai"."esselon_id" AS "t1_c14", "pegawai"."propinsi_id" AS "t1_c15", "pegawai"."statuskepemilikanrumah_id" AS "t1_c16", "pegawai"."gelarbelakang_id" AS "t1_c17", "pegawai"."nomorindukpegawai" AS "t1_c18", "pegawai"."no_kartupegawainegerisipil" AS "t1_c19", "pegawai"."no_karis_karsu" AS "t1_c20", "pegawai"."no_taspen" AS "t1_c21", "pegawai"."no_askes" AS "t1_c22", "pegawai"."jenisidentitas" AS "t1_c23", "pegawai"."noidentitas" AS "t1_c24", "pegawai"."gelardepan" AS "t1_c25", "pegawai"."nama_pegawai" AS "t1_c26", "pegawai"."nama_keluarga" AS "t1_c27", "pegawai"."tempatlahir_pegawai" AS "t1_c28", "pegawai"."tgl_lahirpegawai" AS "t1_c29", "pegawai"."jeniskelamin" AS "t1_c30", "pegawai"."statusperkawinan" AS "t1_c31", "pegawai"."alamat_pegawai" AS "t1_c32", "pegawai"."agama" AS "t1_c33", "pegawai"."golongandarah" AS "t1_c34", "pegawai"."rhesus" AS "t1_c35", "pegawai"."alamatemail" AS "t1_c36", "pegawai"."notelp_pegawai" AS "t1_c37", "pegawai"."nomobile_pegawai" AS "t1_c38", "pegawai"."warganegara_pegawai" AS "t1_c39", "pegawai"."jeniswaktukerja" AS "t1_c40", "pegawai"."kelompokjabatan" AS "t1_c41", "pegawai"."kategoripegawai" AS "t1_c42", "pegawai"."kategoripegawaiasal" AS "t1_c43", "pegawai"."photopegawai" AS "t1_c44", "pegawai"."nofingerprint" AS "t1_c45", "pegawai"."tinggibadan" AS "t1_c46", "pegawai"."beratbadan" AS "t1_c47", "pegawai"."kemampuanbahasa" AS "t1_c48", "pegawai"."warnakulit" AS "t1_c49", "pegawai"."nip_lama" AS "t1_c50", "pegawai"."no_rekening" AS "t1_c51", "pegawai"."bank_no_rekening" AS "t1_c52", "pegawai"."npwp" AS "t1_c53", "pegawai"."tglditerima" AS "t1_c54", "pegawai"."tglberhenti" AS "t1_c55", "pegawai"."gajipokok" AS "t1_c56", "pegawai"."create_time" AS "t1_c57", "pegawai"."update_time" AS "t1_c58", "pegawai"."create_loginpemakai_id" AS "t1_c59", "pegawai"."update_loginpemakai_id" AS "t1_c60", "pegawai"."create_ruangan" AS "t1_c61", "pegawai"."pegawai_aktif" AS "t1_c62", "pegawai"."suratizinpraktek" AS "t1_c63", "pegawai"."unit_perusahaan" AS "t1_c64", "pegawai"."golonganpegawai_id" AS "t1_c65", "pegawai"."deskripsi" AS "t1_c66", "pegawai"."garis_latitude" AS "t1_c67", "pegawai"."garis_longitude" AS "t1_c68", "pegawai"."jenistenagamedis_id" AS "t1_c69", "pegawai"."tglmasaaktifpeg" AS "t1_c70", "pegawai"."tglmasaaktifpeg_sd" AS "t1_c71", "pegawai"."shift_id" AS "t1_c72", "pegawai"."surattandaregistrasi" AS "t1_c73", "pegawai"."file_kontrak" AS "t1_c74", "pegawai"."masa_str" AS "t1_c75", "pegawai"."masa_sip" AS "t1_c76", "pegawai"."masa_tenagasehat" AS "t1_c77", "pegawai"."masa_medis" AS "t1_c78", "pegawai"."unitkerja_id" AS "t1_c79", "pegawai"."nominal_sip" AS "t1_c80", "pegawai"."alamat_pegawai_ktp" AS "t1_c81", "pegawai"."tglterdaftarnpwp" AS "t1_c82", "pegawai"."tglcatatkepnpwp" AS "t1_c83", "pegawai"."alamatnpwp" AS "t1_c84", "pegawai"."no_bpjs_kesehatan" AS "t1_c85", "pegawai"."no_bpjs_ketenagakerjaan" AS "t1_c86", "pegawai"."ptkp_id" AS "t1_c87", "pegawai"."kode_objekpajak" AS "t1_c88", "pegawai"."keterampilan" AS "t1_c89", "pegawai"."keahlian" AS "t1_c90", "pegawai"."minat" AS "t1_c91", "pegawai"."bakat" AS "t1_c92", "pegawai"."kode_negara" AS "t1_c93", "pegawai"."jenispegawai" AS "t1_c94", "pegawai"."inisial" AS "t1_c95", "pegawai"."cabang_pegawai" AS "t1_c96", "pegawai"."golongan" AS "t1_c97", "pegawai"."grade" AS "t1_c98", "pegawai"."cabang_bank" AS "t1_c99", "pegawai"."atasnama" AS "t1_c100", "pegawai"."tglmasuk_bpjs_ketenagakerjaan" AS "t1_c101", "pegawai"."tglkeluar_bpjs_ketenagakerjaan" AS "t1_c102", "pegawai"."nopeserta_asuransi" AS "t1_c103", "pegawai"."kodegroup_komponen" AS "t1_c104", "pegawai"."levelakses" AS "t1_c105", "pegawai"."nokontrak" AS "t1_c106", "pegawai"."keterangankontrak" AS "t1_c107", "pegawai"."metode_pph_21" AS "t1_c108", "pegawai"."tglpenghapusankemenkes" AS "t1_c109", "pegawai"."pegawaipenghapusankemenkes" AS "t1_c110", "pegawai"."tglpengiriminkemenkes" AS "t1_c111", "pegawai"."pegawaipengirimkemenkes" AS "t1_c112", "pegawai"."tglubahpengirimankemenkes" AS "t1_c113", "pegawai"."pegawaiubahpengirimankemenkes" AS "t1_c114", "pegawai"."logpenghapusandatakemenkes" AS "t1_c115", "pegawai"."statuspengiriman" AS "t1_c116", "pegawai"."nomorijazah" AS "t1_c117", "pegawai"."universitas_sekolah" AS "t1_c118", "pegawai"."kodedokter_bpjs" AS "t1_c119", "pegawai"."spesialissubspesialis_id" AS "t1_c120" FROM "pegawai_m" "pegawai" WHERE ("pegawai"."pegawai_id" = $1);Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 08 122 33ms 0ms 09 1,453 425ms 0ms 10 1,818 535ms 0ms 11 122 35ms 0ms 13 4,434 1s374ms 0ms 14 6,911 2s133ms 0ms 09 11,936 3s701ms 0ms 10 32,092 10s341ms 0ms 11 5,698 1s816ms 0ms 13 7,076 2s129ms 0ms 14 15,648 4s677ms 0ms 15 17,342 5s463ms 0ms [ User: developer - Total duration: 3s512ms - Times executed: 104652 ]
[ Application: [unknown] - Total duration: 3s512ms - Times executed: 104652 ]
-
SELECT "pegawai"."pegawai_id" AS "t1_c0", "pegawai"."kabupaten_id" AS "t1_c1", "pegawai"."pangkat_id" AS "t1_c2", "pegawai"."pendkualifikasi_id" AS "t1_c3", "pegawai"."kelurahan_id" AS "t1_c4", "pegawai"."kelompokpegawai_id" AS "t1_c5", "pegawai"."profilrs_id" AS "t1_c6", "pegawai"."pengangkatantphl_id" AS "t1_c7", "pegawai"."pendidikan_id" AS "t1_c8", "pegawai"."loginpemakai_id" AS "t1_c9", "pegawai"."kecamatan_id" AS "t1_c10", "pegawai"."registerpensiun_id" AS "t1_c11", "pegawai"."suku_id" AS "t1_c12", "pegawai"."jabatan_id" AS "t1_c13", "pegawai"."esselon_id" AS "t1_c14", "pegawai"."propinsi_id" AS "t1_c15", "pegawai"."statuskepemilikanrumah_id" AS "t1_c16", "pegawai"."gelarbelakang_id" AS "t1_c17", "pegawai"."nomorindukpegawai" AS "t1_c18", "pegawai"."no_kartupegawainegerisipil" AS "t1_c19", "pegawai"."no_karis_karsu" AS "t1_c20", "pegawai"."no_taspen" AS "t1_c21", "pegawai"."no_askes" AS "t1_c22", "pegawai"."jenisidentitas" AS "t1_c23", "pegawai"."noidentitas" AS "t1_c24", "pegawai"."gelardepan" AS "t1_c25", "pegawai"."nama_pegawai" AS "t1_c26", "pegawai"."nama_keluarga" AS "t1_c27", "pegawai"."tempatlahir_pegawai" AS "t1_c28", "pegawai"."tgl_lahirpegawai" AS "t1_c29", "pegawai"."jeniskelamin" AS "t1_c30", "pegawai"."statusperkawinan" AS "t1_c31", "pegawai"."alamat_pegawai" AS "t1_c32", "pegawai"."agama" AS "t1_c33", "pegawai"."golongandarah" AS "t1_c34", "pegawai"."rhesus" AS "t1_c35", "pegawai"."alamatemail" AS "t1_c36", "pegawai"."notelp_pegawai" AS "t1_c37", "pegawai"."nomobile_pegawai" AS "t1_c38", "pegawai"."warganegara_pegawai" AS "t1_c39", "pegawai"."jeniswaktukerja" AS "t1_c40", "pegawai"."kelompokjabatan" AS "t1_c41", "pegawai"."kategoripegawai" AS "t1_c42", "pegawai"."kategoripegawaiasal" AS "t1_c43", "pegawai"."photopegawai" AS "t1_c44", "pegawai"."nofingerprint" AS "t1_c45", "pegawai"."tinggibadan" AS "t1_c46", "pegawai"."beratbadan" AS "t1_c47", "pegawai"."kemampuanbahasa" AS "t1_c48", "pegawai"."warnakulit" AS "t1_c49", "pegawai"."nip_lama" AS "t1_c50", "pegawai"."no_rekening" AS "t1_c51", "pegawai"."bank_no_rekening" AS "t1_c52", "pegawai"."npwp" AS "t1_c53", "pegawai"."tglditerima" AS "t1_c54", "pegawai"."tglberhenti" AS "t1_c55", "pegawai"."gajipokok" AS "t1_c56", "pegawai"."create_time" AS "t1_c57", "pegawai"."update_time" AS "t1_c58", "pegawai"."create_loginpemakai_id" AS "t1_c59", "pegawai"."update_loginpemakai_id" AS "t1_c60", "pegawai"."create_ruangan" AS "t1_c61", "pegawai"."pegawai_aktif" AS "t1_c62", "pegawai"."suratizinpraktek" AS "t1_c63", "pegawai"."unit_perusahaan" AS "t1_c64", "pegawai"."golonganpegawai_id" AS "t1_c65", "pegawai"."deskripsi" AS "t1_c66", "pegawai"."garis_latitude" AS "t1_c67", "pegawai"."garis_longitude" AS "t1_c68", "pegawai"."jenistenagamedis_id" AS "t1_c69", "pegawai"."tglmasaaktifpeg" AS "t1_c70", "pegawai"."tglmasaaktifpeg_sd" AS "t1_c71", "pegawai"."shift_id" AS "t1_c72", "pegawai"."surattandaregistrasi" AS "t1_c73", "pegawai"."file_kontrak" AS "t1_c74", "pegawai"."masa_str" AS "t1_c75", "pegawai"."masa_sip" AS "t1_c76", "pegawai"."masa_tenagasehat" AS "t1_c77", "pegawai"."masa_medis" AS "t1_c78", "pegawai"."unitkerja_id" AS "t1_c79", "pegawai"."nominal_sip" AS "t1_c80", "pegawai"."alamat_pegawai_ktp" AS "t1_c81", "pegawai"."tglterdaftarnpwp" AS "t1_c82", "pegawai"."tglcatatkepnpwp" AS "t1_c83", "pegawai"."alamatnpwp" AS "t1_c84", "pegawai"."no_bpjs_kesehatan" AS "t1_c85", "pegawai"."no_bpjs_ketenagakerjaan" AS "t1_c86", "pegawai"."ptkp_id" AS "t1_c87", "pegawai"."kode_objekpajak" AS "t1_c88", "pegawai"."keterampilan" AS "t1_c89", "pegawai"."keahlian" AS "t1_c90", "pegawai"."minat" AS "t1_c91", "pegawai"."bakat" AS "t1_c92", "pegawai"."kode_negara" AS "t1_c93", "pegawai"."jenispegawai" AS "t1_c94", "pegawai"."inisial" AS "t1_c95", "pegawai"."cabang_pegawai" AS "t1_c96", "pegawai"."golongan" AS "t1_c97", "pegawai"."grade" AS "t1_c98", "pegawai"."cabang_bank" AS "t1_c99", "pegawai"."atasnama" AS "t1_c100", "pegawai"."tglmasuk_bpjs_ketenagakerjaan" AS "t1_c101", "pegawai"."tglkeluar_bpjs_ketenagakerjaan" AS "t1_c102", "pegawai"."nopeserta_asuransi" AS "t1_c103", "pegawai"."kodegroup_komponen" AS "t1_c104", "pegawai"."levelakses" AS "t1_c105", "pegawai"."nokontrak" AS "t1_c106", "pegawai"."keterangankontrak" AS "t1_c107", "pegawai"."metode_pph_21" AS "t1_c108", "pegawai"."tglpenghapusankemenkes" AS "t1_c109", "pegawai"."pegawaipenghapusankemenkes" AS "t1_c110", "pegawai"."tglpengiriminkemenkes" AS "t1_c111", "pegawai"."pegawaipengirimkemenkes" AS "t1_c112", "pegawai"."tglubahpengirimankemenkes" AS "t1_c113", "pegawai"."pegawaiubahpengirimankemenkes" AS "t1_c114", "pegawai"."logpenghapusandatakemenkes" AS "t1_c115", "pegawai"."statuspengiriman" AS "t1_c116", "pegawai"."nomorijazah" AS "t1_c117", "pegawai"."universitas_sekolah" AS "t1_c118", "pegawai"."kodedokter_bpjs" AS "t1_c119", "pegawai"."spesialissubspesialis_id" AS "t1_c120" FROM "pegawai_m" "pegawai" WHERE ("pegawai"."pegawai_id" = $1);
Date: 2022-01-14 14:53:44 Duration: 9ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT "pegawai"."pegawai_id" AS "t1_c0", "pegawai"."kabupaten_id" AS "t1_c1", "pegawai"."pangkat_id" AS "t1_c2", "pegawai"."pendkualifikasi_id" AS "t1_c3", "pegawai"."kelurahan_id" AS "t1_c4", "pegawai"."kelompokpegawai_id" AS "t1_c5", "pegawai"."profilrs_id" AS "t1_c6", "pegawai"."pengangkatantphl_id" AS "t1_c7", "pegawai"."pendidikan_id" AS "t1_c8", "pegawai"."loginpemakai_id" AS "t1_c9", "pegawai"."kecamatan_id" AS "t1_c10", "pegawai"."registerpensiun_id" AS "t1_c11", "pegawai"."suku_id" AS "t1_c12", "pegawai"."jabatan_id" AS "t1_c13", "pegawai"."esselon_id" AS "t1_c14", "pegawai"."propinsi_id" AS "t1_c15", "pegawai"."statuskepemilikanrumah_id" AS "t1_c16", "pegawai"."gelarbelakang_id" AS "t1_c17", "pegawai"."nomorindukpegawai" AS "t1_c18", "pegawai"."no_kartupegawainegerisipil" AS "t1_c19", "pegawai"."no_karis_karsu" AS "t1_c20", "pegawai"."no_taspen" AS "t1_c21", "pegawai"."no_askes" AS "t1_c22", "pegawai"."jenisidentitas" AS "t1_c23", "pegawai"."noidentitas" AS "t1_c24", "pegawai"."gelardepan" AS "t1_c25", "pegawai"."nama_pegawai" AS "t1_c26", "pegawai"."nama_keluarga" AS "t1_c27", "pegawai"."tempatlahir_pegawai" AS "t1_c28", "pegawai"."tgl_lahirpegawai" AS "t1_c29", "pegawai"."jeniskelamin" AS "t1_c30", "pegawai"."statusperkawinan" AS "t1_c31", "pegawai"."alamat_pegawai" AS "t1_c32", "pegawai"."agama" AS "t1_c33", "pegawai"."golongandarah" AS "t1_c34", "pegawai"."rhesus" AS "t1_c35", "pegawai"."alamatemail" AS "t1_c36", "pegawai"."notelp_pegawai" AS "t1_c37", "pegawai"."nomobile_pegawai" AS "t1_c38", "pegawai"."warganegara_pegawai" AS "t1_c39", "pegawai"."jeniswaktukerja" AS "t1_c40", "pegawai"."kelompokjabatan" AS "t1_c41", "pegawai"."kategoripegawai" AS "t1_c42", "pegawai"."kategoripegawaiasal" AS "t1_c43", "pegawai"."photopegawai" AS "t1_c44", "pegawai"."nofingerprint" AS "t1_c45", "pegawai"."tinggibadan" AS "t1_c46", "pegawai"."beratbadan" AS "t1_c47", "pegawai"."kemampuanbahasa" AS "t1_c48", "pegawai"."warnakulit" AS "t1_c49", "pegawai"."nip_lama" AS "t1_c50", "pegawai"."no_rekening" AS "t1_c51", "pegawai"."bank_no_rekening" AS "t1_c52", "pegawai"."npwp" AS "t1_c53", "pegawai"."tglditerima" AS "t1_c54", "pegawai"."tglberhenti" AS "t1_c55", "pegawai"."gajipokok" AS "t1_c56", "pegawai"."create_time" AS "t1_c57", "pegawai"."update_time" AS "t1_c58", "pegawai"."create_loginpemakai_id" AS "t1_c59", "pegawai"."update_loginpemakai_id" AS "t1_c60", "pegawai"."create_ruangan" AS "t1_c61", "pegawai"."pegawai_aktif" AS "t1_c62", "pegawai"."suratizinpraktek" AS "t1_c63", "pegawai"."unit_perusahaan" AS "t1_c64", "pegawai"."golonganpegawai_id" AS "t1_c65", "pegawai"."deskripsi" AS "t1_c66", "pegawai"."garis_latitude" AS "t1_c67", "pegawai"."garis_longitude" AS "t1_c68", "pegawai"."jenistenagamedis_id" AS "t1_c69", "pegawai"."tglmasaaktifpeg" AS "t1_c70", "pegawai"."tglmasaaktifpeg_sd" AS "t1_c71", "pegawai"."shift_id" AS "t1_c72", "pegawai"."surattandaregistrasi" AS "t1_c73", "pegawai"."file_kontrak" AS "t1_c74", "pegawai"."masa_str" AS "t1_c75", "pegawai"."masa_sip" AS "t1_c76", "pegawai"."masa_tenagasehat" AS "t1_c77", "pegawai"."masa_medis" AS "t1_c78", "pegawai"."unitkerja_id" AS "t1_c79", "pegawai"."nominal_sip" AS "t1_c80", "pegawai"."alamat_pegawai_ktp" AS "t1_c81", "pegawai"."tglterdaftarnpwp" AS "t1_c82", "pegawai"."tglcatatkepnpwp" AS "t1_c83", "pegawai"."alamatnpwp" AS "t1_c84", "pegawai"."no_bpjs_kesehatan" AS "t1_c85", "pegawai"."no_bpjs_ketenagakerjaan" AS "t1_c86", "pegawai"."ptkp_id" AS "t1_c87", "pegawai"."kode_objekpajak" AS "t1_c88", "pegawai"."keterampilan" AS "t1_c89", "pegawai"."keahlian" AS "t1_c90", "pegawai"."minat" AS "t1_c91", "pegawai"."bakat" AS "t1_c92", "pegawai"."kode_negara" AS "t1_c93", "pegawai"."jenispegawai" AS "t1_c94", "pegawai"."inisial" AS "t1_c95", "pegawai"."cabang_pegawai" AS "t1_c96", "pegawai"."golongan" AS "t1_c97", "pegawai"."grade" AS "t1_c98", "pegawai"."cabang_bank" AS "t1_c99", "pegawai"."atasnama" AS "t1_c100", "pegawai"."tglmasuk_bpjs_ketenagakerjaan" AS "t1_c101", "pegawai"."tglkeluar_bpjs_ketenagakerjaan" AS "t1_c102", "pegawai"."nopeserta_asuransi" AS "t1_c103", "pegawai"."kodegroup_komponen" AS "t1_c104", "pegawai"."levelakses" AS "t1_c105", "pegawai"."nokontrak" AS "t1_c106", "pegawai"."keterangankontrak" AS "t1_c107", "pegawai"."metode_pph_21" AS "t1_c108", "pegawai"."tglpenghapusankemenkes" AS "t1_c109", "pegawai"."pegawaipenghapusankemenkes" AS "t1_c110", "pegawai"."tglpengiriminkemenkes" AS "t1_c111", "pegawai"."pegawaipengirimkemenkes" AS "t1_c112", "pegawai"."tglubahpengirimankemenkes" AS "t1_c113", "pegawai"."pegawaiubahpengirimankemenkes" AS "t1_c114", "pegawai"."logpenghapusandatakemenkes" AS "t1_c115", "pegawai"."statuspengiriman" AS "t1_c116", "pegawai"."nomorijazah" AS "t1_c117", "pegawai"."universitas_sekolah" AS "t1_c118", "pegawai"."kodedokter_bpjs" AS "t1_c119", "pegawai"."spesialissubspesialis_id" AS "t1_c120" FROM "pegawai_m" "pegawai" WHERE ("pegawai"."pegawai_id" = $1);
Date: 2022-01-14 10:46:55 Duration: 5ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT "pegawai"."pegawai_id" AS "t1_c0", "pegawai"."kabupaten_id" AS "t1_c1", "pegawai"."pangkat_id" AS "t1_c2", "pegawai"."pendkualifikasi_id" AS "t1_c3", "pegawai"."kelurahan_id" AS "t1_c4", "pegawai"."kelompokpegawai_id" AS "t1_c5", "pegawai"."profilrs_id" AS "t1_c6", "pegawai"."pengangkatantphl_id" AS "t1_c7", "pegawai"."pendidikan_id" AS "t1_c8", "pegawai"."loginpemakai_id" AS "t1_c9", "pegawai"."kecamatan_id" AS "t1_c10", "pegawai"."registerpensiun_id" AS "t1_c11", "pegawai"."suku_id" AS "t1_c12", "pegawai"."jabatan_id" AS "t1_c13", "pegawai"."esselon_id" AS "t1_c14", "pegawai"."propinsi_id" AS "t1_c15", "pegawai"."statuskepemilikanrumah_id" AS "t1_c16", "pegawai"."gelarbelakang_id" AS "t1_c17", "pegawai"."nomorindukpegawai" AS "t1_c18", "pegawai"."no_kartupegawainegerisipil" AS "t1_c19", "pegawai"."no_karis_karsu" AS "t1_c20", "pegawai"."no_taspen" AS "t1_c21", "pegawai"."no_askes" AS "t1_c22", "pegawai"."jenisidentitas" AS "t1_c23", "pegawai"."noidentitas" AS "t1_c24", "pegawai"."gelardepan" AS "t1_c25", "pegawai"."nama_pegawai" AS "t1_c26", "pegawai"."nama_keluarga" AS "t1_c27", "pegawai"."tempatlahir_pegawai" AS "t1_c28", "pegawai"."tgl_lahirpegawai" AS "t1_c29", "pegawai"."jeniskelamin" AS "t1_c30", "pegawai"."statusperkawinan" AS "t1_c31", "pegawai"."alamat_pegawai" AS "t1_c32", "pegawai"."agama" AS "t1_c33", "pegawai"."golongandarah" AS "t1_c34", "pegawai"."rhesus" AS "t1_c35", "pegawai"."alamatemail" AS "t1_c36", "pegawai"."notelp_pegawai" AS "t1_c37", "pegawai"."nomobile_pegawai" AS "t1_c38", "pegawai"."warganegara_pegawai" AS "t1_c39", "pegawai"."jeniswaktukerja" AS "t1_c40", "pegawai"."kelompokjabatan" AS "t1_c41", "pegawai"."kategoripegawai" AS "t1_c42", "pegawai"."kategoripegawaiasal" AS "t1_c43", "pegawai"."photopegawai" AS "t1_c44", "pegawai"."nofingerprint" AS "t1_c45", "pegawai"."tinggibadan" AS "t1_c46", "pegawai"."beratbadan" AS "t1_c47", "pegawai"."kemampuanbahasa" AS "t1_c48", "pegawai"."warnakulit" AS "t1_c49", "pegawai"."nip_lama" AS "t1_c50", "pegawai"."no_rekening" AS "t1_c51", "pegawai"."bank_no_rekening" AS "t1_c52", "pegawai"."npwp" AS "t1_c53", "pegawai"."tglditerima" AS "t1_c54", "pegawai"."tglberhenti" AS "t1_c55", "pegawai"."gajipokok" AS "t1_c56", "pegawai"."create_time" AS "t1_c57", "pegawai"."update_time" AS "t1_c58", "pegawai"."create_loginpemakai_id" AS "t1_c59", "pegawai"."update_loginpemakai_id" AS "t1_c60", "pegawai"."create_ruangan" AS "t1_c61", "pegawai"."pegawai_aktif" AS "t1_c62", "pegawai"."suratizinpraktek" AS "t1_c63", "pegawai"."unit_perusahaan" AS "t1_c64", "pegawai"."golonganpegawai_id" AS "t1_c65", "pegawai"."deskripsi" AS "t1_c66", "pegawai"."garis_latitude" AS "t1_c67", "pegawai"."garis_longitude" AS "t1_c68", "pegawai"."jenistenagamedis_id" AS "t1_c69", "pegawai"."tglmasaaktifpeg" AS "t1_c70", "pegawai"."tglmasaaktifpeg_sd" AS "t1_c71", "pegawai"."shift_id" AS "t1_c72", "pegawai"."surattandaregistrasi" AS "t1_c73", "pegawai"."file_kontrak" AS "t1_c74", "pegawai"."masa_str" AS "t1_c75", "pegawai"."masa_sip" AS "t1_c76", "pegawai"."masa_tenagasehat" AS "t1_c77", "pegawai"."masa_medis" AS "t1_c78", "pegawai"."unitkerja_id" AS "t1_c79", "pegawai"."nominal_sip" AS "t1_c80", "pegawai"."alamat_pegawai_ktp" AS "t1_c81", "pegawai"."tglterdaftarnpwp" AS "t1_c82", "pegawai"."tglcatatkepnpwp" AS "t1_c83", "pegawai"."alamatnpwp" AS "t1_c84", "pegawai"."no_bpjs_kesehatan" AS "t1_c85", "pegawai"."no_bpjs_ketenagakerjaan" AS "t1_c86", "pegawai"."ptkp_id" AS "t1_c87", "pegawai"."kode_objekpajak" AS "t1_c88", "pegawai"."keterampilan" AS "t1_c89", "pegawai"."keahlian" AS "t1_c90", "pegawai"."minat" AS "t1_c91", "pegawai"."bakat" AS "t1_c92", "pegawai"."kode_negara" AS "t1_c93", "pegawai"."jenispegawai" AS "t1_c94", "pegawai"."inisial" AS "t1_c95", "pegawai"."cabang_pegawai" AS "t1_c96", "pegawai"."golongan" AS "t1_c97", "pegawai"."grade" AS "t1_c98", "pegawai"."cabang_bank" AS "t1_c99", "pegawai"."atasnama" AS "t1_c100", "pegawai"."tglmasuk_bpjs_ketenagakerjaan" AS "t1_c101", "pegawai"."tglkeluar_bpjs_ketenagakerjaan" AS "t1_c102", "pegawai"."nopeserta_asuransi" AS "t1_c103", "pegawai"."kodegroup_komponen" AS "t1_c104", "pegawai"."levelakses" AS "t1_c105", "pegawai"."nokontrak" AS "t1_c106", "pegawai"."keterangankontrak" AS "t1_c107", "pegawai"."metode_pph_21" AS "t1_c108", "pegawai"."tglpenghapusankemenkes" AS "t1_c109", "pegawai"."pegawaipenghapusankemenkes" AS "t1_c110", "pegawai"."tglpengiriminkemenkes" AS "t1_c111", "pegawai"."pegawaipengirimkemenkes" AS "t1_c112", "pegawai"."tglubahpengirimankemenkes" AS "t1_c113", "pegawai"."pegawaiubahpengirimankemenkes" AS "t1_c114", "pegawai"."logpenghapusandatakemenkes" AS "t1_c115", "pegawai"."statuspengiriman" AS "t1_c116", "pegawai"."nomorijazah" AS "t1_c117", "pegawai"."universitas_sekolah" AS "t1_c118", "pegawai"."kodedokter_bpjs" AS "t1_c119", "pegawai"."spesialissubspesialis_id" AS "t1_c120" FROM "pegawai_m" "pegawai" WHERE ("pegawai"."pegawai_id" = $1);
Date: 2022-01-14 10:01:30 Duration: 5ms Database: postgres User: db_rsrib_running Remote: developer
7 30s425ms 261,624 0ms 7ms 0ms SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE ;Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 03 99 12ms 0ms 04 120 13ms 0ms 05 70 7ms 0ms 06 60 6ms 0ms 07 635 67ms 0ms 08 698 82ms 0ms 09 2,857 337ms 0ms 10 3,919 462ms 0ms 11 2,790 335ms 0ms 12 3,300 397ms 0ms 13 5,837 704ms 0ms 14 10,356 1s155ms 0ms 15 4,992 611ms 0ms 16 6,140 737ms 0ms 17 1,714 213ms 0ms 18 1,456 175ms 0ms 19 6,309 763ms 0ms 20 1,547 193ms 0ms 21 1,210 160ms 0ms 22 1,199 152ms 0ms 23 1,082 136ms 0ms 00 60 7ms 0ms 01 60 7ms 0ms 02 60 7ms 0ms 03 113 13ms 0ms 04 120 14ms 0ms 05 120 14ms 0ms 06 658 79ms 0ms 07 7,002 772ms 0ms 08 18,514 2s25ms 0ms 09 20,548 2s480ms 0ms 10 57,162 6s620ms 0ms 11 37,056 4s215ms 0ms 12 13,778 1s563ms 0ms 13 13,950 1s685ms 0ms 14 14,150 1s650ms 0ms 15 15,828 1s823ms 0ms 16 1,298 157ms 0ms 17 2,652 309ms 0ms 18 1,838 216ms 0ms 19 120 15ms 0ms 20 104 12ms 0ms 21 12 1ms 0ms 22 12 1ms 0ms 23 4 0ms 0ms 01 1 0ms 0ms 02 14 1ms 0ms [ User: developer - Total duration: 7s591ms - Times executed: 261624 ]
[ Application: [unknown] - Total duration: 7s591ms - Times executed: 261624 ]
-
SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE ;
Date: 2022-01-14 15:28:29 Duration: 7ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE ;
Date: 2022-01-13 14:02:54 Duration: 4ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE ;
Date: 2022-01-13 14:14:33 Duration: 4ms Database: postgres User: db_rsrib_running Remote: developer
8 20s907ms 57,520 0ms 8ms 0ms SELECT "pegawai"."pegawai_id" AS "t1_c0", "pegawai"."kabupaten_id" AS "t1_c1", "pegawai"."pangkat_id" AS "t1_c2", "pegawai"."pendkualifikasi_id" AS "t1_c3", "pegawai"."kelurahan_id" AS "t1_c4", "pegawai"."kelompokpegawai_id" AS "t1_c5", "pegawai"."profilrs_id" AS "t1_c6", "pegawai"."pengangkatantphl_id" AS "t1_c7", "pegawai"."pendidikan_id" AS "t1_c8", "pegawai"."loginpemakai_id" AS "t1_c9", "pegawai"."kecamatan_id" AS "t1_c10", "pegawai"."registerpensiun_id" AS "t1_c11", "pegawai"."suku_id" AS "t1_c12", "pegawai"."jabatan_id" AS "t1_c13", "pegawai"."esselon_id" AS "t1_c14", "pegawai"."propinsi_id" AS "t1_c15", "pegawai"."statuskepemilikanrumah_id" AS "t1_c16", "pegawai"."gelarbelakang_id" AS "t1_c17", "pegawai"."nomorindukpegawai" AS "t1_c18", "pegawai"."no_kartupegawainegerisipil" AS "t1_c19", "pegawai"."no_karis_karsu" AS "t1_c20", "pegawai"."no_taspen" AS "t1_c21", "pegawai"."no_askes" AS "t1_c22", "pegawai"."jenisidentitas" AS "t1_c23", "pegawai"."noidentitas" AS "t1_c24", "pegawai"."gelardepan" AS "t1_c25", "pegawai"."nama_pegawai" AS "t1_c26", "pegawai"."nama_keluarga" AS "t1_c27", "pegawai"."tempatlahir_pegawai" AS "t1_c28", "pegawai"."tgl_lahirpegawai" AS "t1_c29", "pegawai"."jeniskelamin" AS "t1_c30", "pegawai"."statusperkawinan" AS "t1_c31", "pegawai"."alamat_pegawai" AS "t1_c32", "pegawai"."agama" AS "t1_c33", "pegawai"."golongandarah" AS "t1_c34", "pegawai"."rhesus" AS "t1_c35", "pegawai"."alamatemail" AS "t1_c36", "pegawai"."notelp_pegawai" AS "t1_c37", "pegawai"."nomobile_pegawai" AS "t1_c38", "pegawai"."warganegara_pegawai" AS "t1_c39", "pegawai"."jeniswaktukerja" AS "t1_c40", "pegawai"."kelompokjabatan" AS "t1_c41", "pegawai"."kategoripegawai" AS "t1_c42", "pegawai"."kategoripegawaiasal" AS "t1_c43", "pegawai"."photopegawai" AS "t1_c44", "pegawai"."nofingerprint" AS "t1_c45", "pegawai"."tinggibadan" AS "t1_c46", "pegawai"."beratbadan" AS "t1_c47", "pegawai"."kemampuanbahasa" AS "t1_c48", "pegawai"."warnakulit" AS "t1_c49", "pegawai"."nip_lama" AS "t1_c50", "pegawai"."no_rekening" AS "t1_c51", "pegawai"."bank_no_rekening" AS "t1_c52", "pegawai"."npwp" AS "t1_c53", "pegawai"."tglditerima" AS "t1_c54", "pegawai"."tglberhenti" AS "t1_c55", "pegawai"."gajipokok" AS "t1_c56", "pegawai"."create_time" AS "t1_c57", "pegawai"."update_time" AS "t1_c58", "pegawai"."create_loginpemakai_id" AS "t1_c59", "pegawai"."update_loginpemakai_id" AS "t1_c60", "pegawai"."create_ruangan" AS "t1_c61", "pegawai"."pegawai_aktif" AS "t1_c62", "pegawai"."suratizinpraktek" AS "t1_c63", "pegawai"."unit_perusahaan" AS "t1_c64", "pegawai"."golonganpegawai_id" AS "t1_c65", "pegawai"."deskripsi" AS "t1_c66", "pegawai"."garis_latitude" AS "t1_c67", "pegawai"."garis_longitude" AS "t1_c68", "pegawai"."jenistenagamedis_id" AS "t1_c69", "pegawai"."tglmasaaktifpeg" AS "t1_c70", "pegawai"."tglmasaaktifpeg_sd" AS "t1_c71", "pegawai"."shift_id" AS "t1_c72", "pegawai"."surattandaregistrasi" AS "t1_c73", "pegawai"."file_kontrak" AS "t1_c74", "pegawai"."masa_str" AS "t1_c75", "pegawai"."masa_sip" AS "t1_c76", "pegawai"."masa_tenagasehat" AS "t1_c77", "pegawai"."masa_medis" AS "t1_c78", "pegawai"."unitkerja_id" AS "t1_c79", "pegawai"."nominal_sip" AS "t1_c80", "pegawai"."alamat_pegawai_ktp" AS "t1_c81", "pegawai"."tglterdaftarnpwp" AS "t1_c82", "pegawai"."tglcatatkepnpwp" AS "t1_c83", "pegawai"."alamatnpwp" AS "t1_c84", "pegawai"."no_bpjs_kesehatan" AS "t1_c85", "pegawai"."no_bpjs_ketenagakerjaan" AS "t1_c86", "pegawai"."ptkp_id" AS "t1_c87", "pegawai"."kode_objekpajak" AS "t1_c88", "pegawai"."keterampilan" AS "t1_c89", "pegawai"."keahlian" AS "t1_c90", "pegawai"."minat" AS "t1_c91", "pegawai"."bakat" AS "t1_c92", "pegawai"."kode_negara" AS "t1_c93", "pegawai"."jenispegawai" AS "t1_c94", "pegawai"."inisial" AS "t1_c95", "pegawai"."cabang_pegawai" AS "t1_c96", "pegawai"."golongan" AS "t1_c97", "pegawai"."grade" AS "t1_c98", "pegawai"."cabang_bank" AS "t1_c99", "pegawai"."atasnama" AS "t1_c100", "pegawai"."tglmasuk_bpjs_ketenagakerjaan" AS "t1_c101", "pegawai"."tglkeluar_bpjs_ketenagakerjaan" AS "t1_c102", "pegawai"."nopeserta_asuransi" AS "t1_c103", "pegawai"."kodegroup_komponen" AS "t1_c104", "pegawai"."levelakses" AS "t1_c105", "pegawai"."nokontrak" AS "t1_c106", "pegawai"."keterangankontrak" AS "t1_c107", "pegawai"."metode_pph_21" AS "t1_c108", "pegawai"."tglpenghapusankemenkes" AS "t1_c109", "pegawai"."pegawaipenghapusankemenkes" AS "t1_c110", "pegawai"."tglpengiriminkemenkes" AS "t1_c111", "pegawai"."pegawaipengirimkemenkes" AS "t1_c112", "pegawai"."tglubahpengirimankemenkes" AS "t1_c113", "pegawai"."pegawaiubahpengirimankemenkes" AS "t1_c114", "pegawai"."logpenghapusandatakemenkes" AS "t1_c115", "pegawai"."statuspengiriman" AS "t1_c116", "pegawai"."dokterprioritas" AS "t1_c117", "pegawai"."kodedokter_bpjs" AS "t1_c118", "pegawai"."kabupaten_domisili_id" AS "t1_c119", "pegawai"."kecamatan_domisili_id" AS "t1_c120", "pegawai"."kelurahan_domisili_id" AS "t1_c121", "pegawai"."propinsi_domisili_id" AS "t1_c122", "pegawai"."kodejabatan_id" AS "t1_c123", "pegawai"."subkelompok_id" AS "t1_c124", "pegawai"."jabatanfungsional_id" AS "t1_c125", "pegawai"."pensiun_usia" AS "t1_c126", "pegawai"."pensiun_tmt" AS "t1_c127", "pegawai"."pensiun_tgledit" AS "t1_c128", "pegawai"."jurusan_id" AS "t1_c129", "pegawai"."eselon_id" AS "t1_c130", "pegawai"."smf_id" AS "t1_c131", "pegawai"."divisi_id" AS "t1_c132", "pegawai"."is_domisili_ktp" AS "t1_c133", "pegawai"."spesialissubspesialis_id" AS "t1_c134" FROM "pegawai_m" "pegawai" WHERE ("pegawai"."pegawai_id" = $1);Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 07 111 35ms 0ms 10 52 18ms 0ms 12 247 83ms 0ms 13 676 253ms 0ms 14 1,328 464ms 0ms 15 593 209ms 0ms 16 1,289 449ms 0ms 18 53 18ms 0ms 19 1,025 384ms 0ms 20 339 117ms 0ms 23 123 48ms 0ms 07 2,330 857ms 0ms 08 5,354 1s914ms 0ms 09 1,394 514ms 0ms 10 19,524 7s244ms 0ms 11 16,812 6s109ms 0ms 12 5,756 2s5ms 0ms 14 464 157ms 0ms 17 50 22ms 0ms [ User: developer - Total duration: 2s201ms - Times executed: 57520 ]
[ Application: [unknown] - Total duration: 2s201ms - Times executed: 57520 ]
-
SELECT "pegawai"."pegawai_id" AS "t1_c0", "pegawai"."kabupaten_id" AS "t1_c1", "pegawai"."pangkat_id" AS "t1_c2", "pegawai"."pendkualifikasi_id" AS "t1_c3", "pegawai"."kelurahan_id" AS "t1_c4", "pegawai"."kelompokpegawai_id" AS "t1_c5", "pegawai"."profilrs_id" AS "t1_c6", "pegawai"."pengangkatantphl_id" AS "t1_c7", "pegawai"."pendidikan_id" AS "t1_c8", "pegawai"."loginpemakai_id" AS "t1_c9", "pegawai"."kecamatan_id" AS "t1_c10", "pegawai"."registerpensiun_id" AS "t1_c11", "pegawai"."suku_id" AS "t1_c12", "pegawai"."jabatan_id" AS "t1_c13", "pegawai"."esselon_id" AS "t1_c14", "pegawai"."propinsi_id" AS "t1_c15", "pegawai"."statuskepemilikanrumah_id" AS "t1_c16", "pegawai"."gelarbelakang_id" AS "t1_c17", "pegawai"."nomorindukpegawai" AS "t1_c18", "pegawai"."no_kartupegawainegerisipil" AS "t1_c19", "pegawai"."no_karis_karsu" AS "t1_c20", "pegawai"."no_taspen" AS "t1_c21", "pegawai"."no_askes" AS "t1_c22", "pegawai"."jenisidentitas" AS "t1_c23", "pegawai"."noidentitas" AS "t1_c24", "pegawai"."gelardepan" AS "t1_c25", "pegawai"."nama_pegawai" AS "t1_c26", "pegawai"."nama_keluarga" AS "t1_c27", "pegawai"."tempatlahir_pegawai" AS "t1_c28", "pegawai"."tgl_lahirpegawai" AS "t1_c29", "pegawai"."jeniskelamin" AS "t1_c30", "pegawai"."statusperkawinan" AS "t1_c31", "pegawai"."alamat_pegawai" AS "t1_c32", "pegawai"."agama" AS "t1_c33", "pegawai"."golongandarah" AS "t1_c34", "pegawai"."rhesus" AS "t1_c35", "pegawai"."alamatemail" AS "t1_c36", "pegawai"."notelp_pegawai" AS "t1_c37", "pegawai"."nomobile_pegawai" AS "t1_c38", "pegawai"."warganegara_pegawai" AS "t1_c39", "pegawai"."jeniswaktukerja" AS "t1_c40", "pegawai"."kelompokjabatan" AS "t1_c41", "pegawai"."kategoripegawai" AS "t1_c42", "pegawai"."kategoripegawaiasal" AS "t1_c43", "pegawai"."photopegawai" AS "t1_c44", "pegawai"."nofingerprint" AS "t1_c45", "pegawai"."tinggibadan" AS "t1_c46", "pegawai"."beratbadan" AS "t1_c47", "pegawai"."kemampuanbahasa" AS "t1_c48", "pegawai"."warnakulit" AS "t1_c49", "pegawai"."nip_lama" AS "t1_c50", "pegawai"."no_rekening" AS "t1_c51", "pegawai"."bank_no_rekening" AS "t1_c52", "pegawai"."npwp" AS "t1_c53", "pegawai"."tglditerima" AS "t1_c54", "pegawai"."tglberhenti" AS "t1_c55", "pegawai"."gajipokok" AS "t1_c56", "pegawai"."create_time" AS "t1_c57", "pegawai"."update_time" AS "t1_c58", "pegawai"."create_loginpemakai_id" AS "t1_c59", "pegawai"."update_loginpemakai_id" AS "t1_c60", "pegawai"."create_ruangan" AS "t1_c61", "pegawai"."pegawai_aktif" AS "t1_c62", "pegawai"."suratizinpraktek" AS "t1_c63", "pegawai"."unit_perusahaan" AS "t1_c64", "pegawai"."golonganpegawai_id" AS "t1_c65", "pegawai"."deskripsi" AS "t1_c66", "pegawai"."garis_latitude" AS "t1_c67", "pegawai"."garis_longitude" AS "t1_c68", "pegawai"."jenistenagamedis_id" AS "t1_c69", "pegawai"."tglmasaaktifpeg" AS "t1_c70", "pegawai"."tglmasaaktifpeg_sd" AS "t1_c71", "pegawai"."shift_id" AS "t1_c72", "pegawai"."surattandaregistrasi" AS "t1_c73", "pegawai"."file_kontrak" AS "t1_c74", "pegawai"."masa_str" AS "t1_c75", "pegawai"."masa_sip" AS "t1_c76", "pegawai"."masa_tenagasehat" AS "t1_c77", "pegawai"."masa_medis" AS "t1_c78", "pegawai"."unitkerja_id" AS "t1_c79", "pegawai"."nominal_sip" AS "t1_c80", "pegawai"."alamat_pegawai_ktp" AS "t1_c81", "pegawai"."tglterdaftarnpwp" AS "t1_c82", "pegawai"."tglcatatkepnpwp" AS "t1_c83", "pegawai"."alamatnpwp" AS "t1_c84", "pegawai"."no_bpjs_kesehatan" AS "t1_c85", "pegawai"."no_bpjs_ketenagakerjaan" AS "t1_c86", "pegawai"."ptkp_id" AS "t1_c87", "pegawai"."kode_objekpajak" AS "t1_c88", "pegawai"."keterampilan" AS "t1_c89", "pegawai"."keahlian" AS "t1_c90", "pegawai"."minat" AS "t1_c91", "pegawai"."bakat" AS "t1_c92", "pegawai"."kode_negara" AS "t1_c93", "pegawai"."jenispegawai" AS "t1_c94", "pegawai"."inisial" AS "t1_c95", "pegawai"."cabang_pegawai" AS "t1_c96", "pegawai"."golongan" AS "t1_c97", "pegawai"."grade" AS "t1_c98", "pegawai"."cabang_bank" AS "t1_c99", "pegawai"."atasnama" AS "t1_c100", "pegawai"."tglmasuk_bpjs_ketenagakerjaan" AS "t1_c101", "pegawai"."tglkeluar_bpjs_ketenagakerjaan" AS "t1_c102", "pegawai"."nopeserta_asuransi" AS "t1_c103", "pegawai"."kodegroup_komponen" AS "t1_c104", "pegawai"."levelakses" AS "t1_c105", "pegawai"."nokontrak" AS "t1_c106", "pegawai"."keterangankontrak" AS "t1_c107", "pegawai"."metode_pph_21" AS "t1_c108", "pegawai"."tglpenghapusankemenkes" AS "t1_c109", "pegawai"."pegawaipenghapusankemenkes" AS "t1_c110", "pegawai"."tglpengiriminkemenkes" AS "t1_c111", "pegawai"."pegawaipengirimkemenkes" AS "t1_c112", "pegawai"."tglubahpengirimankemenkes" AS "t1_c113", "pegawai"."pegawaiubahpengirimankemenkes" AS "t1_c114", "pegawai"."logpenghapusandatakemenkes" AS "t1_c115", "pegawai"."statuspengiriman" AS "t1_c116", "pegawai"."dokterprioritas" AS "t1_c117", "pegawai"."kodedokter_bpjs" AS "t1_c118", "pegawai"."kabupaten_domisili_id" AS "t1_c119", "pegawai"."kecamatan_domisili_id" AS "t1_c120", "pegawai"."kelurahan_domisili_id" AS "t1_c121", "pegawai"."propinsi_domisili_id" AS "t1_c122", "pegawai"."kodejabatan_id" AS "t1_c123", "pegawai"."subkelompok_id" AS "t1_c124", "pegawai"."jabatanfungsional_id" AS "t1_c125", "pegawai"."pensiun_usia" AS "t1_c126", "pegawai"."pensiun_tmt" AS "t1_c127", "pegawai"."pensiun_tgledit" AS "t1_c128", "pegawai"."jurusan_id" AS "t1_c129", "pegawai"."eselon_id" AS "t1_c130", "pegawai"."smf_id" AS "t1_c131", "pegawai"."divisi_id" AS "t1_c132", "pegawai"."is_domisili_ktp" AS "t1_c133", "pegawai"."spesialissubspesialis_id" AS "t1_c134" FROM "pegawai_m" "pegawai" WHERE ("pegawai"."pegawai_id" = $1);
Date: 2022-01-14 11:41:55 Duration: 8ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT "pegawai"."pegawai_id" AS "t1_c0", "pegawai"."kabupaten_id" AS "t1_c1", "pegawai"."pangkat_id" AS "t1_c2", "pegawai"."pendkualifikasi_id" AS "t1_c3", "pegawai"."kelurahan_id" AS "t1_c4", "pegawai"."kelompokpegawai_id" AS "t1_c5", "pegawai"."profilrs_id" AS "t1_c6", "pegawai"."pengangkatantphl_id" AS "t1_c7", "pegawai"."pendidikan_id" AS "t1_c8", "pegawai"."loginpemakai_id" AS "t1_c9", "pegawai"."kecamatan_id" AS "t1_c10", "pegawai"."registerpensiun_id" AS "t1_c11", "pegawai"."suku_id" AS "t1_c12", "pegawai"."jabatan_id" AS "t1_c13", "pegawai"."esselon_id" AS "t1_c14", "pegawai"."propinsi_id" AS "t1_c15", "pegawai"."statuskepemilikanrumah_id" AS "t1_c16", "pegawai"."gelarbelakang_id" AS "t1_c17", "pegawai"."nomorindukpegawai" AS "t1_c18", "pegawai"."no_kartupegawainegerisipil" AS "t1_c19", "pegawai"."no_karis_karsu" AS "t1_c20", "pegawai"."no_taspen" AS "t1_c21", "pegawai"."no_askes" AS "t1_c22", "pegawai"."jenisidentitas" AS "t1_c23", "pegawai"."noidentitas" AS "t1_c24", "pegawai"."gelardepan" AS "t1_c25", "pegawai"."nama_pegawai" AS "t1_c26", "pegawai"."nama_keluarga" AS "t1_c27", "pegawai"."tempatlahir_pegawai" AS "t1_c28", "pegawai"."tgl_lahirpegawai" AS "t1_c29", "pegawai"."jeniskelamin" AS "t1_c30", "pegawai"."statusperkawinan" AS "t1_c31", "pegawai"."alamat_pegawai" AS "t1_c32", "pegawai"."agama" AS "t1_c33", "pegawai"."golongandarah" AS "t1_c34", "pegawai"."rhesus" AS "t1_c35", "pegawai"."alamatemail" AS "t1_c36", "pegawai"."notelp_pegawai" AS "t1_c37", "pegawai"."nomobile_pegawai" AS "t1_c38", "pegawai"."warganegara_pegawai" AS "t1_c39", "pegawai"."jeniswaktukerja" AS "t1_c40", "pegawai"."kelompokjabatan" AS "t1_c41", "pegawai"."kategoripegawai" AS "t1_c42", "pegawai"."kategoripegawaiasal" AS "t1_c43", "pegawai"."photopegawai" AS "t1_c44", "pegawai"."nofingerprint" AS "t1_c45", "pegawai"."tinggibadan" AS "t1_c46", "pegawai"."beratbadan" AS "t1_c47", "pegawai"."kemampuanbahasa" AS "t1_c48", "pegawai"."warnakulit" AS "t1_c49", "pegawai"."nip_lama" AS "t1_c50", "pegawai"."no_rekening" AS "t1_c51", "pegawai"."bank_no_rekening" AS "t1_c52", "pegawai"."npwp" AS "t1_c53", "pegawai"."tglditerima" AS "t1_c54", "pegawai"."tglberhenti" AS "t1_c55", "pegawai"."gajipokok" AS "t1_c56", "pegawai"."create_time" AS "t1_c57", "pegawai"."update_time" AS "t1_c58", "pegawai"."create_loginpemakai_id" AS "t1_c59", "pegawai"."update_loginpemakai_id" AS "t1_c60", "pegawai"."create_ruangan" AS "t1_c61", "pegawai"."pegawai_aktif" AS "t1_c62", "pegawai"."suratizinpraktek" AS "t1_c63", "pegawai"."unit_perusahaan" AS "t1_c64", "pegawai"."golonganpegawai_id" AS "t1_c65", "pegawai"."deskripsi" AS "t1_c66", "pegawai"."garis_latitude" AS "t1_c67", "pegawai"."garis_longitude" AS "t1_c68", "pegawai"."jenistenagamedis_id" AS "t1_c69", "pegawai"."tglmasaaktifpeg" AS "t1_c70", "pegawai"."tglmasaaktifpeg_sd" AS "t1_c71", "pegawai"."shift_id" AS "t1_c72", "pegawai"."surattandaregistrasi" AS "t1_c73", "pegawai"."file_kontrak" AS "t1_c74", "pegawai"."masa_str" AS "t1_c75", "pegawai"."masa_sip" AS "t1_c76", "pegawai"."masa_tenagasehat" AS "t1_c77", "pegawai"."masa_medis" AS "t1_c78", "pegawai"."unitkerja_id" AS "t1_c79", "pegawai"."nominal_sip" AS "t1_c80", "pegawai"."alamat_pegawai_ktp" AS "t1_c81", "pegawai"."tglterdaftarnpwp" AS "t1_c82", "pegawai"."tglcatatkepnpwp" AS "t1_c83", "pegawai"."alamatnpwp" AS "t1_c84", "pegawai"."no_bpjs_kesehatan" AS "t1_c85", "pegawai"."no_bpjs_ketenagakerjaan" AS "t1_c86", "pegawai"."ptkp_id" AS "t1_c87", "pegawai"."kode_objekpajak" AS "t1_c88", "pegawai"."keterampilan" AS "t1_c89", "pegawai"."keahlian" AS "t1_c90", "pegawai"."minat" AS "t1_c91", "pegawai"."bakat" AS "t1_c92", "pegawai"."kode_negara" AS "t1_c93", "pegawai"."jenispegawai" AS "t1_c94", "pegawai"."inisial" AS "t1_c95", "pegawai"."cabang_pegawai" AS "t1_c96", "pegawai"."golongan" AS "t1_c97", "pegawai"."grade" AS "t1_c98", "pegawai"."cabang_bank" AS "t1_c99", "pegawai"."atasnama" AS "t1_c100", "pegawai"."tglmasuk_bpjs_ketenagakerjaan" AS "t1_c101", "pegawai"."tglkeluar_bpjs_ketenagakerjaan" AS "t1_c102", "pegawai"."nopeserta_asuransi" AS "t1_c103", "pegawai"."kodegroup_komponen" AS "t1_c104", "pegawai"."levelakses" AS "t1_c105", "pegawai"."nokontrak" AS "t1_c106", "pegawai"."keterangankontrak" AS "t1_c107", "pegawai"."metode_pph_21" AS "t1_c108", "pegawai"."tglpenghapusankemenkes" AS "t1_c109", "pegawai"."pegawaipenghapusankemenkes" AS "t1_c110", "pegawai"."tglpengiriminkemenkes" AS "t1_c111", "pegawai"."pegawaipengirimkemenkes" AS "t1_c112", "pegawai"."tglubahpengirimankemenkes" AS "t1_c113", "pegawai"."pegawaiubahpengirimankemenkes" AS "t1_c114", "pegawai"."logpenghapusandatakemenkes" AS "t1_c115", "pegawai"."statuspengiriman" AS "t1_c116", "pegawai"."dokterprioritas" AS "t1_c117", "pegawai"."kodedokter_bpjs" AS "t1_c118", "pegawai"."kabupaten_domisili_id" AS "t1_c119", "pegawai"."kecamatan_domisili_id" AS "t1_c120", "pegawai"."kelurahan_domisili_id" AS "t1_c121", "pegawai"."propinsi_domisili_id" AS "t1_c122", "pegawai"."kodejabatan_id" AS "t1_c123", "pegawai"."subkelompok_id" AS "t1_c124", "pegawai"."jabatanfungsional_id" AS "t1_c125", "pegawai"."pensiun_usia" AS "t1_c126", "pegawai"."pensiun_tmt" AS "t1_c127", "pegawai"."pensiun_tgledit" AS "t1_c128", "pegawai"."jurusan_id" AS "t1_c129", "pegawai"."eselon_id" AS "t1_c130", "pegawai"."smf_id" AS "t1_c131", "pegawai"."divisi_id" AS "t1_c132", "pegawai"."is_domisili_ktp" AS "t1_c133", "pegawai"."spesialissubspesialis_id" AS "t1_c134" FROM "pegawai_m" "pegawai" WHERE ("pegawai"."pegawai_id" = $1);
Date: 2022-01-14 11:22:06 Duration: 7ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT "pegawai"."pegawai_id" AS "t1_c0", "pegawai"."kabupaten_id" AS "t1_c1", "pegawai"."pangkat_id" AS "t1_c2", "pegawai"."pendkualifikasi_id" AS "t1_c3", "pegawai"."kelurahan_id" AS "t1_c4", "pegawai"."kelompokpegawai_id" AS "t1_c5", "pegawai"."profilrs_id" AS "t1_c6", "pegawai"."pengangkatantphl_id" AS "t1_c7", "pegawai"."pendidikan_id" AS "t1_c8", "pegawai"."loginpemakai_id" AS "t1_c9", "pegawai"."kecamatan_id" AS "t1_c10", "pegawai"."registerpensiun_id" AS "t1_c11", "pegawai"."suku_id" AS "t1_c12", "pegawai"."jabatan_id" AS "t1_c13", "pegawai"."esselon_id" AS "t1_c14", "pegawai"."propinsi_id" AS "t1_c15", "pegawai"."statuskepemilikanrumah_id" AS "t1_c16", "pegawai"."gelarbelakang_id" AS "t1_c17", "pegawai"."nomorindukpegawai" AS "t1_c18", "pegawai"."no_kartupegawainegerisipil" AS "t1_c19", "pegawai"."no_karis_karsu" AS "t1_c20", "pegawai"."no_taspen" AS "t1_c21", "pegawai"."no_askes" AS "t1_c22", "pegawai"."jenisidentitas" AS "t1_c23", "pegawai"."noidentitas" AS "t1_c24", "pegawai"."gelardepan" AS "t1_c25", "pegawai"."nama_pegawai" AS "t1_c26", "pegawai"."nama_keluarga" AS "t1_c27", "pegawai"."tempatlahir_pegawai" AS "t1_c28", "pegawai"."tgl_lahirpegawai" AS "t1_c29", "pegawai"."jeniskelamin" AS "t1_c30", "pegawai"."statusperkawinan" AS "t1_c31", "pegawai"."alamat_pegawai" AS "t1_c32", "pegawai"."agama" AS "t1_c33", "pegawai"."golongandarah" AS "t1_c34", "pegawai"."rhesus" AS "t1_c35", "pegawai"."alamatemail" AS "t1_c36", "pegawai"."notelp_pegawai" AS "t1_c37", "pegawai"."nomobile_pegawai" AS "t1_c38", "pegawai"."warganegara_pegawai" AS "t1_c39", "pegawai"."jeniswaktukerja" AS "t1_c40", "pegawai"."kelompokjabatan" AS "t1_c41", "pegawai"."kategoripegawai" AS "t1_c42", "pegawai"."kategoripegawaiasal" AS "t1_c43", "pegawai"."photopegawai" AS "t1_c44", "pegawai"."nofingerprint" AS "t1_c45", "pegawai"."tinggibadan" AS "t1_c46", "pegawai"."beratbadan" AS "t1_c47", "pegawai"."kemampuanbahasa" AS "t1_c48", "pegawai"."warnakulit" AS "t1_c49", "pegawai"."nip_lama" AS "t1_c50", "pegawai"."no_rekening" AS "t1_c51", "pegawai"."bank_no_rekening" AS "t1_c52", "pegawai"."npwp" AS "t1_c53", "pegawai"."tglditerima" AS "t1_c54", "pegawai"."tglberhenti" AS "t1_c55", "pegawai"."gajipokok" AS "t1_c56", "pegawai"."create_time" AS "t1_c57", "pegawai"."update_time" AS "t1_c58", "pegawai"."create_loginpemakai_id" AS "t1_c59", "pegawai"."update_loginpemakai_id" AS "t1_c60", "pegawai"."create_ruangan" AS "t1_c61", "pegawai"."pegawai_aktif" AS "t1_c62", "pegawai"."suratizinpraktek" AS "t1_c63", "pegawai"."unit_perusahaan" AS "t1_c64", "pegawai"."golonganpegawai_id" AS "t1_c65", "pegawai"."deskripsi" AS "t1_c66", "pegawai"."garis_latitude" AS "t1_c67", "pegawai"."garis_longitude" AS "t1_c68", "pegawai"."jenistenagamedis_id" AS "t1_c69", "pegawai"."tglmasaaktifpeg" AS "t1_c70", "pegawai"."tglmasaaktifpeg_sd" AS "t1_c71", "pegawai"."shift_id" AS "t1_c72", "pegawai"."surattandaregistrasi" AS "t1_c73", "pegawai"."file_kontrak" AS "t1_c74", "pegawai"."masa_str" AS "t1_c75", "pegawai"."masa_sip" AS "t1_c76", "pegawai"."masa_tenagasehat" AS "t1_c77", "pegawai"."masa_medis" AS "t1_c78", "pegawai"."unitkerja_id" AS "t1_c79", "pegawai"."nominal_sip" AS "t1_c80", "pegawai"."alamat_pegawai_ktp" AS "t1_c81", "pegawai"."tglterdaftarnpwp" AS "t1_c82", "pegawai"."tglcatatkepnpwp" AS "t1_c83", "pegawai"."alamatnpwp" AS "t1_c84", "pegawai"."no_bpjs_kesehatan" AS "t1_c85", "pegawai"."no_bpjs_ketenagakerjaan" AS "t1_c86", "pegawai"."ptkp_id" AS "t1_c87", "pegawai"."kode_objekpajak" AS "t1_c88", "pegawai"."keterampilan" AS "t1_c89", "pegawai"."keahlian" AS "t1_c90", "pegawai"."minat" AS "t1_c91", "pegawai"."bakat" AS "t1_c92", "pegawai"."kode_negara" AS "t1_c93", "pegawai"."jenispegawai" AS "t1_c94", "pegawai"."inisial" AS "t1_c95", "pegawai"."cabang_pegawai" AS "t1_c96", "pegawai"."golongan" AS "t1_c97", "pegawai"."grade" AS "t1_c98", "pegawai"."cabang_bank" AS "t1_c99", "pegawai"."atasnama" AS "t1_c100", "pegawai"."tglmasuk_bpjs_ketenagakerjaan" AS "t1_c101", "pegawai"."tglkeluar_bpjs_ketenagakerjaan" AS "t1_c102", "pegawai"."nopeserta_asuransi" AS "t1_c103", "pegawai"."kodegroup_komponen" AS "t1_c104", "pegawai"."levelakses" AS "t1_c105", "pegawai"."nokontrak" AS "t1_c106", "pegawai"."keterangankontrak" AS "t1_c107", "pegawai"."metode_pph_21" AS "t1_c108", "pegawai"."tglpenghapusankemenkes" AS "t1_c109", "pegawai"."pegawaipenghapusankemenkes" AS "t1_c110", "pegawai"."tglpengiriminkemenkes" AS "t1_c111", "pegawai"."pegawaipengirimkemenkes" AS "t1_c112", "pegawai"."tglubahpengirimankemenkes" AS "t1_c113", "pegawai"."pegawaiubahpengirimankemenkes" AS "t1_c114", "pegawai"."logpenghapusandatakemenkes" AS "t1_c115", "pegawai"."statuspengiriman" AS "t1_c116", "pegawai"."dokterprioritas" AS "t1_c117", "pegawai"."kodedokter_bpjs" AS "t1_c118", "pegawai"."kabupaten_domisili_id" AS "t1_c119", "pegawai"."kecamatan_domisili_id" AS "t1_c120", "pegawai"."kelurahan_domisili_id" AS "t1_c121", "pegawai"."propinsi_domisili_id" AS "t1_c122", "pegawai"."kodejabatan_id" AS "t1_c123", "pegawai"."subkelompok_id" AS "t1_c124", "pegawai"."jabatanfungsional_id" AS "t1_c125", "pegawai"."pensiun_usia" AS "t1_c126", "pegawai"."pensiun_tmt" AS "t1_c127", "pegawai"."pensiun_tgledit" AS "t1_c128", "pegawai"."jurusan_id" AS "t1_c129", "pegawai"."eselon_id" AS "t1_c130", "pegawai"."smf_id" AS "t1_c131", "pegawai"."divisi_id" AS "t1_c132", "pegawai"."is_domisili_ktp" AS "t1_c133", "pegawai"."spesialissubspesialis_id" AS "t1_c134" FROM "pegawai_m" "pegawai" WHERE ("pegawai"."pegawai_id" = $1);
Date: 2022-01-14 10:54:08 Duration: 4ms Database: postgres User: db_rskt_running Remote: developer
9 18s512ms 11,846 1ms 5ms 1ms SELECT * FROM chat WHERE (chat_to = 'kevin' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming prepare #9
Day Hour Count Duration Avg duration 10 986 1s511ms 1ms 11 1,110 1s697ms 1ms 12 1,172 1s804ms 1ms 13 714 1s135ms 1ms 10 928 1s482ms 1ms 11 2,886 4s577ms 1ms 12 2,342 3s615ms 1ms 13 1,522 2s385ms 1ms 15 186 303ms 1ms [ User: developer - Total duration: 759ms - Times executed: 11846 ]
[ Application: [unknown] - Total duration: 759ms - Times executed: 11846 ]
-
SELECT * FROM chat WHERE (chat_to = 'kevin' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 13:14:22 Duration: 5ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'kevin' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 13:45:29 Duration: 5ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'kevin' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 11:19:52 Duration: 4ms Database: postgres User: db_rsrib_running Remote: developer
10 14s862ms 11,776 0ms 11ms 1ms SELECT * FROM chat WHERE (chat_to = 'annisa' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming prepare #10
Day Hour Count Duration Avg duration 10 247 294ms 1ms 11 357 434ms 1ms 12 236 294ms 1ms 13 1,119 1s426ms 1ms 14 645 821ms 1ms 15 156 192ms 1ms 16 154 192ms 1ms 17 60 74ms 1ms 18 6 7ms 1ms 07 1,336 1s688ms 1ms 08 2,094 2s594ms 1ms 09 1,128 1s427ms 1ms 10 2,192 2s848ms 1ms 11 1,324 1s668ms 1ms 12 312 379ms 1ms 13 120 160ms 1ms 14 290 357ms 1ms [ User: developer - Total duration: 484ms - Times executed: 11776 ]
[ Application: [unknown] - Total duration: 484ms - Times executed: 11776 ]
-
SELECT * FROM chat WHERE (chat_to = 'annisa' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 10:51:19 Duration: 11ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'annisa' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 08:26:10 Duration: 8ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'annisa' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 10:08:32 Duration: 5ms Database: postgres User: db_rskt_running Remote: developer
11 14s119ms 9,082 1ms 13ms 1ms SELECT * FROM chat WHERE (chat_to = 'yayuk' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming prepare #11
Day Hour Count Duration Avg duration 08 219 337ms 1ms 09 1,797 2s739ms 1ms 10 2,133 3s298ms 1ms 11 1,187 1s810ms 1ms 12 1,149 1s785ms 1ms 13 781 1s261ms 1ms 14 1,102 1s754ms 1ms 15 714 1s132ms 1ms [ User: developer - Total duration: 577ms - Times executed: 9082 ]
[ Application: [unknown] - Total duration: 577ms - Times executed: 9082 ]
-
SELECT * FROM chat WHERE (chat_to = 'yayuk' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 10:31:29 Duration: 13ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'yayuk' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 10:42:29 Duration: 12ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'yayuk' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 15:33:56 Duration: 5ms Database: postgres User: db_rsrib_running Remote: developer
12 11s76ms 8,768 0ms 6ms 1ms SELECT * FROM chat WHERE (chat_to = 'novie' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming prepare #12
Day Hour Count Duration Avg duration 08 612 763ms 1ms 09 2,364 2s993ms 1ms 10 2,372 3s49ms 1ms 11 2,362 2s971ms 1ms 12 1,026 1s258ms 1ms 13 32 39ms 1ms [ User: developer - Total duration: 356ms - Times executed: 8768 ]
[ Application: [unknown] - Total duration: 356ms - Times executed: 8768 ]
-
SELECT * FROM chat WHERE (chat_to = 'novie' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 08:51:35 Duration: 6ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'novie' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 09:58:18 Duration: 5ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'novie' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 11:45:48 Duration: 4ms Database: postgres User: db_rskt_running Remote: developer
13 10s754ms 8,675 0ms 7ms 1ms SELECT * FROM chat WHERE (chat_to = 'faridatul' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming prepare #13
Day Hour Count Duration Avg duration 03 31 37ms 1ms 04 60 69ms 1ms 05 60 69ms 1ms 06 60 70ms 1ms 07 60 71ms 1ms 08 60 73ms 1ms 09 157 200ms 1ms 10 58 67ms 1ms 11 60 72ms 1ms 12 328 410ms 1ms 13 465 585ms 1ms 14 391 495ms 1ms 15 60 72ms 1ms 16 60 71ms 1ms 17 60 73ms 1ms 18 60 73ms 1ms 19 60 75ms 1ms 20 60 75ms 1ms 21 60 74ms 1ms 22 60 74ms 1ms 23 60 72ms 1ms 00 60 72ms 1ms 01 60 72ms 1ms 02 60 72ms 1ms 03 113 136ms 1ms 04 120 147ms 1ms 05 120 147ms 1ms 06 120 152ms 1ms 07 358 454ms 1ms 08 860 1s79ms 1ms 09 112 139ms 1ms 10 120 152ms 1ms 11 120 147ms 1ms 12 120 150ms 1ms 13 120 150ms 1ms 14 188 230ms 1ms 15 2,400 2s984ms 1ms 16 832 1s17ms 1ms 17 120 139ms 1ms 18 120 143ms 1ms 19 120 150ms 1ms 20 102 123ms 1ms [ User: developer - Total duration: 340ms - Times executed: 8675 ]
[ Application: [unknown] - Total duration: 340ms - Times executed: 8675 ]
-
SELECT * FROM chat WHERE (chat_to = 'faridatul' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 09:40:16 Duration: 7ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'faridatul' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 15:05:13 Duration: 5ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'faridatul' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 12:06:58 Duration: 4ms Database: postgres User: db_rskt_running Remote: developer
14 9s710ms 301 28ms 48ms 32ms SELECT * FROM "infokunjunganrj_v" "t" WHERE tgl_pendaftaran BETWEEN $1 AND $2 ORDER BY tgl_pendaftaran DESC LIMIT 10;Times Reported Time consuming prepare #14
Day Hour Count Duration Avg duration 07 1 31ms 31ms 12 4 120ms 30ms 13 10 313ms 31ms 14 31 1s20ms 32ms 16 3 89ms 29ms 18 1 28ms 28ms 19 3 127ms 42ms 07 30 998ms 33ms 08 66 2s98ms 31ms 09 20 612ms 30ms 10 56 1s852ms 33ms 11 44 1s394ms 31ms 12 8 260ms 32ms 14 4 115ms 28ms 15 20 647ms 32ms [ User: developer - Total duration: 537ms - Times executed: 301 ]
[ Application: [unknown] - Total duration: 537ms - Times executed: 301 ]
-
SELECT * FROM "infokunjunganrj_v" "t" WHERE tgl_pendaftaran BETWEEN $1 AND $2 ORDER BY tgl_pendaftaran DESC LIMIT 10;
Date: 2022-01-13 19:24:52 Duration: 48ms Database: postgres User: db_ihospital Remote: developer
-
SELECT * FROM "infokunjunganrj_v" "t" WHERE tgl_pendaftaran BETWEEN $1 AND $2 ORDER BY tgl_pendaftaran DESC LIMIT 10;
Date: 2022-01-14 07:23:17 Duration: 45ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT * FROM "infokunjunganrj_v" "t" WHERE tgl_pendaftaran BETWEEN $1 AND $2 ORDER BY tgl_pendaftaran DESC LIMIT 10;
Date: 2022-01-14 10:15:21 Duration: 45ms Database: postgres User: db_rskt_running Remote: developer
15 8s767ms 7,095 0ms 8ms 1ms SELECT * FROM chat WHERE (chat_to = 'bintarm' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming prepare #15
Day Hour Count Duration Avg duration 07 387 464ms 1ms 08 353 421ms 1ms 09 698 831ms 1ms 10 153 181ms 1ms 11 60 72ms 1ms 12 60 75ms 1ms 13 60 75ms 1ms 14 834 1s24ms 1ms 15 575 724ms 1ms 16 831 1s23ms 1ms 17 194 232ms 1ms 10 1,610 2s70ms 1ms 11 70 88ms 1ms 14 328 416ms 1ms 15 436 525ms 1ms 16 446 538ms 1ms [ User: developer - Total duration: 422ms - Times executed: 7095 ]
[ Application: [unknown] - Total duration: 422ms - Times executed: 7095 ]
-
SELECT * FROM chat WHERE (chat_to = 'bintarm' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 15:20:24 Duration: 8ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'bintarm' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 15:54:48 Duration: 6ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'bintarm' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 14:46:01 Duration: 4ms Database: postgres User: db_rskt_running Remote: developer
16 8s262ms 5,092 1ms 5ms 1ms SELECT * FROM chat WHERE (chat_to = 'janes' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming prepare #16
Day Hour Count Duration Avg duration 13 74 123ms 1ms 09 562 917ms 1ms 10 3,192 5s185ms 1ms 11 1,024 1s653ms 1ms 14 16 24ms 1ms 15 224 358ms 1ms [ User: developer - Total duration: 346ms - Times executed: 5092 ]
[ Application: [unknown] - Total duration: 346ms - Times executed: 5092 ]
-
SELECT * FROM chat WHERE (chat_to = 'janes' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 11:19:52 Duration: 5ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'janes' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 10:25:57 Duration: 5ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'janes' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 10:06:59 Duration: 4ms Database: postgres User: db_rsrib_running Remote: developer
17 7s697ms 6,138 0ms 7ms 1ms SELECT * FROM chat WHERE (chat_to = 'aan' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming prepare #17
Day Hour Count Duration Avg duration 07 536 668ms 1ms 08 1,628 2s25ms 1ms 09 1,734 2s169ms 1ms 10 232 299ms 1ms 11 1,720 2s180ms 1ms 12 162 199ms 1ms 13 120 147ms 1ms 14 6 6ms 1ms [ User: developer - Total duration: 249ms - Times executed: 6138 ]
[ Application: [unknown] - Total duration: 249ms - Times executed: 6138 ]
-
SELECT * FROM chat WHERE (chat_to = 'aan' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 11:17:20 Duration: 7ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'aan' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 11:19:47 Duration: 4ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'aan' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 09:55:00 Duration: 3ms Database: postgres User: db_rskt_running Remote: developer
18 6s483ms 5,184 0ms 5ms 1ms SELECT * FROM chat WHERE (chat_to = 'tri' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming prepare #18
Day Hour Count Duration Avg duration 07 602 732ms 1ms 08 1,734 2s151ms 1ms 09 968 1s215ms 1ms 10 60 77ms 1ms 11 1,352 1s722ms 1ms 12 356 445ms 1ms 13 112 139ms 1ms [ User: developer - Total duration: 209ms - Times executed: 5184 ]
[ Application: [unknown] - Total duration: 209ms - Times executed: 5184 ]
-
SELECT * FROM chat WHERE (chat_to = 'tri' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 11:23:11 Duration: 5ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'tri' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 11:42:29 Duration: 3ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'tri' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 08:38:06 Duration: 3ms Database: postgres User: db_rskt_running Remote: developer
19 5s689ms 152 31ms 50ms 37ms SELECT COUNT(DISTINCT "t"."pendaftaran_id") FROM "infokunjunganrj_v" "t" LEFT OUTER JOIN "pendaftaran_t" "pendaftaran" ON ("t"."pendaftaran_id" = "pendaftaran"."pendaftaran_id") WHERE ((DATE(t.tgl_pendaftaran) BETWEEN $1 AND $2) AND (t.ruangan_id = 452));Times Reported Time consuming prepare #19
Day Hour Count Duration Avg duration 08 4 139ms 34ms 09 2 67ms 33ms 10 50 1s834ms 36ms 11 78 2s973ms 38ms 12 18 674ms 37ms [ User: developer - Total duration: 329ms - Times executed: 152 ]
[ Application: [unknown] - Total duration: 329ms - Times executed: 152 ]
-
SELECT COUNT(DISTINCT "t"."pendaftaran_id") FROM "infokunjunganrj_v" "t" LEFT OUTER JOIN "pendaftaran_t" "pendaftaran" ON ("t"."pendaftaran_id" = "pendaftaran"."pendaftaran_id") WHERE ((DATE(t.tgl_pendaftaran) BETWEEN $1 AND $2) AND (t.ruangan_id = 452));
Date: 2022-01-14 11:02:10 Duration: 50ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT COUNT(DISTINCT "t"."pendaftaran_id") FROM "infokunjunganrj_v" "t" LEFT OUTER JOIN "pendaftaran_t" "pendaftaran" ON ("t"."pendaftaran_id" = "pendaftaran"."pendaftaran_id") WHERE ((DATE(t.tgl_pendaftaran) BETWEEN $1 AND $2) AND (t.ruangan_id = 452));
Date: 2022-01-14 11:00:29 Duration: 49ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT COUNT(DISTINCT "t"."pendaftaran_id") FROM "infokunjunganrj_v" "t" LEFT OUTER JOIN "pendaftaran_t" "pendaftaran" ON ("t"."pendaftaran_id" = "pendaftaran"."pendaftaran_id") WHERE ((DATE(t.tgl_pendaftaran) BETWEEN $1 AND $2) AND (t.ruangan_id = 452));
Date: 2022-01-14 10:43:36 Duration: 49ms Database: postgres User: db_rskt_running Remote: developer
20 3s35ms 1,934 1ms 5ms 1ms SELECT * FROM chat WHERE (chat_to = 'aldino' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming prepare #20
Day Hour Count Duration Avg duration 15 1,934 3s35ms 1ms [ User: developer - Total duration: 122ms - Times executed: 1934 ]
[ Application: [unknown] - Total duration: 122ms - Times executed: 1934 ]
-
SELECT * FROM chat WHERE (chat_to = 'aldino' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 15:07:32 Duration: 5ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'aldino' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 15:11:38 Duration: 3ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'aldino' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 15:28:51 Duration: 2ms Database: postgres User: db_rsrib_running Remote: developer
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 11m23s 533,161 0ms 21ms 1ms SELECT ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jan 15 03 198 295ms 1ms 04 241 344ms 1ms 05 140 201ms 1ms 06 120 166ms 1ms 07 1,284 1s620ms 1ms 08 1,396 2s24ms 1ms 09 5,750 8s406ms 1ms 10 7,886 11s555ms 1ms 11 5,580 8s448ms 1ms 12 6,624 9s672ms 1ms 13 11,884 15s477ms 1ms 14 21,028 25s398ms 1ms 15 10,024 14s553ms 1ms 16 12,384 16s916ms 1ms 17 3,428 5s244ms 1ms 18 2,944 4s221ms 1ms 19 12,912 17s253ms 1ms 20 3,110 4s501ms 1ms 21 2,420 3s825ms 1ms 22 2,398 3s734ms 1ms 23 2,164 3s255ms 1ms Jan 15 00 120 176ms 1ms 01 120 176ms 1ms 02 120 172ms 1ms 03 226 329ms 1ms 04 240 348ms 1ms 05 240 365ms 1ms 06 1,316 1s773ms 1ms 07 14,236 16s680ms 1ms 08 37,628 44s122ms 1ms 09 41,844 55s840ms 1ms 10 118,078 2m20s 1ms 11 76,176 1m31s 1ms 12 27,916 36s463ms 1ms 13 28,128 40s93ms 1ms 14 28,640 39s204ms 1ms 15 32,108 41s49ms 1ms 16 2,596 3s822ms 1ms 17 5,308 7s497ms 1ms 18 3,676 5s322ms 1ms 19 240 363ms 1ms 20 210 316ms 1ms 21 24 31ms 1ms 22 24 32ms 1ms Jan 15 01 2 15ms 7ms 02 30 37ms 1ms [ User: developer - Total duration: 6m19s - Times executed: 533161 ]
[ Application: [unknown] - Total duration: 6m19s - Times executed: 533161 ]
-
SELECT ;
Date: 2022-01-14 10:56:08 Duration: 21ms Database: postgres User: db_rsrib_simulasi Remote: developer
-
SELECT ;
Date: 2022-01-13 15:23:30 Duration: 16ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = 'loginpemakai_k', $2 = 'public'
-
SELECT ;
Date: 2022-01-14 10:29:45 Duration: 14ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = 'kelompokmenu_k', $2 = 'public'
2 4m43s 494,656 0ms 92ms 0ms ;Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 03 297 153ms 0ms 04 360 175ms 0ms 05 198 94ms 0ms 06 180 83ms 0ms 07 1,351 663ms 0ms 08 1,901 1s17ms 0ms 09 8,013 4s475ms 0ms 10 10,808 6s270ms 0ms 11 8,327 4s778ms 0ms 12 8,852 5s124ms 0ms 13 11,082 6s538ms 0ms 14 15,905 9s202ms 0ms 15 13,076 7s585ms 0ms 16 13,723 7s943ms 0ms 17 5,048 2s909ms 0ms 18 3,619 2s110ms 0ms 19 11,124 6s305ms 0ms 20 3,739 2s270ms 0ms 21 3,615 2s183ms 0ms 22 3,579 2s126ms 0ms 23 3,034 1s808ms 0ms 00 180 92ms 0ms 01 180 94ms 0ms 02 180 92ms 0ms 03 339 168ms 0ms 04 360 182ms 0ms 05 360 183ms 0ms 06 1,440 783ms 0ms 07 10,468 5s509ms 0ms 08 29,618 15s892ms 0ms 09 41,522 23s623ms 0ms 10 79,934 48s613ms 0ms 11 57,758 33s327ms 0ms 12 29,648 16s436ms 0ms 13 34,708 20s100ms 0ms 14 33,216 19s24ms 0ms 15 29,346 16s734ms 0ms 16 3,834 1s926ms 0ms 17 7,554 3s765ms 0ms 18 5,514 2s734ms 0ms 19 360 183ms 0ms 20 306 153ms 0ms [ User: developer - Total duration: 15m - Times executed: 494656 ]
[ Application: [unknown] - Total duration: 15m - Times executed: 494656 ]
-
;
Date: 2022-01-14 11:10:45 Duration: 92ms Database: postgres User: db_rsrib_running Remote: developer
-
;
Date: 2022-01-14 10:49:55 Duration: 90ms Database: postgres User: db_rsrib_running Remote: developer
-
;
Date: 2022-01-14 10:35:43 Duration: 89ms Database: postgres User: db_rsrib_running Remote: developer
3 43s24ms 261,624 0ms 9ms 0ms SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE ;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 03 99 16ms 0ms 04 120 19ms 0ms 05 70 11ms 0ms 06 60 9ms 0ms 07 635 96ms 0ms 08 698 111ms 0ms 09 2,857 456ms 0ms 10 3,919 625ms 0ms 11 2,790 446ms 0ms 12 3,300 536ms 0ms 13 5,837 978ms 0ms 14 10,356 1s660ms 0ms 15 4,992 815ms 0ms 16 6,140 991ms 0ms 17 1,714 278ms 0ms 18 1,456 235ms 0ms 19 6,309 1s58ms 0ms 20 1,547 262ms 0ms 21 1,210 204ms 0ms 22 1,199 198ms 0ms 23 1,082 177ms 0ms 00 60 9ms 0ms 01 60 9ms 0ms 02 60 9ms 0ms 03 113 18ms 0ms 04 120 19ms 0ms 05 120 19ms 0ms 06 658 106ms 0ms 07 7,002 1s136ms 0ms 08 18,514 2s946ms 0ms 09 20,548 3s507ms 0ms 10 57,162 9s668ms 0ms 11 37,056 6s110ms 0ms 12 13,778 2s201ms 0ms 13 13,950 2s273ms 0ms 14 14,150 2s269ms 0ms 15 15,828 2s560ms 0ms 16 1,298 213ms 0ms 17 2,652 415ms 0ms 18 1,838 292ms 0ms 19 120 19ms 0ms 20 104 16ms 0ms 21 12 1ms 0ms 22 12 1ms 0ms 23 4 0ms 0ms 01 1 0ms 0ms 02 14 2ms 0ms [ User: developer - Total duration: 7s591ms - Times executed: 261624 ]
[ Application: [unknown] - Total duration: 7s591ms - Times executed: 261624 ]
-
SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE ;
Date: 2022-01-14 10:40:05 Duration: 9ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = 'menumodul_k', $2 = 'public'
-
SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE ;
Date: 2022-01-14 09:00:11 Duration: 6ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = 'kelompokmenu_k', $2 = 'public'
-
SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE ;
Date: 2022-01-14 10:37:34 Duration: 6ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = 'loginpemakai_k', $2 = 'public'
4 26s284ms 104,652 0ms 7ms 0ms SELECT "pegawai"."pegawai_id" AS "t1_c0", "pegawai"."kabupaten_id" AS "t1_c1", "pegawai"."pangkat_id" AS "t1_c2", "pegawai"."pendkualifikasi_id" AS "t1_c3", "pegawai"."kelurahan_id" AS "t1_c4", "pegawai"."kelompokpegawai_id" AS "t1_c5", "pegawai"."profilrs_id" AS "t1_c6", "pegawai"."pengangkatantphl_id" AS "t1_c7", "pegawai"."pendidikan_id" AS "t1_c8", "pegawai"."loginpemakai_id" AS "t1_c9", "pegawai"."kecamatan_id" AS "t1_c10", "pegawai"."registerpensiun_id" AS "t1_c11", "pegawai"."suku_id" AS "t1_c12", "pegawai"."jabatan_id" AS "t1_c13", "pegawai"."esselon_id" AS "t1_c14", "pegawai"."propinsi_id" AS "t1_c15", "pegawai"."statuskepemilikanrumah_id" AS "t1_c16", "pegawai"."gelarbelakang_id" AS "t1_c17", "pegawai"."nomorindukpegawai" AS "t1_c18", "pegawai"."no_kartupegawainegerisipil" AS "t1_c19", "pegawai"."no_karis_karsu" AS "t1_c20", "pegawai"."no_taspen" AS "t1_c21", "pegawai"."no_askes" AS "t1_c22", "pegawai"."jenisidentitas" AS "t1_c23", "pegawai"."noidentitas" AS "t1_c24", "pegawai"."gelardepan" AS "t1_c25", "pegawai"."nama_pegawai" AS "t1_c26", "pegawai"."nama_keluarga" AS "t1_c27", "pegawai"."tempatlahir_pegawai" AS "t1_c28", "pegawai"."tgl_lahirpegawai" AS "t1_c29", "pegawai"."jeniskelamin" AS "t1_c30", "pegawai"."statusperkawinan" AS "t1_c31", "pegawai"."alamat_pegawai" AS "t1_c32", "pegawai"."agama" AS "t1_c33", "pegawai"."golongandarah" AS "t1_c34", "pegawai"."rhesus" AS "t1_c35", "pegawai"."alamatemail" AS "t1_c36", "pegawai"."notelp_pegawai" AS "t1_c37", "pegawai"."nomobile_pegawai" AS "t1_c38", "pegawai"."warganegara_pegawai" AS "t1_c39", "pegawai"."jeniswaktukerja" AS "t1_c40", "pegawai"."kelompokjabatan" AS "t1_c41", "pegawai"."kategoripegawai" AS "t1_c42", "pegawai"."kategoripegawaiasal" AS "t1_c43", "pegawai"."photopegawai" AS "t1_c44", "pegawai"."nofingerprint" AS "t1_c45", "pegawai"."tinggibadan" AS "t1_c46", "pegawai"."beratbadan" AS "t1_c47", "pegawai"."kemampuanbahasa" AS "t1_c48", "pegawai"."warnakulit" AS "t1_c49", "pegawai"."nip_lama" AS "t1_c50", "pegawai"."no_rekening" AS "t1_c51", "pegawai"."bank_no_rekening" AS "t1_c52", "pegawai"."npwp" AS "t1_c53", "pegawai"."tglditerima" AS "t1_c54", "pegawai"."tglberhenti" AS "t1_c55", "pegawai"."gajipokok" AS "t1_c56", "pegawai"."create_time" AS "t1_c57", "pegawai"."update_time" AS "t1_c58", "pegawai"."create_loginpemakai_id" AS "t1_c59", "pegawai"."update_loginpemakai_id" AS "t1_c60", "pegawai"."create_ruangan" AS "t1_c61", "pegawai"."pegawai_aktif" AS "t1_c62", "pegawai"."suratizinpraktek" AS "t1_c63", "pegawai"."unit_perusahaan" AS "t1_c64", "pegawai"."golonganpegawai_id" AS "t1_c65", "pegawai"."deskripsi" AS "t1_c66", "pegawai"."garis_latitude" AS "t1_c67", "pegawai"."garis_longitude" AS "t1_c68", "pegawai"."jenistenagamedis_id" AS "t1_c69", "pegawai"."tglmasaaktifpeg" AS "t1_c70", "pegawai"."tglmasaaktifpeg_sd" AS "t1_c71", "pegawai"."shift_id" AS "t1_c72", "pegawai"."surattandaregistrasi" AS "t1_c73", "pegawai"."file_kontrak" AS "t1_c74", "pegawai"."masa_str" AS "t1_c75", "pegawai"."masa_sip" AS "t1_c76", "pegawai"."masa_tenagasehat" AS "t1_c77", "pegawai"."masa_medis" AS "t1_c78", "pegawai"."unitkerja_id" AS "t1_c79", "pegawai"."nominal_sip" AS "t1_c80", "pegawai"."alamat_pegawai_ktp" AS "t1_c81", "pegawai"."tglterdaftarnpwp" AS "t1_c82", "pegawai"."tglcatatkepnpwp" AS "t1_c83", "pegawai"."alamatnpwp" AS "t1_c84", "pegawai"."no_bpjs_kesehatan" AS "t1_c85", "pegawai"."no_bpjs_ketenagakerjaan" AS "t1_c86", "pegawai"."ptkp_id" AS "t1_c87", "pegawai"."kode_objekpajak" AS "t1_c88", "pegawai"."keterampilan" AS "t1_c89", "pegawai"."keahlian" AS "t1_c90", "pegawai"."minat" AS "t1_c91", "pegawai"."bakat" AS "t1_c92", "pegawai"."kode_negara" AS "t1_c93", "pegawai"."jenispegawai" AS "t1_c94", "pegawai"."inisial" AS "t1_c95", "pegawai"."cabang_pegawai" AS "t1_c96", "pegawai"."golongan" AS "t1_c97", "pegawai"."grade" AS "t1_c98", "pegawai"."cabang_bank" AS "t1_c99", "pegawai"."atasnama" AS "t1_c100", "pegawai"."tglmasuk_bpjs_ketenagakerjaan" AS "t1_c101", "pegawai"."tglkeluar_bpjs_ketenagakerjaan" AS "t1_c102", "pegawai"."nopeserta_asuransi" AS "t1_c103", "pegawai"."kodegroup_komponen" AS "t1_c104", "pegawai"."levelakses" AS "t1_c105", "pegawai"."nokontrak" AS "t1_c106", "pegawai"."keterangankontrak" AS "t1_c107", "pegawai"."metode_pph_21" AS "t1_c108", "pegawai"."tglpenghapusankemenkes" AS "t1_c109", "pegawai"."pegawaipenghapusankemenkes" AS "t1_c110", "pegawai"."tglpengiriminkemenkes" AS "t1_c111", "pegawai"."pegawaipengirimkemenkes" AS "t1_c112", "pegawai"."tglubahpengirimankemenkes" AS "t1_c113", "pegawai"."pegawaiubahpengirimankemenkes" AS "t1_c114", "pegawai"."logpenghapusandatakemenkes" AS "t1_c115", "pegawai"."statuspengiriman" AS "t1_c116", "pegawai"."nomorijazah" AS "t1_c117", "pegawai"."universitas_sekolah" AS "t1_c118", "pegawai"."kodedokter_bpjs" AS "t1_c119", "pegawai"."spesialissubspesialis_id" AS "t1_c120" FROM "pegawai_m" "pegawai" WHERE ("pegawai"."pegawai_id" = $1);Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 08 122 25ms 0ms 09 1,453 328ms 0ms 10 1,818 425ms 0ms 11 122 26ms 0ms 13 4,434 1s128ms 0ms 14 6,911 1s738ms 0ms 09 11,936 2s948ms 0ms 10 32,092 8s480ms 0ms 11 5,698 1s466ms 0ms 13 7,076 1s677ms 0ms 14 15,648 3s674ms 0ms 15 17,342 4s362ms 0ms [ User: developer - Total duration: 3s512ms - Times executed: 104652 ]
[ Application: [unknown] - Total duration: 3s512ms - Times executed: 104652 ]
-
SELECT "pegawai"."pegawai_id" AS "t1_c0", "pegawai"."kabupaten_id" AS "t1_c1", "pegawai"."pangkat_id" AS "t1_c2", "pegawai"."pendkualifikasi_id" AS "t1_c3", "pegawai"."kelurahan_id" AS "t1_c4", "pegawai"."kelompokpegawai_id" AS "t1_c5", "pegawai"."profilrs_id" AS "t1_c6", "pegawai"."pengangkatantphl_id" AS "t1_c7", "pegawai"."pendidikan_id" AS "t1_c8", "pegawai"."loginpemakai_id" AS "t1_c9", "pegawai"."kecamatan_id" AS "t1_c10", "pegawai"."registerpensiun_id" AS "t1_c11", "pegawai"."suku_id" AS "t1_c12", "pegawai"."jabatan_id" AS "t1_c13", "pegawai"."esselon_id" AS "t1_c14", "pegawai"."propinsi_id" AS "t1_c15", "pegawai"."statuskepemilikanrumah_id" AS "t1_c16", "pegawai"."gelarbelakang_id" AS "t1_c17", "pegawai"."nomorindukpegawai" AS "t1_c18", "pegawai"."no_kartupegawainegerisipil" AS "t1_c19", "pegawai"."no_karis_karsu" AS "t1_c20", "pegawai"."no_taspen" AS "t1_c21", "pegawai"."no_askes" AS "t1_c22", "pegawai"."jenisidentitas" AS "t1_c23", "pegawai"."noidentitas" AS "t1_c24", "pegawai"."gelardepan" AS "t1_c25", "pegawai"."nama_pegawai" AS "t1_c26", "pegawai"."nama_keluarga" AS "t1_c27", "pegawai"."tempatlahir_pegawai" AS "t1_c28", "pegawai"."tgl_lahirpegawai" AS "t1_c29", "pegawai"."jeniskelamin" AS "t1_c30", "pegawai"."statusperkawinan" AS "t1_c31", "pegawai"."alamat_pegawai" AS "t1_c32", "pegawai"."agama" AS "t1_c33", "pegawai"."golongandarah" AS "t1_c34", "pegawai"."rhesus" AS "t1_c35", "pegawai"."alamatemail" AS "t1_c36", "pegawai"."notelp_pegawai" AS "t1_c37", "pegawai"."nomobile_pegawai" AS "t1_c38", "pegawai"."warganegara_pegawai" AS "t1_c39", "pegawai"."jeniswaktukerja" AS "t1_c40", "pegawai"."kelompokjabatan" AS "t1_c41", "pegawai"."kategoripegawai" AS "t1_c42", "pegawai"."kategoripegawaiasal" AS "t1_c43", "pegawai"."photopegawai" AS "t1_c44", "pegawai"."nofingerprint" AS "t1_c45", "pegawai"."tinggibadan" AS "t1_c46", "pegawai"."beratbadan" AS "t1_c47", "pegawai"."kemampuanbahasa" AS "t1_c48", "pegawai"."warnakulit" AS "t1_c49", "pegawai"."nip_lama" AS "t1_c50", "pegawai"."no_rekening" AS "t1_c51", "pegawai"."bank_no_rekening" AS "t1_c52", "pegawai"."npwp" AS "t1_c53", "pegawai"."tglditerima" AS "t1_c54", "pegawai"."tglberhenti" AS "t1_c55", "pegawai"."gajipokok" AS "t1_c56", "pegawai"."create_time" AS "t1_c57", "pegawai"."update_time" AS "t1_c58", "pegawai"."create_loginpemakai_id" AS "t1_c59", "pegawai"."update_loginpemakai_id" AS "t1_c60", "pegawai"."create_ruangan" AS "t1_c61", "pegawai"."pegawai_aktif" AS "t1_c62", "pegawai"."suratizinpraktek" AS "t1_c63", "pegawai"."unit_perusahaan" AS "t1_c64", "pegawai"."golonganpegawai_id" AS "t1_c65", "pegawai"."deskripsi" AS "t1_c66", "pegawai"."garis_latitude" AS "t1_c67", "pegawai"."garis_longitude" AS "t1_c68", "pegawai"."jenistenagamedis_id" AS "t1_c69", "pegawai"."tglmasaaktifpeg" AS "t1_c70", "pegawai"."tglmasaaktifpeg_sd" AS "t1_c71", "pegawai"."shift_id" AS "t1_c72", "pegawai"."surattandaregistrasi" AS "t1_c73", "pegawai"."file_kontrak" AS "t1_c74", "pegawai"."masa_str" AS "t1_c75", "pegawai"."masa_sip" AS "t1_c76", "pegawai"."masa_tenagasehat" AS "t1_c77", "pegawai"."masa_medis" AS "t1_c78", "pegawai"."unitkerja_id" AS "t1_c79", "pegawai"."nominal_sip" AS "t1_c80", "pegawai"."alamat_pegawai_ktp" AS "t1_c81", "pegawai"."tglterdaftarnpwp" AS "t1_c82", "pegawai"."tglcatatkepnpwp" AS "t1_c83", "pegawai"."alamatnpwp" AS "t1_c84", "pegawai"."no_bpjs_kesehatan" AS "t1_c85", "pegawai"."no_bpjs_ketenagakerjaan" AS "t1_c86", "pegawai"."ptkp_id" AS "t1_c87", "pegawai"."kode_objekpajak" AS "t1_c88", "pegawai"."keterampilan" AS "t1_c89", "pegawai"."keahlian" AS "t1_c90", "pegawai"."minat" AS "t1_c91", "pegawai"."bakat" AS "t1_c92", "pegawai"."kode_negara" AS "t1_c93", "pegawai"."jenispegawai" AS "t1_c94", "pegawai"."inisial" AS "t1_c95", "pegawai"."cabang_pegawai" AS "t1_c96", "pegawai"."golongan" AS "t1_c97", "pegawai"."grade" AS "t1_c98", "pegawai"."cabang_bank" AS "t1_c99", "pegawai"."atasnama" AS "t1_c100", "pegawai"."tglmasuk_bpjs_ketenagakerjaan" AS "t1_c101", "pegawai"."tglkeluar_bpjs_ketenagakerjaan" AS "t1_c102", "pegawai"."nopeserta_asuransi" AS "t1_c103", "pegawai"."kodegroup_komponen" AS "t1_c104", "pegawai"."levelakses" AS "t1_c105", "pegawai"."nokontrak" AS "t1_c106", "pegawai"."keterangankontrak" AS "t1_c107", "pegawai"."metode_pph_21" AS "t1_c108", "pegawai"."tglpenghapusankemenkes" AS "t1_c109", "pegawai"."pegawaipenghapusankemenkes" AS "t1_c110", "pegawai"."tglpengiriminkemenkes" AS "t1_c111", "pegawai"."pegawaipengirimkemenkes" AS "t1_c112", "pegawai"."tglubahpengirimankemenkes" AS "t1_c113", "pegawai"."pegawaiubahpengirimankemenkes" AS "t1_c114", "pegawai"."logpenghapusandatakemenkes" AS "t1_c115", "pegawai"."statuspengiriman" AS "t1_c116", "pegawai"."nomorijazah" AS "t1_c117", "pegawai"."universitas_sekolah" AS "t1_c118", "pegawai"."kodedokter_bpjs" AS "t1_c119", "pegawai"."spesialissubspesialis_id" AS "t1_c120" FROM "pegawai_m" "pegawai" WHERE ("pegawai"."pegawai_id" = $1);
Date: 2022-01-13 14:20:31 Duration: 7ms Database: postgres User: db_rsrib_running Remote: developer parameters: $1 = '1028'
-
SELECT "pegawai"."pegawai_id" AS "t1_c0", "pegawai"."kabupaten_id" AS "t1_c1", "pegawai"."pangkat_id" AS "t1_c2", "pegawai"."pendkualifikasi_id" AS "t1_c3", "pegawai"."kelurahan_id" AS "t1_c4", "pegawai"."kelompokpegawai_id" AS "t1_c5", "pegawai"."profilrs_id" AS "t1_c6", "pegawai"."pengangkatantphl_id" AS "t1_c7", "pegawai"."pendidikan_id" AS "t1_c8", "pegawai"."loginpemakai_id" AS "t1_c9", "pegawai"."kecamatan_id" AS "t1_c10", "pegawai"."registerpensiun_id" AS "t1_c11", "pegawai"."suku_id" AS "t1_c12", "pegawai"."jabatan_id" AS "t1_c13", "pegawai"."esselon_id" AS "t1_c14", "pegawai"."propinsi_id" AS "t1_c15", "pegawai"."statuskepemilikanrumah_id" AS "t1_c16", "pegawai"."gelarbelakang_id" AS "t1_c17", "pegawai"."nomorindukpegawai" AS "t1_c18", "pegawai"."no_kartupegawainegerisipil" AS "t1_c19", "pegawai"."no_karis_karsu" AS "t1_c20", "pegawai"."no_taspen" AS "t1_c21", "pegawai"."no_askes" AS "t1_c22", "pegawai"."jenisidentitas" AS "t1_c23", "pegawai"."noidentitas" AS "t1_c24", "pegawai"."gelardepan" AS "t1_c25", "pegawai"."nama_pegawai" AS "t1_c26", "pegawai"."nama_keluarga" AS "t1_c27", "pegawai"."tempatlahir_pegawai" AS "t1_c28", "pegawai"."tgl_lahirpegawai" AS "t1_c29", "pegawai"."jeniskelamin" AS "t1_c30", "pegawai"."statusperkawinan" AS "t1_c31", "pegawai"."alamat_pegawai" AS "t1_c32", "pegawai"."agama" AS "t1_c33", "pegawai"."golongandarah" AS "t1_c34", "pegawai"."rhesus" AS "t1_c35", "pegawai"."alamatemail" AS "t1_c36", "pegawai"."notelp_pegawai" AS "t1_c37", "pegawai"."nomobile_pegawai" AS "t1_c38", "pegawai"."warganegara_pegawai" AS "t1_c39", "pegawai"."jeniswaktukerja" AS "t1_c40", "pegawai"."kelompokjabatan" AS "t1_c41", "pegawai"."kategoripegawai" AS "t1_c42", "pegawai"."kategoripegawaiasal" AS "t1_c43", "pegawai"."photopegawai" AS "t1_c44", "pegawai"."nofingerprint" AS "t1_c45", "pegawai"."tinggibadan" AS "t1_c46", "pegawai"."beratbadan" AS "t1_c47", "pegawai"."kemampuanbahasa" AS "t1_c48", "pegawai"."warnakulit" AS "t1_c49", "pegawai"."nip_lama" AS "t1_c50", "pegawai"."no_rekening" AS "t1_c51", "pegawai"."bank_no_rekening" AS "t1_c52", "pegawai"."npwp" AS "t1_c53", "pegawai"."tglditerima" AS "t1_c54", "pegawai"."tglberhenti" AS "t1_c55", "pegawai"."gajipokok" AS "t1_c56", "pegawai"."create_time" AS "t1_c57", "pegawai"."update_time" AS "t1_c58", "pegawai"."create_loginpemakai_id" AS "t1_c59", "pegawai"."update_loginpemakai_id" AS "t1_c60", "pegawai"."create_ruangan" AS "t1_c61", "pegawai"."pegawai_aktif" AS "t1_c62", "pegawai"."suratizinpraktek" AS "t1_c63", "pegawai"."unit_perusahaan" AS "t1_c64", "pegawai"."golonganpegawai_id" AS "t1_c65", "pegawai"."deskripsi" AS "t1_c66", "pegawai"."garis_latitude" AS "t1_c67", "pegawai"."garis_longitude" AS "t1_c68", "pegawai"."jenistenagamedis_id" AS "t1_c69", "pegawai"."tglmasaaktifpeg" AS "t1_c70", "pegawai"."tglmasaaktifpeg_sd" AS "t1_c71", "pegawai"."shift_id" AS "t1_c72", "pegawai"."surattandaregistrasi" AS "t1_c73", "pegawai"."file_kontrak" AS "t1_c74", "pegawai"."masa_str" AS "t1_c75", "pegawai"."masa_sip" AS "t1_c76", "pegawai"."masa_tenagasehat" AS "t1_c77", "pegawai"."masa_medis" AS "t1_c78", "pegawai"."unitkerja_id" AS "t1_c79", "pegawai"."nominal_sip" AS "t1_c80", "pegawai"."alamat_pegawai_ktp" AS "t1_c81", "pegawai"."tglterdaftarnpwp" AS "t1_c82", "pegawai"."tglcatatkepnpwp" AS "t1_c83", "pegawai"."alamatnpwp" AS "t1_c84", "pegawai"."no_bpjs_kesehatan" AS "t1_c85", "pegawai"."no_bpjs_ketenagakerjaan" AS "t1_c86", "pegawai"."ptkp_id" AS "t1_c87", "pegawai"."kode_objekpajak" AS "t1_c88", "pegawai"."keterampilan" AS "t1_c89", "pegawai"."keahlian" AS "t1_c90", "pegawai"."minat" AS "t1_c91", "pegawai"."bakat" AS "t1_c92", "pegawai"."kode_negara" AS "t1_c93", "pegawai"."jenispegawai" AS "t1_c94", "pegawai"."inisial" AS "t1_c95", "pegawai"."cabang_pegawai" AS "t1_c96", "pegawai"."golongan" AS "t1_c97", "pegawai"."grade" AS "t1_c98", "pegawai"."cabang_bank" AS "t1_c99", "pegawai"."atasnama" AS "t1_c100", "pegawai"."tglmasuk_bpjs_ketenagakerjaan" AS "t1_c101", "pegawai"."tglkeluar_bpjs_ketenagakerjaan" AS "t1_c102", "pegawai"."nopeserta_asuransi" AS "t1_c103", "pegawai"."kodegroup_komponen" AS "t1_c104", "pegawai"."levelakses" AS "t1_c105", "pegawai"."nokontrak" AS "t1_c106", "pegawai"."keterangankontrak" AS "t1_c107", "pegawai"."metode_pph_21" AS "t1_c108", "pegawai"."tglpenghapusankemenkes" AS "t1_c109", "pegawai"."pegawaipenghapusankemenkes" AS "t1_c110", "pegawai"."tglpengiriminkemenkes" AS "t1_c111", "pegawai"."pegawaipengirimkemenkes" AS "t1_c112", "pegawai"."tglubahpengirimankemenkes" AS "t1_c113", "pegawai"."pegawaiubahpengirimankemenkes" AS "t1_c114", "pegawai"."logpenghapusandatakemenkes" AS "t1_c115", "pegawai"."statuspengiriman" AS "t1_c116", "pegawai"."nomorijazah" AS "t1_c117", "pegawai"."universitas_sekolah" AS "t1_c118", "pegawai"."kodedokter_bpjs" AS "t1_c119", "pegawai"."spesialissubspesialis_id" AS "t1_c120" FROM "pegawai_m" "pegawai" WHERE ("pegawai"."pegawai_id" = $1);
Date: 2022-01-13 10:03:45 Duration: 5ms Database: postgres User: db_rsrib_running Remote: developer parameters: $1 = '1108'
-
SELECT "pegawai"."pegawai_id" AS "t1_c0", "pegawai"."kabupaten_id" AS "t1_c1", "pegawai"."pangkat_id" AS "t1_c2", "pegawai"."pendkualifikasi_id" AS "t1_c3", "pegawai"."kelurahan_id" AS "t1_c4", "pegawai"."kelompokpegawai_id" AS "t1_c5", "pegawai"."profilrs_id" AS "t1_c6", "pegawai"."pengangkatantphl_id" AS "t1_c7", "pegawai"."pendidikan_id" AS "t1_c8", "pegawai"."loginpemakai_id" AS "t1_c9", "pegawai"."kecamatan_id" AS "t1_c10", "pegawai"."registerpensiun_id" AS "t1_c11", "pegawai"."suku_id" AS "t1_c12", "pegawai"."jabatan_id" AS "t1_c13", "pegawai"."esselon_id" AS "t1_c14", "pegawai"."propinsi_id" AS "t1_c15", "pegawai"."statuskepemilikanrumah_id" AS "t1_c16", "pegawai"."gelarbelakang_id" AS "t1_c17", "pegawai"."nomorindukpegawai" AS "t1_c18", "pegawai"."no_kartupegawainegerisipil" AS "t1_c19", "pegawai"."no_karis_karsu" AS "t1_c20", "pegawai"."no_taspen" AS "t1_c21", "pegawai"."no_askes" AS "t1_c22", "pegawai"."jenisidentitas" AS "t1_c23", "pegawai"."noidentitas" AS "t1_c24", "pegawai"."gelardepan" AS "t1_c25", "pegawai"."nama_pegawai" AS "t1_c26", "pegawai"."nama_keluarga" AS "t1_c27", "pegawai"."tempatlahir_pegawai" AS "t1_c28", "pegawai"."tgl_lahirpegawai" AS "t1_c29", "pegawai"."jeniskelamin" AS "t1_c30", "pegawai"."statusperkawinan" AS "t1_c31", "pegawai"."alamat_pegawai" AS "t1_c32", "pegawai"."agama" AS "t1_c33", "pegawai"."golongandarah" AS "t1_c34", "pegawai"."rhesus" AS "t1_c35", "pegawai"."alamatemail" AS "t1_c36", "pegawai"."notelp_pegawai" AS "t1_c37", "pegawai"."nomobile_pegawai" AS "t1_c38", "pegawai"."warganegara_pegawai" AS "t1_c39", "pegawai"."jeniswaktukerja" AS "t1_c40", "pegawai"."kelompokjabatan" AS "t1_c41", "pegawai"."kategoripegawai" AS "t1_c42", "pegawai"."kategoripegawaiasal" AS "t1_c43", "pegawai"."photopegawai" AS "t1_c44", "pegawai"."nofingerprint" AS "t1_c45", "pegawai"."tinggibadan" AS "t1_c46", "pegawai"."beratbadan" AS "t1_c47", "pegawai"."kemampuanbahasa" AS "t1_c48", "pegawai"."warnakulit" AS "t1_c49", "pegawai"."nip_lama" AS "t1_c50", "pegawai"."no_rekening" AS "t1_c51", "pegawai"."bank_no_rekening" AS "t1_c52", "pegawai"."npwp" AS "t1_c53", "pegawai"."tglditerima" AS "t1_c54", "pegawai"."tglberhenti" AS "t1_c55", "pegawai"."gajipokok" AS "t1_c56", "pegawai"."create_time" AS "t1_c57", "pegawai"."update_time" AS "t1_c58", "pegawai"."create_loginpemakai_id" AS "t1_c59", "pegawai"."update_loginpemakai_id" AS "t1_c60", "pegawai"."create_ruangan" AS "t1_c61", "pegawai"."pegawai_aktif" AS "t1_c62", "pegawai"."suratizinpraktek" AS "t1_c63", "pegawai"."unit_perusahaan" AS "t1_c64", "pegawai"."golonganpegawai_id" AS "t1_c65", "pegawai"."deskripsi" AS "t1_c66", "pegawai"."garis_latitude" AS "t1_c67", "pegawai"."garis_longitude" AS "t1_c68", "pegawai"."jenistenagamedis_id" AS "t1_c69", "pegawai"."tglmasaaktifpeg" AS "t1_c70", "pegawai"."tglmasaaktifpeg_sd" AS "t1_c71", "pegawai"."shift_id" AS "t1_c72", "pegawai"."surattandaregistrasi" AS "t1_c73", "pegawai"."file_kontrak" AS "t1_c74", "pegawai"."masa_str" AS "t1_c75", "pegawai"."masa_sip" AS "t1_c76", "pegawai"."masa_tenagasehat" AS "t1_c77", "pegawai"."masa_medis" AS "t1_c78", "pegawai"."unitkerja_id" AS "t1_c79", "pegawai"."nominal_sip" AS "t1_c80", "pegawai"."alamat_pegawai_ktp" AS "t1_c81", "pegawai"."tglterdaftarnpwp" AS "t1_c82", "pegawai"."tglcatatkepnpwp" AS "t1_c83", "pegawai"."alamatnpwp" AS "t1_c84", "pegawai"."no_bpjs_kesehatan" AS "t1_c85", "pegawai"."no_bpjs_ketenagakerjaan" AS "t1_c86", "pegawai"."ptkp_id" AS "t1_c87", "pegawai"."kode_objekpajak" AS "t1_c88", "pegawai"."keterampilan" AS "t1_c89", "pegawai"."keahlian" AS "t1_c90", "pegawai"."minat" AS "t1_c91", "pegawai"."bakat" AS "t1_c92", "pegawai"."kode_negara" AS "t1_c93", "pegawai"."jenispegawai" AS "t1_c94", "pegawai"."inisial" AS "t1_c95", "pegawai"."cabang_pegawai" AS "t1_c96", "pegawai"."golongan" AS "t1_c97", "pegawai"."grade" AS "t1_c98", "pegawai"."cabang_bank" AS "t1_c99", "pegawai"."atasnama" AS "t1_c100", "pegawai"."tglmasuk_bpjs_ketenagakerjaan" AS "t1_c101", "pegawai"."tglkeluar_bpjs_ketenagakerjaan" AS "t1_c102", "pegawai"."nopeserta_asuransi" AS "t1_c103", "pegawai"."kodegroup_komponen" AS "t1_c104", "pegawai"."levelakses" AS "t1_c105", "pegawai"."nokontrak" AS "t1_c106", "pegawai"."keterangankontrak" AS "t1_c107", "pegawai"."metode_pph_21" AS "t1_c108", "pegawai"."tglpenghapusankemenkes" AS "t1_c109", "pegawai"."pegawaipenghapusankemenkes" AS "t1_c110", "pegawai"."tglpengiriminkemenkes" AS "t1_c111", "pegawai"."pegawaipengirimkemenkes" AS "t1_c112", "pegawai"."tglubahpengirimankemenkes" AS "t1_c113", "pegawai"."pegawaiubahpengirimankemenkes" AS "t1_c114", "pegawai"."logpenghapusandatakemenkes" AS "t1_c115", "pegawai"."statuspengiriman" AS "t1_c116", "pegawai"."nomorijazah" AS "t1_c117", "pegawai"."universitas_sekolah" AS "t1_c118", "pegawai"."kodedokter_bpjs" AS "t1_c119", "pegawai"."spesialissubspesialis_id" AS "t1_c120" FROM "pegawai_m" "pegawai" WHERE ("pegawai"."pegawai_id" = $1);
Date: 2022-01-14 10:19:08 Duration: 4ms Database: postgres User: db_rsrib_running Remote: developer parameters: $1 = '1203'
5 22s916ms 28,899 0ms 6ms 0ms SELECT * FROM chat WHERE (chat_to = 'meiny' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 13 400 328ms 0ms 14 2,222 1s756ms 0ms 15 2,313 1s811ms 0ms 16 1,182 917ms 0ms 17 1,125 860ms 0ms 18 1,006 793ms 0ms 19 1,139 921ms 0ms 20 1,142 917ms 0ms 21 1,145 906ms 0ms 22 1,133 888ms 0ms 23 932 729ms 0ms 09 1,936 1s587ms 0ms 10 3,590 2s891ms 0ms 11 2,124 1s704ms 0ms 12 2,394 1s858ms 0ms 13 2,076 1s653ms 0ms 14 1,940 1s510ms 0ms 15 1,100 878ms 0ms [ User: developer - Total duration: 1s866ms - Times executed: 28899 ]
[ Application: [unknown] - Total duration: 1s866ms - Times executed: 28899 ]
-
SELECT * FROM chat WHERE (chat_to = 'meiny' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 13:54:51 Duration: 6ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'meiny' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 14:50:17 Duration: 4ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'meiny' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 18:05:33 Duration: 4ms Database: postgres User: db_rsrib_running Remote: developer
6 19s899ms 29,593 0ms 4ms 0ms SELECT * FROM chat WHERE (chat_to = 'sysadmin' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 03 68 42ms 0ms 04 60 36ms 0ms 05 6 7ms 1ms 14 6 3ms 0ms 15 220 174ms 0ms 16 1,887 1s517ms 0ms 17 197 160ms 0ms 18 86 52ms 0ms 19 1,662 1s72ms 0ms 20 39 26ms 0ms 23 16 9ms 0ms 08 2,762 1s916ms 0ms 09 2,394 1s562ms 0ms 10 2,394 1s538ms 0ms 11 1,400 879ms 0ms 12 1,370 841ms 0ms 13 4,244 3s8ms 0ms 14 4,432 3s96ms 0ms 15 2,238 1s459ms 0ms 17 2,394 1s443ms 0ms 18 1,718 1s48ms 0ms [ User: developer - Total duration: 1s294ms - Times executed: 29593 ]
[ Application: [unknown] - Total duration: 1s294ms - Times executed: 29593 ]
-
SELECT * FROM chat WHERE (chat_to = 'sysadmin' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 05:04:00 Duration: 4ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'sysadmin' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 13:31:59 Duration: 3ms Database: postgres User: db_rsbri_simulasi Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'sysadmin' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 16:40:26 Duration: 3ms Database: postgres User: db_rsbri_simulasi Remote: developer
7 18s852ms 29,897 0ms 9ms 0ms UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 623;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 13 438 274ms 0ms 14 2,478 1s551ms 0ms 15 2,313 1s439ms 0ms 16 1,182 728ms 0ms 17 1,125 697ms 0ms 18 1,006 629ms 0ms 19 1,139 742ms 0ms 20 1,142 737ms 0ms 21 1,145 728ms 0ms 22 1,133 713ms 0ms 23 932 586ms 0ms 09 1,952 1s261ms 0ms 10 3,954 2s538ms 0ms 11 2,146 1s384ms 0ms 12 2,394 1s517ms 0ms 13 2,120 1s313ms 0ms 14 2,014 1s210ms 0ms 15 1,284 796ms 0ms [ User: developer - Total duration: 33s520ms - Times executed: 29897 ]
[ Application: [unknown] - Total duration: 33s520ms - Times executed: 29897 ]
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 623;
Date: 2022-01-14 12:18:33 Duration: 9ms Database: postgres User: db_rsrib_running Remote: developer parameters: $1 = 't', $2 = '6', $3 = 'chat', $4 = '2022-01-14 12:18:33'
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 623;
Date: 2022-01-13 13:43:16 Duration: 6ms Database: postgres User: db_rsrib_running Remote: developer parameters: $1 = 't', $2 = '2', $3 = 'chat', $4 = '2022-01-13 13:43:16'
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 623;
Date: 2022-01-14 10:42:42 Duration: 4ms Database: postgres User: db_rsrib_running Remote: developer parameters: $1 = 't', $2 = '2', $3 = 'pendaftaranPenjadwalan/pendaftaranRawatJalan/loadKTP', $4 = '2022-01-14 10:42:42'
8 18s672ms 31,549 0ms 4ms 0ms UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 1;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 03 68 43ms 0ms 04 60 36ms 0ms 05 6 3ms 0ms 14 10 4ms 0ms 15 259 127ms 0ms 16 2,353 1s136ms 0ms 17 245 114ms 0ms 18 165 77ms 0ms 19 2,791 1s416ms 0ms 20 52 30ms 0ms 23 20 10ms 0ms 08 2,864 1s698ms 0ms 09 2,394 1s564ms 0ms 10 2,394 1s580ms 0ms 11 1,400 894ms 0ms 12 1,370 861ms 0ms 13 4,286 2s515ms 0ms 14 4,456 2s634ms 0ms 15 2,238 1s396ms 0ms 17 2,400 1s465ms 0ms 18 1,718 1s58ms 0ms [ User: developer - Total duration: 25s29ms - Times executed: 31549 ]
[ Application: [unknown] - Total duration: 25s29ms - Times executed: 31549 ]
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 1;
Date: 2022-01-14 08:27:25 Duration: 4ms Database: postgres User: db_rsbri_simulasi Remote: developer parameters: $1 = 't', $2 = '1', $3 = 'chat', $4 = '2022-01-14 08:27:25'
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 1;
Date: 2022-01-14 17:04:02 Duration: 3ms Database: postgres User: db_ihospital Remote: developer parameters: $1 = 't', $2 = '356', $3 = 'chat', $4 = '2022-01-14 17:04:02'
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 1;
Date: 2022-01-14 13:44:58 Duration: 3ms Database: postgres User: db_rsbri_simulasi Remote: developer parameters: $1 = 't', $2 = '84', $3 = 'chat', $4 = '2022-01-14 13:44:58'
9 17s23ms 57,520 0ms 4ms 0ms SELECT "pegawai"."pegawai_id" AS "t1_c0", "pegawai"."kabupaten_id" AS "t1_c1", "pegawai"."pangkat_id" AS "t1_c2", "pegawai"."pendkualifikasi_id" AS "t1_c3", "pegawai"."kelurahan_id" AS "t1_c4", "pegawai"."kelompokpegawai_id" AS "t1_c5", "pegawai"."profilrs_id" AS "t1_c6", "pegawai"."pengangkatantphl_id" AS "t1_c7", "pegawai"."pendidikan_id" AS "t1_c8", "pegawai"."loginpemakai_id" AS "t1_c9", "pegawai"."kecamatan_id" AS "t1_c10", "pegawai"."registerpensiun_id" AS "t1_c11", "pegawai"."suku_id" AS "t1_c12", "pegawai"."jabatan_id" AS "t1_c13", "pegawai"."esselon_id" AS "t1_c14", "pegawai"."propinsi_id" AS "t1_c15", "pegawai"."statuskepemilikanrumah_id" AS "t1_c16", "pegawai"."gelarbelakang_id" AS "t1_c17", "pegawai"."nomorindukpegawai" AS "t1_c18", "pegawai"."no_kartupegawainegerisipil" AS "t1_c19", "pegawai"."no_karis_karsu" AS "t1_c20", "pegawai"."no_taspen" AS "t1_c21", "pegawai"."no_askes" AS "t1_c22", "pegawai"."jenisidentitas" AS "t1_c23", "pegawai"."noidentitas" AS "t1_c24", "pegawai"."gelardepan" AS "t1_c25", "pegawai"."nama_pegawai" AS "t1_c26", "pegawai"."nama_keluarga" AS "t1_c27", "pegawai"."tempatlahir_pegawai" AS "t1_c28", "pegawai"."tgl_lahirpegawai" AS "t1_c29", "pegawai"."jeniskelamin" AS "t1_c30", "pegawai"."statusperkawinan" AS "t1_c31", "pegawai"."alamat_pegawai" AS "t1_c32", "pegawai"."agama" AS "t1_c33", "pegawai"."golongandarah" AS "t1_c34", "pegawai"."rhesus" AS "t1_c35", "pegawai"."alamatemail" AS "t1_c36", "pegawai"."notelp_pegawai" AS "t1_c37", "pegawai"."nomobile_pegawai" AS "t1_c38", "pegawai"."warganegara_pegawai" AS "t1_c39", "pegawai"."jeniswaktukerja" AS "t1_c40", "pegawai"."kelompokjabatan" AS "t1_c41", "pegawai"."kategoripegawai" AS "t1_c42", "pegawai"."kategoripegawaiasal" AS "t1_c43", "pegawai"."photopegawai" AS "t1_c44", "pegawai"."nofingerprint" AS "t1_c45", "pegawai"."tinggibadan" AS "t1_c46", "pegawai"."beratbadan" AS "t1_c47", "pegawai"."kemampuanbahasa" AS "t1_c48", "pegawai"."warnakulit" AS "t1_c49", "pegawai"."nip_lama" AS "t1_c50", "pegawai"."no_rekening" AS "t1_c51", "pegawai"."bank_no_rekening" AS "t1_c52", "pegawai"."npwp" AS "t1_c53", "pegawai"."tglditerima" AS "t1_c54", "pegawai"."tglberhenti" AS "t1_c55", "pegawai"."gajipokok" AS "t1_c56", "pegawai"."create_time" AS "t1_c57", "pegawai"."update_time" AS "t1_c58", "pegawai"."create_loginpemakai_id" AS "t1_c59", "pegawai"."update_loginpemakai_id" AS "t1_c60", "pegawai"."create_ruangan" AS "t1_c61", "pegawai"."pegawai_aktif" AS "t1_c62", "pegawai"."suratizinpraktek" AS "t1_c63", "pegawai"."unit_perusahaan" AS "t1_c64", "pegawai"."golonganpegawai_id" AS "t1_c65", "pegawai"."deskripsi" AS "t1_c66", "pegawai"."garis_latitude" AS "t1_c67", "pegawai"."garis_longitude" AS "t1_c68", "pegawai"."jenistenagamedis_id" AS "t1_c69", "pegawai"."tglmasaaktifpeg" AS "t1_c70", "pegawai"."tglmasaaktifpeg_sd" AS "t1_c71", "pegawai"."shift_id" AS "t1_c72", "pegawai"."surattandaregistrasi" AS "t1_c73", "pegawai"."file_kontrak" AS "t1_c74", "pegawai"."masa_str" AS "t1_c75", "pegawai"."masa_sip" AS "t1_c76", "pegawai"."masa_tenagasehat" AS "t1_c77", "pegawai"."masa_medis" AS "t1_c78", "pegawai"."unitkerja_id" AS "t1_c79", "pegawai"."nominal_sip" AS "t1_c80", "pegawai"."alamat_pegawai_ktp" AS "t1_c81", "pegawai"."tglterdaftarnpwp" AS "t1_c82", "pegawai"."tglcatatkepnpwp" AS "t1_c83", "pegawai"."alamatnpwp" AS "t1_c84", "pegawai"."no_bpjs_kesehatan" AS "t1_c85", "pegawai"."no_bpjs_ketenagakerjaan" AS "t1_c86", "pegawai"."ptkp_id" AS "t1_c87", "pegawai"."kode_objekpajak" AS "t1_c88", "pegawai"."keterampilan" AS "t1_c89", "pegawai"."keahlian" AS "t1_c90", "pegawai"."minat" AS "t1_c91", "pegawai"."bakat" AS "t1_c92", "pegawai"."kode_negara" AS "t1_c93", "pegawai"."jenispegawai" AS "t1_c94", "pegawai"."inisial" AS "t1_c95", "pegawai"."cabang_pegawai" AS "t1_c96", "pegawai"."golongan" AS "t1_c97", "pegawai"."grade" AS "t1_c98", "pegawai"."cabang_bank" AS "t1_c99", "pegawai"."atasnama" AS "t1_c100", "pegawai"."tglmasuk_bpjs_ketenagakerjaan" AS "t1_c101", "pegawai"."tglkeluar_bpjs_ketenagakerjaan" AS "t1_c102", "pegawai"."nopeserta_asuransi" AS "t1_c103", "pegawai"."kodegroup_komponen" AS "t1_c104", "pegawai"."levelakses" AS "t1_c105", "pegawai"."nokontrak" AS "t1_c106", "pegawai"."keterangankontrak" AS "t1_c107", "pegawai"."metode_pph_21" AS "t1_c108", "pegawai"."tglpenghapusankemenkes" AS "t1_c109", "pegawai"."pegawaipenghapusankemenkes" AS "t1_c110", "pegawai"."tglpengiriminkemenkes" AS "t1_c111", "pegawai"."pegawaipengirimkemenkes" AS "t1_c112", "pegawai"."tglubahpengirimankemenkes" AS "t1_c113", "pegawai"."pegawaiubahpengirimankemenkes" AS "t1_c114", "pegawai"."logpenghapusandatakemenkes" AS "t1_c115", "pegawai"."statuspengiriman" AS "t1_c116", "pegawai"."dokterprioritas" AS "t1_c117", "pegawai"."kodedokter_bpjs" AS "t1_c118", "pegawai"."kabupaten_domisili_id" AS "t1_c119", "pegawai"."kecamatan_domisili_id" AS "t1_c120", "pegawai"."kelurahan_domisili_id" AS "t1_c121", "pegawai"."propinsi_domisili_id" AS "t1_c122", "pegawai"."kodejabatan_id" AS "t1_c123", "pegawai"."subkelompok_id" AS "t1_c124", "pegawai"."jabatanfungsional_id" AS "t1_c125", "pegawai"."pensiun_usia" AS "t1_c126", "pegawai"."pensiun_tmt" AS "t1_c127", "pegawai"."pensiun_tgledit" AS "t1_c128", "pegawai"."jurusan_id" AS "t1_c129", "pegawai"."eselon_id" AS "t1_c130", "pegawai"."smf_id" AS "t1_c131", "pegawai"."divisi_id" AS "t1_c132", "pegawai"."is_domisili_ktp" AS "t1_c133", "pegawai"."spesialissubspesialis_id" AS "t1_c134" FROM "pegawai_m" "pegawai" WHERE ("pegawai"."pegawai_id" = $1);Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 07 111 27ms 0ms 10 52 13ms 0ms 12 247 67ms 0ms 13 676 213ms 0ms 14 1,328 384ms 0ms 15 593 166ms 0ms 16 1,289 380ms 0ms 18 53 14ms 0ms 19 1,025 313ms 0ms 20 339 99ms 0ms 23 123 39ms 0ms 07 2,330 703ms 0ms 08 5,354 1s580ms 0ms 09 1,394 450ms 0ms 10 19,524 5s923ms 0ms 11 16,812 4s896ms 0ms 12 5,756 1s601ms 0ms 14 464 128ms 0ms 17 50 20ms 0ms [ User: developer - Total duration: 2s201ms - Times executed: 57520 ]
[ Application: [unknown] - Total duration: 2s201ms - Times executed: 57520 ]
-
SELECT "pegawai"."pegawai_id" AS "t1_c0", "pegawai"."kabupaten_id" AS "t1_c1", "pegawai"."pangkat_id" AS "t1_c2", "pegawai"."pendkualifikasi_id" AS "t1_c3", "pegawai"."kelurahan_id" AS "t1_c4", "pegawai"."kelompokpegawai_id" AS "t1_c5", "pegawai"."profilrs_id" AS "t1_c6", "pegawai"."pengangkatantphl_id" AS "t1_c7", "pegawai"."pendidikan_id" AS "t1_c8", "pegawai"."loginpemakai_id" AS "t1_c9", "pegawai"."kecamatan_id" AS "t1_c10", "pegawai"."registerpensiun_id" AS "t1_c11", "pegawai"."suku_id" AS "t1_c12", "pegawai"."jabatan_id" AS "t1_c13", "pegawai"."esselon_id" AS "t1_c14", "pegawai"."propinsi_id" AS "t1_c15", "pegawai"."statuskepemilikanrumah_id" AS "t1_c16", "pegawai"."gelarbelakang_id" AS "t1_c17", "pegawai"."nomorindukpegawai" AS "t1_c18", "pegawai"."no_kartupegawainegerisipil" AS "t1_c19", "pegawai"."no_karis_karsu" AS "t1_c20", "pegawai"."no_taspen" AS "t1_c21", "pegawai"."no_askes" AS "t1_c22", "pegawai"."jenisidentitas" AS "t1_c23", "pegawai"."noidentitas" AS "t1_c24", "pegawai"."gelardepan" AS "t1_c25", "pegawai"."nama_pegawai" AS "t1_c26", "pegawai"."nama_keluarga" AS "t1_c27", "pegawai"."tempatlahir_pegawai" AS "t1_c28", "pegawai"."tgl_lahirpegawai" AS "t1_c29", "pegawai"."jeniskelamin" AS "t1_c30", "pegawai"."statusperkawinan" AS "t1_c31", "pegawai"."alamat_pegawai" AS "t1_c32", "pegawai"."agama" AS "t1_c33", "pegawai"."golongandarah" AS "t1_c34", "pegawai"."rhesus" AS "t1_c35", "pegawai"."alamatemail" AS "t1_c36", "pegawai"."notelp_pegawai" AS "t1_c37", "pegawai"."nomobile_pegawai" AS "t1_c38", "pegawai"."warganegara_pegawai" AS "t1_c39", "pegawai"."jeniswaktukerja" AS "t1_c40", "pegawai"."kelompokjabatan" AS "t1_c41", "pegawai"."kategoripegawai" AS "t1_c42", "pegawai"."kategoripegawaiasal" AS "t1_c43", "pegawai"."photopegawai" AS "t1_c44", "pegawai"."nofingerprint" AS "t1_c45", "pegawai"."tinggibadan" AS "t1_c46", "pegawai"."beratbadan" AS "t1_c47", "pegawai"."kemampuanbahasa" AS "t1_c48", "pegawai"."warnakulit" AS "t1_c49", "pegawai"."nip_lama" AS "t1_c50", "pegawai"."no_rekening" AS "t1_c51", "pegawai"."bank_no_rekening" AS "t1_c52", "pegawai"."npwp" AS "t1_c53", "pegawai"."tglditerima" AS "t1_c54", "pegawai"."tglberhenti" AS "t1_c55", "pegawai"."gajipokok" AS "t1_c56", "pegawai"."create_time" AS "t1_c57", "pegawai"."update_time" AS "t1_c58", "pegawai"."create_loginpemakai_id" AS "t1_c59", "pegawai"."update_loginpemakai_id" AS "t1_c60", "pegawai"."create_ruangan" AS "t1_c61", "pegawai"."pegawai_aktif" AS "t1_c62", "pegawai"."suratizinpraktek" AS "t1_c63", "pegawai"."unit_perusahaan" AS "t1_c64", "pegawai"."golonganpegawai_id" AS "t1_c65", "pegawai"."deskripsi" AS "t1_c66", "pegawai"."garis_latitude" AS "t1_c67", "pegawai"."garis_longitude" AS "t1_c68", "pegawai"."jenistenagamedis_id" AS "t1_c69", "pegawai"."tglmasaaktifpeg" AS "t1_c70", "pegawai"."tglmasaaktifpeg_sd" AS "t1_c71", "pegawai"."shift_id" AS "t1_c72", "pegawai"."surattandaregistrasi" AS "t1_c73", "pegawai"."file_kontrak" AS "t1_c74", "pegawai"."masa_str" AS "t1_c75", "pegawai"."masa_sip" AS "t1_c76", "pegawai"."masa_tenagasehat" AS "t1_c77", "pegawai"."masa_medis" AS "t1_c78", "pegawai"."unitkerja_id" AS "t1_c79", "pegawai"."nominal_sip" AS "t1_c80", "pegawai"."alamat_pegawai_ktp" AS "t1_c81", "pegawai"."tglterdaftarnpwp" AS "t1_c82", "pegawai"."tglcatatkepnpwp" AS "t1_c83", "pegawai"."alamatnpwp" AS "t1_c84", "pegawai"."no_bpjs_kesehatan" AS "t1_c85", "pegawai"."no_bpjs_ketenagakerjaan" AS "t1_c86", "pegawai"."ptkp_id" AS "t1_c87", "pegawai"."kode_objekpajak" AS "t1_c88", "pegawai"."keterampilan" AS "t1_c89", "pegawai"."keahlian" AS "t1_c90", "pegawai"."minat" AS "t1_c91", "pegawai"."bakat" AS "t1_c92", "pegawai"."kode_negara" AS "t1_c93", "pegawai"."jenispegawai" AS "t1_c94", "pegawai"."inisial" AS "t1_c95", "pegawai"."cabang_pegawai" AS "t1_c96", "pegawai"."golongan" AS "t1_c97", "pegawai"."grade" AS "t1_c98", "pegawai"."cabang_bank" AS "t1_c99", "pegawai"."atasnama" AS "t1_c100", "pegawai"."tglmasuk_bpjs_ketenagakerjaan" AS "t1_c101", "pegawai"."tglkeluar_bpjs_ketenagakerjaan" AS "t1_c102", "pegawai"."nopeserta_asuransi" AS "t1_c103", "pegawai"."kodegroup_komponen" AS "t1_c104", "pegawai"."levelakses" AS "t1_c105", "pegawai"."nokontrak" AS "t1_c106", "pegawai"."keterangankontrak" AS "t1_c107", "pegawai"."metode_pph_21" AS "t1_c108", "pegawai"."tglpenghapusankemenkes" AS "t1_c109", "pegawai"."pegawaipenghapusankemenkes" AS "t1_c110", "pegawai"."tglpengiriminkemenkes" AS "t1_c111", "pegawai"."pegawaipengirimkemenkes" AS "t1_c112", "pegawai"."tglubahpengirimankemenkes" AS "t1_c113", "pegawai"."pegawaiubahpengirimankemenkes" AS "t1_c114", "pegawai"."logpenghapusandatakemenkes" AS "t1_c115", "pegawai"."statuspengiriman" AS "t1_c116", "pegawai"."dokterprioritas" AS "t1_c117", "pegawai"."kodedokter_bpjs" AS "t1_c118", "pegawai"."kabupaten_domisili_id" AS "t1_c119", "pegawai"."kecamatan_domisili_id" AS "t1_c120", "pegawai"."kelurahan_domisili_id" AS "t1_c121", "pegawai"."propinsi_domisili_id" AS "t1_c122", "pegawai"."kodejabatan_id" AS "t1_c123", "pegawai"."subkelompok_id" AS "t1_c124", "pegawai"."jabatanfungsional_id" AS "t1_c125", "pegawai"."pensiun_usia" AS "t1_c126", "pegawai"."pensiun_tmt" AS "t1_c127", "pegawai"."pensiun_tgledit" AS "t1_c128", "pegawai"."jurusan_id" AS "t1_c129", "pegawai"."eselon_id" AS "t1_c130", "pegawai"."smf_id" AS "t1_c131", "pegawai"."divisi_id" AS "t1_c132", "pegawai"."is_domisili_ktp" AS "t1_c133", "pegawai"."spesialissubspesialis_id" AS "t1_c134" FROM "pegawai_m" "pegawai" WHERE ("pegawai"."pegawai_id" = $1);
Date: 2022-01-13 16:03:39 Duration: 4ms Database: postgres User: db_ihospital Remote: developer parameters: $1 = '1028'
-
SELECT "pegawai"."pegawai_id" AS "t1_c0", "pegawai"."kabupaten_id" AS "t1_c1", "pegawai"."pangkat_id" AS "t1_c2", "pegawai"."pendkualifikasi_id" AS "t1_c3", "pegawai"."kelurahan_id" AS "t1_c4", "pegawai"."kelompokpegawai_id" AS "t1_c5", "pegawai"."profilrs_id" AS "t1_c6", "pegawai"."pengangkatantphl_id" AS "t1_c7", "pegawai"."pendidikan_id" AS "t1_c8", "pegawai"."loginpemakai_id" AS "t1_c9", "pegawai"."kecamatan_id" AS "t1_c10", "pegawai"."registerpensiun_id" AS "t1_c11", "pegawai"."suku_id" AS "t1_c12", "pegawai"."jabatan_id" AS "t1_c13", "pegawai"."esselon_id" AS "t1_c14", "pegawai"."propinsi_id" AS "t1_c15", "pegawai"."statuskepemilikanrumah_id" AS "t1_c16", "pegawai"."gelarbelakang_id" AS "t1_c17", "pegawai"."nomorindukpegawai" AS "t1_c18", "pegawai"."no_kartupegawainegerisipil" AS "t1_c19", "pegawai"."no_karis_karsu" AS "t1_c20", "pegawai"."no_taspen" AS "t1_c21", "pegawai"."no_askes" AS "t1_c22", "pegawai"."jenisidentitas" AS "t1_c23", "pegawai"."noidentitas" AS "t1_c24", "pegawai"."gelardepan" AS "t1_c25", "pegawai"."nama_pegawai" AS "t1_c26", "pegawai"."nama_keluarga" AS "t1_c27", "pegawai"."tempatlahir_pegawai" AS "t1_c28", "pegawai"."tgl_lahirpegawai" AS "t1_c29", "pegawai"."jeniskelamin" AS "t1_c30", "pegawai"."statusperkawinan" AS "t1_c31", "pegawai"."alamat_pegawai" AS "t1_c32", "pegawai"."agama" AS "t1_c33", "pegawai"."golongandarah" AS "t1_c34", "pegawai"."rhesus" AS "t1_c35", "pegawai"."alamatemail" AS "t1_c36", "pegawai"."notelp_pegawai" AS "t1_c37", "pegawai"."nomobile_pegawai" AS "t1_c38", "pegawai"."warganegara_pegawai" AS "t1_c39", "pegawai"."jeniswaktukerja" AS "t1_c40", "pegawai"."kelompokjabatan" AS "t1_c41", "pegawai"."kategoripegawai" AS "t1_c42", "pegawai"."kategoripegawaiasal" AS "t1_c43", "pegawai"."photopegawai" AS "t1_c44", "pegawai"."nofingerprint" AS "t1_c45", "pegawai"."tinggibadan" AS "t1_c46", "pegawai"."beratbadan" AS "t1_c47", "pegawai"."kemampuanbahasa" AS "t1_c48", "pegawai"."warnakulit" AS "t1_c49", "pegawai"."nip_lama" AS "t1_c50", "pegawai"."no_rekening" AS "t1_c51", "pegawai"."bank_no_rekening" AS "t1_c52", "pegawai"."npwp" AS "t1_c53", "pegawai"."tglditerima" AS "t1_c54", "pegawai"."tglberhenti" AS "t1_c55", "pegawai"."gajipokok" AS "t1_c56", "pegawai"."create_time" AS "t1_c57", "pegawai"."update_time" AS "t1_c58", "pegawai"."create_loginpemakai_id" AS "t1_c59", "pegawai"."update_loginpemakai_id" AS "t1_c60", "pegawai"."create_ruangan" AS "t1_c61", "pegawai"."pegawai_aktif" AS "t1_c62", "pegawai"."suratizinpraktek" AS "t1_c63", "pegawai"."unit_perusahaan" AS "t1_c64", "pegawai"."golonganpegawai_id" AS "t1_c65", "pegawai"."deskripsi" AS "t1_c66", "pegawai"."garis_latitude" AS "t1_c67", "pegawai"."garis_longitude" AS "t1_c68", "pegawai"."jenistenagamedis_id" AS "t1_c69", "pegawai"."tglmasaaktifpeg" AS "t1_c70", "pegawai"."tglmasaaktifpeg_sd" AS "t1_c71", "pegawai"."shift_id" AS "t1_c72", "pegawai"."surattandaregistrasi" AS "t1_c73", "pegawai"."file_kontrak" AS "t1_c74", "pegawai"."masa_str" AS "t1_c75", "pegawai"."masa_sip" AS "t1_c76", "pegawai"."masa_tenagasehat" AS "t1_c77", "pegawai"."masa_medis" AS "t1_c78", "pegawai"."unitkerja_id" AS "t1_c79", "pegawai"."nominal_sip" AS "t1_c80", "pegawai"."alamat_pegawai_ktp" AS "t1_c81", "pegawai"."tglterdaftarnpwp" AS "t1_c82", "pegawai"."tglcatatkepnpwp" AS "t1_c83", "pegawai"."alamatnpwp" AS "t1_c84", "pegawai"."no_bpjs_kesehatan" AS "t1_c85", "pegawai"."no_bpjs_ketenagakerjaan" AS "t1_c86", "pegawai"."ptkp_id" AS "t1_c87", "pegawai"."kode_objekpajak" AS "t1_c88", "pegawai"."keterampilan" AS "t1_c89", "pegawai"."keahlian" AS "t1_c90", "pegawai"."minat" AS "t1_c91", "pegawai"."bakat" AS "t1_c92", "pegawai"."kode_negara" AS "t1_c93", "pegawai"."jenispegawai" AS "t1_c94", "pegawai"."inisial" AS "t1_c95", "pegawai"."cabang_pegawai" AS "t1_c96", "pegawai"."golongan" AS "t1_c97", "pegawai"."grade" AS "t1_c98", "pegawai"."cabang_bank" AS "t1_c99", "pegawai"."atasnama" AS "t1_c100", "pegawai"."tglmasuk_bpjs_ketenagakerjaan" AS "t1_c101", "pegawai"."tglkeluar_bpjs_ketenagakerjaan" AS "t1_c102", "pegawai"."nopeserta_asuransi" AS "t1_c103", "pegawai"."kodegroup_komponen" AS "t1_c104", "pegawai"."levelakses" AS "t1_c105", "pegawai"."nokontrak" AS "t1_c106", "pegawai"."keterangankontrak" AS "t1_c107", "pegawai"."metode_pph_21" AS "t1_c108", "pegawai"."tglpenghapusankemenkes" AS "t1_c109", "pegawai"."pegawaipenghapusankemenkes" AS "t1_c110", "pegawai"."tglpengiriminkemenkes" AS "t1_c111", "pegawai"."pegawaipengirimkemenkes" AS "t1_c112", "pegawai"."tglubahpengirimankemenkes" AS "t1_c113", "pegawai"."pegawaiubahpengirimankemenkes" AS "t1_c114", "pegawai"."logpenghapusandatakemenkes" AS "t1_c115", "pegawai"."statuspengiriman" AS "t1_c116", "pegawai"."dokterprioritas" AS "t1_c117", "pegawai"."kodedokter_bpjs" AS "t1_c118", "pegawai"."kabupaten_domisili_id" AS "t1_c119", "pegawai"."kecamatan_domisili_id" AS "t1_c120", "pegawai"."kelurahan_domisili_id" AS "t1_c121", "pegawai"."propinsi_domisili_id" AS "t1_c122", "pegawai"."kodejabatan_id" AS "t1_c123", "pegawai"."subkelompok_id" AS "t1_c124", "pegawai"."jabatanfungsional_id" AS "t1_c125", "pegawai"."pensiun_usia" AS "t1_c126", "pegawai"."pensiun_tmt" AS "t1_c127", "pegawai"."pensiun_tgledit" AS "t1_c128", "pegawai"."jurusan_id" AS "t1_c129", "pegawai"."eselon_id" AS "t1_c130", "pegawai"."smf_id" AS "t1_c131", "pegawai"."divisi_id" AS "t1_c132", "pegawai"."is_domisili_ktp" AS "t1_c133", "pegawai"."spesialissubspesialis_id" AS "t1_c134" FROM "pegawai_m" "pegawai" WHERE ("pegawai"."pegawai_id" = $1);
Date: 2022-01-14 09:56:52 Duration: 4ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = '1063'
-
SELECT "pegawai"."pegawai_id" AS "t1_c0", "pegawai"."kabupaten_id" AS "t1_c1", "pegawai"."pangkat_id" AS "t1_c2", "pegawai"."pendkualifikasi_id" AS "t1_c3", "pegawai"."kelurahan_id" AS "t1_c4", "pegawai"."kelompokpegawai_id" AS "t1_c5", "pegawai"."profilrs_id" AS "t1_c6", "pegawai"."pengangkatantphl_id" AS "t1_c7", "pegawai"."pendidikan_id" AS "t1_c8", "pegawai"."loginpemakai_id" AS "t1_c9", "pegawai"."kecamatan_id" AS "t1_c10", "pegawai"."registerpensiun_id" AS "t1_c11", "pegawai"."suku_id" AS "t1_c12", "pegawai"."jabatan_id" AS "t1_c13", "pegawai"."esselon_id" AS "t1_c14", "pegawai"."propinsi_id" AS "t1_c15", "pegawai"."statuskepemilikanrumah_id" AS "t1_c16", "pegawai"."gelarbelakang_id" AS "t1_c17", "pegawai"."nomorindukpegawai" AS "t1_c18", "pegawai"."no_kartupegawainegerisipil" AS "t1_c19", "pegawai"."no_karis_karsu" AS "t1_c20", "pegawai"."no_taspen" AS "t1_c21", "pegawai"."no_askes" AS "t1_c22", "pegawai"."jenisidentitas" AS "t1_c23", "pegawai"."noidentitas" AS "t1_c24", "pegawai"."gelardepan" AS "t1_c25", "pegawai"."nama_pegawai" AS "t1_c26", "pegawai"."nama_keluarga" AS "t1_c27", "pegawai"."tempatlahir_pegawai" AS "t1_c28", "pegawai"."tgl_lahirpegawai" AS "t1_c29", "pegawai"."jeniskelamin" AS "t1_c30", "pegawai"."statusperkawinan" AS "t1_c31", "pegawai"."alamat_pegawai" AS "t1_c32", "pegawai"."agama" AS "t1_c33", "pegawai"."golongandarah" AS "t1_c34", "pegawai"."rhesus" AS "t1_c35", "pegawai"."alamatemail" AS "t1_c36", "pegawai"."notelp_pegawai" AS "t1_c37", "pegawai"."nomobile_pegawai" AS "t1_c38", "pegawai"."warganegara_pegawai" AS "t1_c39", "pegawai"."jeniswaktukerja" AS "t1_c40", "pegawai"."kelompokjabatan" AS "t1_c41", "pegawai"."kategoripegawai" AS "t1_c42", "pegawai"."kategoripegawaiasal" AS "t1_c43", "pegawai"."photopegawai" AS "t1_c44", "pegawai"."nofingerprint" AS "t1_c45", "pegawai"."tinggibadan" AS "t1_c46", "pegawai"."beratbadan" AS "t1_c47", "pegawai"."kemampuanbahasa" AS "t1_c48", "pegawai"."warnakulit" AS "t1_c49", "pegawai"."nip_lama" AS "t1_c50", "pegawai"."no_rekening" AS "t1_c51", "pegawai"."bank_no_rekening" AS "t1_c52", "pegawai"."npwp" AS "t1_c53", "pegawai"."tglditerima" AS "t1_c54", "pegawai"."tglberhenti" AS "t1_c55", "pegawai"."gajipokok" AS "t1_c56", "pegawai"."create_time" AS "t1_c57", "pegawai"."update_time" AS "t1_c58", "pegawai"."create_loginpemakai_id" AS "t1_c59", "pegawai"."update_loginpemakai_id" AS "t1_c60", "pegawai"."create_ruangan" AS "t1_c61", "pegawai"."pegawai_aktif" AS "t1_c62", "pegawai"."suratizinpraktek" AS "t1_c63", "pegawai"."unit_perusahaan" AS "t1_c64", "pegawai"."golonganpegawai_id" AS "t1_c65", "pegawai"."deskripsi" AS "t1_c66", "pegawai"."garis_latitude" AS "t1_c67", "pegawai"."garis_longitude" AS "t1_c68", "pegawai"."jenistenagamedis_id" AS "t1_c69", "pegawai"."tglmasaaktifpeg" AS "t1_c70", "pegawai"."tglmasaaktifpeg_sd" AS "t1_c71", "pegawai"."shift_id" AS "t1_c72", "pegawai"."surattandaregistrasi" AS "t1_c73", "pegawai"."file_kontrak" AS "t1_c74", "pegawai"."masa_str" AS "t1_c75", "pegawai"."masa_sip" AS "t1_c76", "pegawai"."masa_tenagasehat" AS "t1_c77", "pegawai"."masa_medis" AS "t1_c78", "pegawai"."unitkerja_id" AS "t1_c79", "pegawai"."nominal_sip" AS "t1_c80", "pegawai"."alamat_pegawai_ktp" AS "t1_c81", "pegawai"."tglterdaftarnpwp" AS "t1_c82", "pegawai"."tglcatatkepnpwp" AS "t1_c83", "pegawai"."alamatnpwp" AS "t1_c84", "pegawai"."no_bpjs_kesehatan" AS "t1_c85", "pegawai"."no_bpjs_ketenagakerjaan" AS "t1_c86", "pegawai"."ptkp_id" AS "t1_c87", "pegawai"."kode_objekpajak" AS "t1_c88", "pegawai"."keterampilan" AS "t1_c89", "pegawai"."keahlian" AS "t1_c90", "pegawai"."minat" AS "t1_c91", "pegawai"."bakat" AS "t1_c92", "pegawai"."kode_negara" AS "t1_c93", "pegawai"."jenispegawai" AS "t1_c94", "pegawai"."inisial" AS "t1_c95", "pegawai"."cabang_pegawai" AS "t1_c96", "pegawai"."golongan" AS "t1_c97", "pegawai"."grade" AS "t1_c98", "pegawai"."cabang_bank" AS "t1_c99", "pegawai"."atasnama" AS "t1_c100", "pegawai"."tglmasuk_bpjs_ketenagakerjaan" AS "t1_c101", "pegawai"."tglkeluar_bpjs_ketenagakerjaan" AS "t1_c102", "pegawai"."nopeserta_asuransi" AS "t1_c103", "pegawai"."kodegroup_komponen" AS "t1_c104", "pegawai"."levelakses" AS "t1_c105", "pegawai"."nokontrak" AS "t1_c106", "pegawai"."keterangankontrak" AS "t1_c107", "pegawai"."metode_pph_21" AS "t1_c108", "pegawai"."tglpenghapusankemenkes" AS "t1_c109", "pegawai"."pegawaipenghapusankemenkes" AS "t1_c110", "pegawai"."tglpengiriminkemenkes" AS "t1_c111", "pegawai"."pegawaipengirimkemenkes" AS "t1_c112", "pegawai"."tglubahpengirimankemenkes" AS "t1_c113", "pegawai"."pegawaiubahpengirimankemenkes" AS "t1_c114", "pegawai"."logpenghapusandatakemenkes" AS "t1_c115", "pegawai"."statuspengiriman" AS "t1_c116", "pegawai"."dokterprioritas" AS "t1_c117", "pegawai"."kodedokter_bpjs" AS "t1_c118", "pegawai"."kabupaten_domisili_id" AS "t1_c119", "pegawai"."kecamatan_domisili_id" AS "t1_c120", "pegawai"."kelurahan_domisili_id" AS "t1_c121", "pegawai"."propinsi_domisili_id" AS "t1_c122", "pegawai"."kodejabatan_id" AS "t1_c123", "pegawai"."subkelompok_id" AS "t1_c124", "pegawai"."jabatanfungsional_id" AS "t1_c125", "pegawai"."pensiun_usia" AS "t1_c126", "pegawai"."pensiun_tmt" AS "t1_c127", "pegawai"."pensiun_tgledit" AS "t1_c128", "pegawai"."jurusan_id" AS "t1_c129", "pegawai"."eselon_id" AS "t1_c130", "pegawai"."smf_id" AS "t1_c131", "pegawai"."divisi_id" AS "t1_c132", "pegawai"."is_domisili_ktp" AS "t1_c133", "pegawai"."spesialissubspesialis_id" AS "t1_c134" FROM "pegawai_m" "pegawai" WHERE ("pegawai"."pegawai_id" = $1);
Date: 2022-01-14 10:18:22 Duration: 3ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = '1495'
10 16s949ms 21,066 0ms 8ms 0ms SELECT * FROM chat WHERE (chat_to = 'sartono' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 09 2,472 2s32ms 0ms 10 7,026 5s727ms 0ms 11 4,108 3s304ms 0ms 13 2,992 2s362ms 0ms 14 3,678 2s873ms 0ms 15 790 649ms 0ms [ User: developer - Total duration: 1s367ms - Times executed: 21066 ]
[ Application: [unknown] - Total duration: 1s367ms - Times executed: 21066 ]
-
SELECT * FROM chat WHERE (chat_to = 'sartono' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 15:01:54 Duration: 8ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'sartono' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 09:43:16 Duration: 8ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'sartono' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 13:49:18 Duration: 7ms Database: postgres User: db_rsrib_running Remote: developer
11 14s206ms 301 42ms 70ms 47ms SELECT * FROM "infokunjunganrj_v" "t" WHERE tgl_pendaftaran BETWEEN $1 AND $2 ORDER BY tgl_pendaftaran DESC LIMIT 10;Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 07 1 44ms 44ms 12 4 178ms 44ms 13 10 450ms 45ms 14 31 1s478ms 47ms 16 3 145ms 48ms 18 1 42ms 42ms 19 3 187ms 62ms 07 30 1s439ms 47ms 08 66 3s118ms 47ms 09 20 959ms 47ms 10 56 2s658ms 47ms 11 44 2s8ms 45ms 12 8 391ms 48ms 14 4 176ms 44ms 15 20 925ms 46ms [ User: developer - Total duration: 537ms - Times executed: 301 ]
[ Application: [unknown] - Total duration: 537ms - Times executed: 301 ]
-
SELECT * FROM "infokunjunganrj_v" "t" WHERE tgl_pendaftaran BETWEEN $1 AND $2 ORDER BY tgl_pendaftaran DESC LIMIT 10;
Date: 2022-01-13 14:19:51 Duration: 70ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = '2022-01-13 00:00:00', $2 = '2022-01-13 23:59:59'
-
SELECT * FROM "infokunjunganrj_v" "t" WHERE tgl_pendaftaran BETWEEN $1 AND $2 ORDER BY tgl_pendaftaran DESC LIMIT 10;
Date: 2022-01-14 08:50:26 Duration: 67ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = '2022-01-14 00:00:00', $2 = '2022-01-14 23:59:59'
-
SELECT * FROM "infokunjunganrj_v" "t" WHERE tgl_pendaftaran BETWEEN $1 AND $2 ORDER BY tgl_pendaftaran DESC LIMIT 10;
Date: 2022-01-13 19:12:52 Duration: 66ms Database: postgres User: db_ihospital Remote: developer parameters: $1 = '2022-01-13 00:00:00', $2 = '2022-01-13 23:59:59'
12 13s719ms 21,666 0ms 4ms 0ms UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 773;Times Reported Time consuming bind #12
Day Hour Count Duration Avg duration 09 2,632 1s624ms 0ms 10 7,140 4s678ms 0ms 11 4,194 2s684ms 0ms 13 3,064 1s889ms 0ms 14 3,820 2s335ms 0ms 15 816 506ms 0ms [ User: developer - Total duration: 17s194ms - Times executed: 21666 ]
[ Application: [unknown] - Total duration: 17s194ms - Times executed: 21666 ]
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 773;
Date: 2022-01-14 10:07:23 Duration: 4ms Database: postgres User: db_rsrib_running Remote: developer parameters: $1 = 't', $2 = '59', $3 = 'chat', $4 = '2022-01-14 10:07:23'
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 773;
Date: 2022-01-14 11:00:37 Duration: 4ms Database: postgres User: db_rsrib_running Remote: developer parameters: $1 = 't', $2 = '59', $3 = 'chat', $4 = '2022-01-14 11:00:37'
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 773;
Date: 2022-01-14 10:26:58 Duration: 4ms Database: postgres User: db_rsrib_running Remote: developer parameters: $1 = 't', $2 = '59', $3 = 'chat', $4 = '2022-01-14 10:26:58'
13 9s313ms 8,883 0ms 12ms 1ms 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 = $1)) ORDER BY kelompokmenu.kelmenu_urutan, menu_urutan;Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 07 22 22ms 1ms 08 3 4ms 1ms 09 13 13ms 1ms 10 19 19ms 1ms 11 1 1ms 1ms 12 36 36ms 1ms 13 190 195ms 1ms 14 581 609ms 1ms 15 46 45ms 0ms 16 107 109ms 1ms 17 2 1ms 0ms 18 31 31ms 1ms 19 374 405ms 1ms 20 14 14ms 1ms 23 2 2ms 1ms 06 2 1ms 0ms 07 280 288ms 1ms 08 846 849ms 1ms 09 524 556ms 1ms 10 2,808 2s987ms 1ms 11 1,644 1s726ms 1ms 12 402 403ms 1ms 13 104 109ms 1ms 14 228 231ms 1ms 15 600 641ms 1ms 17 4 4ms 1ms [ User: developer - Total duration: 5s542ms - Times executed: 8883 ]
[ Application: [unknown] - Total duration: 5s542ms - Times executed: 8883 ]
-
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 = $1)) ORDER BY kelompokmenu.kelmenu_urutan, menu_urutan;
Date: 2022-01-14 11:34:44 Duration: 12ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = '2'
-
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 = $1)) ORDER BY kelompokmenu.kelmenu_urutan, menu_urutan;
Date: 2022-01-14 10:51:10 Duration: 9ms Database: postgres User: db_rsrib_running Remote: developer parameters: $1 = '2'
-
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 = $1)) ORDER BY kelompokmenu.kelmenu_urutan, menu_urutan;
Date: 2022-01-14 10:54:50 Duration: 6ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = '5'
14 9s306ms 11,846 0ms 6ms 0ms SELECT * FROM chat WHERE (chat_to = 'kevin' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 10 986 757ms 0ms 11 1,110 851ms 0ms 12 1,172 908ms 0ms 13 714 572ms 0ms 10 928 750ms 0ms 11 2,886 2s294ms 0ms 12 2,342 1s817ms 0ms 13 1,522 1s204ms 0ms 15 186 151ms 0ms [ User: developer - Total duration: 759ms - Times executed: 11846 ]
[ Application: [unknown] - Total duration: 759ms - Times executed: 11846 ]
-
SELECT * FROM chat WHERE (chat_to = 'kevin' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 10:33:19 Duration: 6ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'kevin' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 13:41:36 Duration: 4ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'kevin' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 13:51:33 Duration: 3ms Database: postgres User: db_rsrib_running Remote: developer
15 7s790ms 152 45ms 75ms 51ms SELECT COUNT(DISTINCT "t"."pendaftaran_id") FROM "infokunjunganrj_v" "t" LEFT OUTER JOIN "pendaftaran_t" "pendaftaran" ON ("t"."pendaftaran_id" = "pendaftaran"."pendaftaran_id") WHERE ((DATE(t.tgl_pendaftaran) BETWEEN $1 AND $2) AND (t.ruangan_id = 452));Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 08 4 196ms 49ms 09 2 96ms 48ms 10 50 2s481ms 49ms 11 78 4s79ms 52ms 12 18 937ms 52ms [ User: developer - Total duration: 329ms - Times executed: 152 ]
[ Application: [unknown] - Total duration: 329ms - Times executed: 152 ]
-
SELECT COUNT(DISTINCT "t"."pendaftaran_id") FROM "infokunjunganrj_v" "t" LEFT OUTER JOIN "pendaftaran_t" "pendaftaran" ON ("t"."pendaftaran_id" = "pendaftaran"."pendaftaran_id") WHERE ((DATE(t.tgl_pendaftaran) BETWEEN $1 AND $2) AND (t.ruangan_id = 452));
Date: 2022-01-14 11:00:29 Duration: 75ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = '2022-01-14', $2 = '2022-01-14'
-
SELECT COUNT(DISTINCT "t"."pendaftaran_id") FROM "infokunjunganrj_v" "t" LEFT OUTER JOIN "pendaftaran_t" "pendaftaran" ON ("t"."pendaftaran_id" = "pendaftaran"."pendaftaran_id") WHERE ((DATE(t.tgl_pendaftaran) BETWEEN $1 AND $2) AND (t.ruangan_id = 452));
Date: 2022-01-14 11:33:54 Duration: 69ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = '2022-01-14', $2 = '2022-01-14'
-
SELECT COUNT(DISTINCT "t"."pendaftaran_id") FROM "infokunjunganrj_v" "t" LEFT OUTER JOIN "pendaftaran_t" "pendaftaran" ON ("t"."pendaftaran_id" = "pendaftaran"."pendaftaran_id") WHERE ((DATE(t.tgl_pendaftaran) BETWEEN $1 AND $2) AND (t.ruangan_id = 452));
Date: 2022-01-14 12:01:11 Duration: 65ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = '2022-01-14', $2 = '2022-01-14'
16 7s714ms 12,183 0ms 6ms 0ms UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 634;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 10 249 155ms 0ms 11 357 220ms 0ms 12 246 152ms 0ms 13 1,145 740ms 0ms 14 680 427ms 0ms 15 156 96ms 0ms 16 156 95ms 0ms 17 60 38ms 0ms 18 6 3ms 0ms 07 1,406 883ms 0ms 08 2,242 1s371ms 0ms 09 1,152 738ms 0ms 10 2,272 1s464ms 0ms 11 1,334 871ms 0ms 12 312 191ms 0ms 13 120 76ms 0ms 14 290 185ms 0ms [ User: developer - Total duration: 8s655ms - Times executed: 12183 ]
[ Application: [unknown] - Total duration: 8s655ms - Times executed: 12183 ]
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 634;
Date: 2022-01-14 11:05:48 Duration: 6ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = 't', $2 = '2', $3 = 'chat', $4 = '2022-01-14 11:05:48'
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 634;
Date: 2022-01-13 13:39:46 Duration: 6ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = 't', $2 = '2', $3 = 'chat', $4 = '2022-01-13 13:39:46'
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 634;
Date: 2022-01-14 08:45:05 Duration: 2ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = 't', $2 = '2', $3 = 'chat', $4 = '2022-01-14 08:45:05'
17 7s595ms 12,093 0ms 7ms 0ms UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 635;Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 10 991 612ms 0ms 11 1,110 680ms 0ms 12 1,172 726ms 0ms 13 714 453ms 0ms 10 1,090 685ms 0ms 11 2,934 1s896ms 0ms 12 2,342 1s455ms 0ms 13 1,522 947ms 0ms 15 218 138ms 0ms [ User: developer - Total duration: 11s97ms - Times executed: 12093 ]
[ Application: [unknown] - Total duration: 11s97ms - Times executed: 12093 ]
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 635;
Date: 2022-01-14 11:28:23 Duration: 7ms Database: postgres User: db_rsrib_running Remote: developer parameters: $1 = 't', $2 = '439', $3 = 'chat', $4 = '2022-01-14 11:28:23'
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 635;
Date: 2022-01-14 10:36:09 Duration: 4ms Database: postgres User: db_rsrib_running Remote: developer parameters: $1 = 't', $2 = '439', $3 = 'chat', $4 = '2022-01-14 10:36:09'
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 635;
Date: 2022-01-14 11:21:19 Duration: 3ms Database: postgres User: db_rsrib_running Remote: developer parameters: $1 = 't', $2 = '433', $3 = 'chat', $4 = '2022-01-14 11:21:19'
18 7s376ms 11,776 0ms 4ms 0ms SELECT * FROM chat WHERE (chat_to = 'annisa' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming bind #18
Day Hour Count Duration Avg duration 10 247 147ms 0ms 11 357 215ms 0ms 12 236 145ms 0ms 13 1,119 711ms 0ms 14 645 408ms 0ms 15 156 96ms 0ms 16 154 92ms 0ms 17 60 36ms 0ms 18 6 3ms 0ms 07 1,336 837ms 0ms 08 2,094 1s288ms 0ms 09 1,128 725ms 0ms 10 2,192 1s403ms 0ms 11 1,324 826ms 0ms 12 312 186ms 0ms 13 120 75ms 0ms 14 290 175ms 0ms [ User: developer - Total duration: 484ms - Times executed: 11776 ]
[ Application: [unknown] - Total duration: 484ms - Times executed: 11776 ]
-
SELECT * FROM chat WHERE (chat_to = 'annisa' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 09:36:32 Duration: 4ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'annisa' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 08:25:31 Duration: 3ms Database: postgres User: db_rskt_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'annisa' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-14 10:29:46 Duration: 3ms Database: postgres User: db_rskt_running Remote: developer
19 7s87ms 9,082 0ms 6ms 0ms SELECT * FROM chat WHERE (chat_to = 'yayuk' AND chat_recd = 0) ORDER BY chat_sent ASC;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 08 219 169ms 0ms 09 1,797 1s381ms 0ms 10 2,133 1s645ms 0ms 11 1,187 916ms 0ms 12 1,149 893ms 0ms 13 781 637ms 0ms 14 1,102 879ms 0ms 15 714 563ms 0ms [ User: developer - Total duration: 577ms - Times executed: 9082 ]
[ Application: [unknown] - Total duration: 577ms - Times executed: 9082 ]
-
SELECT * FROM chat WHERE (chat_to = 'yayuk' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 13:45:31 Duration: 6ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'yayuk' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 09:24:59 Duration: 3ms Database: postgres User: db_rsrib_running Remote: developer
-
SELECT * FROM chat WHERE (chat_to = 'yayuk' AND chat_recd = 0) ORDER BY chat_sent ASC;
Date: 2022-01-13 11:44:30 Duration: 3ms Database: postgres User: db_rsrib_running Remote: developer
20 5s921ms 9,348 0ms 5ms 0ms UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 815;Times Reported Time consuming bind #20
Day Hour Count Duration Avg duration 08 640 398ms 0ms 09 2,370 1s545ms 0ms 10 2,580 1s664ms 0ms 11 2,658 1s632ms 0ms 12 1,068 660ms 0ms 13 32 19ms 0ms [ User: developer - Total duration: 6s636ms - Times executed: 9348 ]
[ Application: [unknown] - Total duration: 6s636ms - Times executed: 9348 ]
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 815;
Date: 2022-01-14 10:06:33 Duration: 5ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = 't', $2 = '452', $3 = 'chat', $4 = '2022-01-14 10:06:33'
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 815;
Date: 2022-01-14 08:51:32 Duration: 5ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = 't', $2 = '452', $3 = 'chat', $4 = '2022-01-14 08:51:32'
-
UPDATE "loginpemakai_k" SET "statuslogin" = $1, "ruanganaktifitas" = $2, "crudaktifitas" = $3, "waktuterakhiraktifitas" = $4 WHERE "loginpemakai_k"."loginpemakai_id" = 815;
Date: 2022-01-14 09:39:30 Duration: 4ms Database: postgres User: db_rskt_running Remote: developer parameters: $1 = 't', $2 = '452', $3 = 'chat', $4 = '2022-01-14 09:39:30'
-
Events
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Errors per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET