CREATE UNIQUE INDEX no_rekam_medik_unique ON public.pasien_m USING btree (no_rekam_medik);

Date: 2022-03-15 13:08:13
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE UNIQUE INDEX tugaspengguna_k_pk ON public.tugaspengguna_k USING btree (tugaspengguna_id);

Date: 2022-03-15 13:08:18
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

ALTER TABLE ONLY public.tugaspengguna_k ADD CONSTRAINT pk_tugaspengguna_t PRIMARY KEY (peranpengguna_id, tugas_nama, controller_nama, action_nama, modul_id);

Date: 2022-03-15 13:08:06
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

ALTER TABLE ONLY public.pasien_m ADD CONSTRAINT pk_pasien_m PRIMARY KEY (pasien_id);

Date: 2022-03-15 13:08:03
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE UNIQUE INDEX pasien_m_pk ON public.pasien_m USING btree (pasien_id);

Date: 2022-03-15 13:08:14
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

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

Date: 2022-03-15 23:00:06
Duration: 2m57s
Database: db_rsih_running
User: developer
Application: Navicat

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

Date: 2022-03-15 23:00:01
Duration: 2m14s
Database: db_rsih_simulasi
User: developer
Application: Navicat

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

Date: 2022-03-15 23:38:17
Duration: 24s541ms
Database: db_rsih_running
User: developer
Application: Navicat

x Hide

CREATE INDEX photopasien ON public.pasien_m USING btree (photopasien);

Date: 2022-03-15 13:08:15
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX controller_nama ON public.tugaspengguna_k USING btree (controller_nama);

Date: 2022-03-15 13:08:08
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX tugaspengguna_aktif ON public.tugaspengguna_k USING btree (tugaspengguna_aktif);

Date: 2022-03-15 13:08:18
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX tugaspengguna_peranpengguna ON public.tugaspengguna_k USING btree (peranpengguna_id);

Date: 2022-03-15 13:08:19
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX fki_pasien_kelompokumur ON public.pasien_m USING btree (kelompokumur_id);

Date: 2022-03-15 13:08:09
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX alamatemail ON public.pasien_m USING btree (alamatemail);

Date: 2022-03-15 13:08:07
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX no_telepon_pasien ON public.pasien_m USING btree (no_telepon_pasien);

Date: 2022-03-15 13:08:13
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX golongandarah ON public.pasien_m USING btree (golongandarah);

Date: 2022-03-15 13:08:10
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX no_identitas_pasien ON public.pasien_m USING btree (no_identitas_pasien);

Date: 2022-03-15 13:08:12
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX alamat_pasien ON public.pasien_m USING btree (alamat_pasien);

Date: 2022-03-15 13:08:07
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX jeniskelamin ON public.pasien_m USING btree (jeniskelamin);

Date: 2022-03-15 13:08:10
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX tempat_lahir ON public.pasien_m USING btree (tempat_lahir);

Date: 2022-03-15 13:08:18
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX nama_pasien ON public.pasien_m USING btree (nama_pasien);

Date: 2022-03-15 13:08:12
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX statusperkawinan ON public.pasien_m USING btree (statusperkawinan);

Date: 2022-03-15 13:08:18
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX statusrekammedis ON public.pasien_m USING btree (statusrekammedis);

Date: 2022-03-15 13:08:18
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX fki_pasien_pekerjaan ON public.pasien_m USING btree (pekerjaan_id);

Date: 2022-03-15 13:08:09
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX tugas_nama ON public.tugaspengguna_k USING btree (tugas_nama);

Date: 2022-03-15 13:08:18
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX agama ON public.pasien_m USING btree (agama);

Date: 2022-03-15 13:08:07
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX no_mobile_pasien ON public.pasien_m USING btree (no_mobile_pasien);

Date: 2022-03-15 13:08:13
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX fki_pasien_kab ON public.pasien_m USING btree (kabupaten_id);

Date: 2022-03-15 13:08:09
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX fki_pasien_pendidikan ON public.pasien_m USING btree (pendidikan_id);

Date: 2022-03-15 13:08:09
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX action_nama ON public.tugaspengguna_k USING btree (action_nama);

Date: 2022-03-15 13:08:07
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX namadepan ON public.pasien_m USING btree (namadepan);

Date: 2022-03-15 13:08:12
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX relationship_1152_fk ON public.tugaspengguna_k USING btree (peranpengguna_id);

Date: 2022-03-15 13:08:15
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX nama_bin ON public.pasien_m USING btree (nama_bin);

Date: 2022-03-15 13:08:12
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX tugaspengguna_modul ON public.tugaspengguna_k USING btree (modul_id);

Date: 2022-03-15 13:08:19
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX no_rekam_medik ON public.pasien_m USING btree (no_rekam_medik);

Date: 2022-03-15 13:08:13
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX fki_pasien_kel ON public.pasien_m USING btree (kelurahan_id);

Date: 2022-03-15 13:08:09
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX fki_pasien_prop ON public.pasien_m USING btree (propinsi_id);

Date: 2022-03-15 13:08:09
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX warga_negara ON public.pasien_m USING btree (warga_negara);

Date: 2022-03-15 13:08:19
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX fki_pasien_kec ON public.pasien_m USING btree (kecamatan_id);

Date: 2022-03-15 13:08:09
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

CREATE INDEX fki_pasien_suku ON public.pasien_m USING btree (suku_id);

Date: 2022-03-15 13:08:09
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

SELECT obj_type, obj_name, pg_catalog.REPLACE(obj_path, '/' || sn.schema_name || '/', '/' || CASE sn.schema_name WHEN 'pg_catalog' THEN 'PostgreSQL Catalog (pg_catalog)' WHEN 'pgagent' THEN 'pgAgent Job Scheduler (pgagent)' WHEN 'information_schema' THEN 'ANSI (information_schema)' ELSE sn.schema_name END || '/') AS obj_path, schema_name, show_node, other_info, CASE WHEN sn.schema_name IN ('pg_catalog', 'pgagent', 'information_schema') THEN CASE WHEN CASE WHEN sn.schema_name = ANY ('{information_schema}') THEN false ELSE true END THEN 'D' ELSE 'O' END ELSE 'N' END AS catalog_level FROM ( SELECT CASE WHEN c.relkind = 'S' THEN 'sequence' WHEN c.relkind = 'v' THEN 'view' WHEN c.relkind = 'm' THEN 'mview' ELSE 'should not happen' END::text AS obj_type, c.relname AS obj_name, ':schema.' || n.oid || ':/' || n.nspname || '/' || CASE WHEN c.relkind = 'S' THEN ':sequence.' WHEN c.relkind = 'v' THEN ':view.' WHEN c.relkind = 'm' THEN ':mview.' ELSE 'should not happen' END || c.oid || ':/' || c.relname AS obj_path, n.nspname AS schema_name, CASE WHEN c.relkind = 'S' THEN True WHEN c.relkind = 'v' THEN True WHEN c.relkind = 'm' THEN True ELSE False END AS show_node, NULL AS other_info FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind in ('S', 'v', 'm') AND CASE WHEN c.relkind in ('S', 'm') THEN CASE WHEN n.nspname = ANY ('{information_schema}') THEN false ELSE true END ELSE true END UNION SELECT CASE WHEN c.relispartition THEN 'partition' ELSE 'table' END::text AS obj_type, c.relname AS obj_name, ':schema.' || n.oid || ':/' || n.nspname || '/' || ( WITH RECURSIVE table_path_data as ( select c.oid as oid, 0 as height, c.relkind, CASE c.relispartition WHEN true THEN ':partition.' ELSE ':table.' END || c.oid || ':/' || c.relname as path union select rel.oid, pt.height + 1 as height, rel.relkind, CASE rel.relispartition WHEN true THEN ':partition.' ELSE ':table.' END || rel.oid || ':/' || rel.relname || '/' || pt.path as path from pg_catalog.pg_class rel JOIN pg_catalog.pg_namespace nsp ON rel.relnamespace = nsp.oid join pg_catalog.pg_inherits inh ON inh.inhparent = rel.oid join table_path_data pt ON inh.inhrelid = pt.oid ) select CASE WHEN relkind = 'p' THEN path ELSE ':table.' || c.oid || ':/' || c.relname END AS path from table_path_data order by height desc limit 1) obj_path, n.nspname AS schema_name, CASE WHEN c.relispartition THEN True ELSE True END AS show_node, NULL AS other_info FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind in ('p', 'r', 't') AND CASE WHEN c.relispartition THEN CASE WHEN n.nspname = ANY ('{information_schema}') THEN false ELSE true END ELSE true END UNION SELECT 'index'::text AS obj_type, cls.relname AS obj_name, ':schema.' || n.oid || ':/' || n.nspname || '/' || case when tab.relkind = 'm' then ':mview.' || tab.oid || ':' || '/' || tab.relname WHEN tab.relkind in ('r', 't', 'p') THEN ( WITH RECURSIVE table_path_data as ( select tab.oid as oid, 0 as height, tab.relkind, CASE tab.relispartition WHEN true THEN ':partition.' ELSE ':table.' END || tab.oid || ':/' || tab.relname as path union select rel.oid, pt.height + 1 as height, rel.relkind, CASE rel.relispartition WHEN true THEN ':partition.' ELSE ':table.' END || rel.oid || ':/' || rel.relname || '/' || pt.path as path from pg_catalog.pg_class rel JOIN pg_catalog.pg_namespace nsp ON rel.relnamespace = nsp.oid join pg_catalog.pg_inherits inh ON inh.inhparent = rel.oid join table_path_data pt ON inh.inhrelid = pt.oid ) select CASE WHEN relkind = 'p' THEN path ELSE ':table.' || tab.oid || ':/' || tab.relname END AS path from table_path_data order by height desc limit 1) end || '/:index.' || cls.oid || ':/' || cls.relname AS obj_path, n.nspname AS schema_name, True AS show_node, NULL AS other_info FROM pg_catalog.pg_index idx JOIN pg_catalog.pg_class cls ON cls.oid = indexrelid JOIN pg_catalog.pg_class tab ON tab.oid = indrelid JOIN pg_catalog.pg_namespace n ON n.oid = tab.relnamespace LEFT JOIN pg_catalog.pg_depend dep ON (dep.classid = cls.tableoid AND dep.objid = cls.oid AND dep.refobjsubid = '0' AND dep.refclassid = ( SELECT oid FROM pg_catalog.pg_class WHERE relname = 'pg_constraint') AND dep.deptype = 'i') LEFT OUTER JOIN pg_catalog.pg_constraint con ON (con.tableoid = dep.refclassid AND con.oid = dep.refobjid) LEFT OUTER JOIN pg_catalog.pg_description des ON des.objoid = cls.oid LEFT OUTER JOIN pg_catalog.pg_description desp ON (desp.objoid = con.oid AND desp.objsubid = 0) WHERE contype IS NULL AND CASE WHEN n.nspname = ANY ('{information_schema}') THEN false ELSE true END UNION SELECT CASE WHEN t.typname IN ('trigger', 'event_trigger') THEN 'trigger_function' WHEN p.prokind = 'p' THEN 'procedure' ELSE 'function' END::text AS obj_type, p.proname AS obj_name, ':schema.' || n.oid || ':/' || n.nspname || '/' || CASE WHEN t.typname IN ('trigger', 'event_trigger') THEN ':trigger_function.' WHEN p.prokind = 'p' THEN ':procedure.' ELSE ':function.' END || p.oid || ':/' || p.proname AS obj_path, n.nspname AS schema_name, CASE WHEN t.typname IN ('trigger', 'event_trigger') THEN True WHEN p.prokind = 'p' THEN True ELSE True END AS show_node, pg_catalog.pg_get_function_identity_arguments(p.oid) AS other_info from pg_catalog.pg_proc p join pg_catalog.pg_namespace n on p.pronamespace = n.oid join pg_catalog.pg_type t on p.prorettype = t.oid join pg_catalog.pg_language lng ON lng.oid = p.prolang WHERE p.prokind IN ('f', 'w', 'p') AND CASE WHEN t.typname IN ('trigger', 'event_trigger') THEN lng.lanname NOT IN ('edbspl', 'sql', 'internal') ELSE true END AND ( CASE WHEN n.nspname = ANY ('{information_schema}') THEN false ELSE true END) UNION select 'event_trigger'::text AS obj_type, evtname AS obj_name, ':event_trigger.' || oid || ':/' || evtname AS obj_path, ''::text AS schema_name, True AS show_node, NULL AS other_info from pg_catalog.pg_event_trigger UNION select 'schema'::text AS obj_type, n.nspname AS obj_name, ':schema.' || n.oid || ':/' || n.nspname as obj_path, n.nspname AS schema_name, True AS show_node, NULL AS other_info from pg_catalog.pg_namespace n where CASE WHEN n.nspname = ANY ('{information_schema}') THEN false ELSE true END UNION select 'column'::text AS obj_type, a.attname AS obj_name, ':schema.' || n.oid || ':/' || n.nspname || '/' || case WHEN t.relkind in ('r', 't', 'p') THEN ':table.' WHEN t.relkind = 'v' THEN ':view.' WHEN t.relkind = 'm' THEN ':mview.' else 'should not happen' end || t.oid || ':/' || t.relname || '/:column.' || a.attnum || ':/' || a.attname AS obj_path, n.nspname AS schema_name, True AS show_node, NULL AS other_info from pg_catalog.pg_attribute a inner join pg_catalog.pg_class t on a.attrelid = t.oid and t.relkind in ('r', 't', 'p', 'v', 'm') left join pg_catalog.pg_namespace n on t.relnamespace = n.oid where a.attnum > 0 and not t.relispartition UNION SELECT CASE WHEN c.contype = 'c' THEN 'check_constraint' WHEN c.contype = 'f' THEN 'foreign_key' WHEN c.contype = 'p' THEN 'primary_key' WHEN c.contype = 'u' THEN 'unique_constraint' WHEN c.contype = 'x' THEN 'exclusion_constraint' END::text AS obj_type, case when tf.relname is null then c.conname else c.conname || ' -> ' || tf.relname end AS obj_name, ':schema.' || n.oid || ':/' || n.nspname || '/' || ( WITH RECURSIVE table_path_data as ( select t.oid as oid, 0 as height, t.relkind, CASE t.relispartition WHEN true THEN ':partition.' ELSE ':table.' END || t.oid || ':/' || t.relname as path union select rel.oid, pt.height + 1 as height, rel.relkind, CASE rel.relispartition WHEN true THEN ':partition.' ELSE ':table.' END || rel.oid || ':/' || rel.relname || '/' || pt.path as path from pg_catalog.pg_class rel JOIN pg_catalog.pg_namespace nsp ON rel.relnamespace = nsp.oid join pg_catalog.pg_inherits inh ON inh.inhparent = rel.oid join table_path_data pt ON inh.inhrelid = pt.oid ) select CASE WHEN relkind = 'p' THEN path ELSE ':table.' || t.oid || ':/' || t.relname END AS path from table_path_data order by height desc limit 1) || CASE WHEN c.contype = 'c' THEN '/:check_constraint.' || c.oid WHEN c.contype = 'f' THEN '/:foreign_key.' || c.oid WHEN c.contype = 'p' THEN '/:primary_key.' || c.conindid WHEN c.contype = 'u' THEN '/:unique_constraint.' || c.conindid WHEN c.contype = 'x' THEN '/:exclusion_constraint.' || c.conindid END || ':/' || case when tf.relname is null then c.conname else c.conname || ' -> ' || tf.relname end AS obj_path, n.nspname AS schema_name, True AS show_node, NULL AS other_info from pg_catalog.pg_constraint c left join pg_catalog.pg_class t on c.conrelid = t.oid left join pg_catalog.pg_class tf on c.confrelid = tf.oid left join pg_catalog.pg_namespace n on t.relnamespace = n.oid where c.contypid = 0 AND c.contype IN ('c', 'f', 'p', 'u', 'x') AND CASE WHEN n.nspname = ANY ('{information_schema}') THEN false ELSE true END UNION select 'rule'::text AS obj_type, r.rulename AS obj_name, ':schema.' || n.oid || ':/' || n.nspname |[...]

Date: 2022-03-15 05:59:08
Duration: 0ms
Database: db_ihospital_simulasi
User: developer
Application: pgAdmin 4 - DB:db_ihospital_simulasi

x Hide

CREATE UNIQUE INDEX reportbugs_r_pk ON public.reportbugs_r USING btree (reportbugs_id);

Date: 2022-03-15 13:08:17
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

ALTER TABLE ONLY public.reportbugs_r ADD CONSTRAINT pk_reportbugs_r PRIMARY KEY (reportbugs_id);

Date: 2022-03-15 13:08:05
Duration: 0ms
Database: db_rsih_simulasi
User: postgres
Application: pg_restore

x Hide

SELECT obj_type, obj_name, pg_catalog.REPLACE(obj_path, '/' || sn.schema_name || '/', '/' || CASE sn.schema_name WHEN 'pg_catalog' THEN 'PostgreSQL Catalog (pg_catalog)' WHEN 'pgagent' THEN 'pgAgent Job Scheduler (pgagent)' WHEN 'information_schema' THEN 'ANSI (information_schema)' ELSE sn.schema_name END || '/') AS obj_path, schema_name, show_node, other_info, CASE WHEN sn.schema_name IN ('pg_catalog', 'pgagent', 'information_schema') THEN CASE WHEN CASE WHEN sn.schema_name = ANY ('{information_schema}') THEN false ELSE true END THEN 'D' ELSE 'O' END ELSE 'N' END AS catalog_level FROM ( SELECT CASE WHEN c.relkind = 'S' THEN 'sequence' WHEN c.relkind = 'v' THEN 'view' WHEN c.relkind = 'm' THEN 'mview' ELSE 'should not happen' END::text AS obj_type, c.relname AS obj_name, ':schema.' || n.oid || ':/' || n.nspname || '/' || CASE WHEN c.relkind = 'S' THEN ':sequence.' WHEN c.relkind = 'v' THEN ':view.' WHEN c.relkind = 'm' THEN ':mview.' ELSE 'should not happen' END || c.oid || ':/' || c.relname AS obj_path, n.nspname AS schema_name, CASE WHEN c.relkind = 'S' THEN True WHEN c.relkind = 'v' THEN True WHEN c.relkind = 'm' THEN True ELSE False END AS show_node, NULL AS other_info FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind in ('S', 'v', 'm') AND CASE WHEN c.relkind in ('S', 'm') THEN CASE WHEN n.nspname = ANY ('{information_schema}') THEN false ELSE true END ELSE true END UNION SELECT CASE WHEN c.relispartition THEN 'partition' ELSE 'table' END::text AS obj_type, c.relname AS obj_name, ':schema.' || n.oid || ':/' || n.nspname || '/' || ( WITH RECURSIVE table_path_data as ( select c.oid as oid, 0 as height, c.relkind, CASE c.relispartition WHEN true THEN ':partition.' ELSE ':table.' END || c.oid || ':/' || c.relname as path union select rel.oid, pt.height + 1 as height, rel.relkind, CASE rel.relispartition WHEN true THEN ':partition.' ELSE ':table.' END || rel.oid || ':/' || rel.relname || '/' || pt.path as path from pg_catalog.pg_class rel JOIN pg_catalog.pg_namespace nsp ON rel.relnamespace = nsp.oid join pg_catalog.pg_inherits inh ON inh.inhparent = rel.oid join table_path_data pt ON inh.inhrelid = pt.oid ) select CASE WHEN relkind = 'p' THEN path ELSE ':table.' || c.oid || ':/' || c.relname END AS path from table_path_data order by height desc limit 1) obj_path, n.nspname AS schema_name, CASE WHEN c.relispartition THEN True ELSE True END AS show_node, NULL AS other_info FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind in ('p', 'r', 't') AND CASE WHEN c.relispartition THEN CASE WHEN n.nspname = ANY ('{information_schema}') THEN false ELSE true END ELSE true END UNION SELECT 'index'::text AS obj_type, cls.relname AS obj_name, ':schema.' || n.oid || ':/' || n.nspname || '/' || case when tab.relkind = 'm' then ':mview.' || tab.oid || ':' || '/' || tab.relname WHEN tab.relkind in ('r', 't', 'p') THEN ( WITH RECURSIVE table_path_data as ( select tab.oid as oid, 0 as height, tab.relkind, CASE tab.relispartition WHEN true THEN ':partition.' ELSE ':table.' END || tab.oid || ':/' || tab.relname as path union select rel.oid, pt.height + 1 as height, rel.relkind, CASE rel.relispartition WHEN true THEN ':partition.' ELSE ':table.' END || rel.oid || ':/' || rel.relname || '/' || pt.path as path from pg_catalog.pg_class rel JOIN pg_catalog.pg_namespace nsp ON rel.relnamespace = nsp.oid join pg_catalog.pg_inherits inh ON inh.inhparent = rel.oid join table_path_data pt ON inh.inhrelid = pt.oid ) select CASE WHEN relkind = 'p' THEN path ELSE ':table.' || tab.oid || ':/' || tab.relname END AS path from table_path_data order by height desc limit 1) end || '/:index.' || cls.oid || ':/' || cls.relname AS obj_path, n.nspname AS schema_name, True AS show_node, NULL AS other_info FROM pg_catalog.pg_index idx JOIN pg_catalog.pg_class cls ON cls.oid = indexrelid JOIN pg_catalog.pg_class tab ON tab.oid = indrelid JOIN pg_catalog.pg_namespace n ON n.oid = tab.relnamespace LEFT JOIN pg_catalog.pg_depend dep ON (dep.classid = cls.tableoid AND dep.objid = cls.oid AND dep.refobjsubid = '0' AND dep.refclassid = ( SELECT oid FROM pg_catalog.pg_class WHERE relname = 'pg_constraint') AND dep.deptype = 'i') LEFT OUTER JOIN pg_catalog.pg_constraint con ON (con.tableoid = dep.refclassid AND con.oid = dep.refobjid) LEFT OUTER JOIN pg_catalog.pg_description des ON des.objoid = cls.oid LEFT OUTER JOIN pg_catalog.pg_description desp ON (desp.objoid = con.oid AND desp.objsubid = 0) WHERE contype IS NULL AND CASE WHEN n.nspname = ANY ('{information_schema}') THEN false ELSE true END UNION SELECT CASE WHEN t.typname IN ('trigger', 'event_trigger') THEN 'trigger_function' WHEN p.prokind = 'p' THEN 'procedure' ELSE 'function' END::text AS obj_type, p.proname AS obj_name, ':schema.' || n.oid || ':/' || n.nspname || '/' || CASE WHEN t.typname IN ('trigger', 'event_trigger') THEN ':trigger_function.' WHEN p.prokind = 'p' THEN ':procedure.' ELSE ':function.' END || p.oid || ':/' || p.proname AS obj_path, n.nspname AS schema_name, CASE WHEN t.typname IN ('trigger', 'event_trigger') THEN True WHEN p.prokind = 'p' THEN True ELSE True END AS show_node, pg_catalog.pg_get_function_identity_arguments(p.oid) AS other_info from pg_catalog.pg_proc p join pg_catalog.pg_namespace n on p.pronamespace = n.oid join pg_catalog.pg_type t on p.prorettype = t.oid join pg_catalog.pg_language lng ON lng.oid = p.prolang WHERE p.prokind IN ('f', 'w', 'p') AND CASE WHEN t.typname IN ('trigger', 'event_trigger') THEN lng.lanname NOT IN ('edbspl', 'sql', 'internal') ELSE true END AND ( CASE WHEN n.nspname = ANY ('{information_schema}') THEN false ELSE true END) AND p.prokind != 'a' UNION select 'event_trigger'::text AS obj_type, evtname AS obj_name, ':event_trigger.' || oid || ':/' || evtname AS obj_path, ''::text AS schema_name, True AS show_node, NULL AS other_info from pg_catalog.pg_event_trigger UNION select 'schema'::text AS obj_type, n.nspname AS obj_name, ':schema.' || n.oid || ':/' || n.nspname as obj_path, n.nspname AS schema_name, True AS show_node, NULL AS other_info from pg_catalog.pg_namespace n where CASE WHEN n.nspname = ANY ('{information_schema}') THEN false ELSE true END UNION select 'column'::text AS obj_type, a.attname AS obj_name, ':schema.' || n.oid || ':/' || n.nspname || '/' || case WHEN t.relkind in ('r', 't', 'p') THEN ':table.' WHEN t.relkind = 'v' THEN ':view.' WHEN t.relkind = 'm' THEN ':mview.' else 'should not happen' end || t.oid || ':/' || t.relname || '/:column.' || a.attnum || ':/' || a.attname AS obj_path, n.nspname AS schema_name, True AS show_node, NULL AS other_info from pg_catalog.pg_attribute a inner join pg_catalog.pg_class t on a.attrelid = t.oid and t.relkind in ('r', 't', 'p', 'v', 'm') left join pg_catalog.pg_namespace n on t.relnamespace = n.oid where a.attnum > 0 and not t.relispartition UNION SELECT CASE WHEN c.contype = 'c' THEN 'check_constraint' WHEN c.contype = 'f' THEN 'foreign_key' WHEN c.contype = 'p' THEN 'primary_key' WHEN c.contype = 'u' THEN 'unique_constraint' WHEN c.contype = 'x' THEN 'exclusion_constraint' END::text AS obj_type, case when tf.relname is null then c.conname else c.conname || ' -> ' || tf.relname end AS obj_name, ':schema.' || n.oid || ':/' || n.nspname || '/' || ( WITH RECURSIVE table_path_data as ( select t.oid as oid, 0 as height, t.relkind, CASE t.relispartition WHEN true THEN ':partition.' ELSE ':table.' END || t.oid || ':/' || t.relname as path union select rel.oid, pt.height + 1 as height, rel.relkind, CASE rel.relispartition WHEN true THEN ':partition.' ELSE ':table.' END || rel.oid || ':/' || rel.relname || '/' || pt.path as path from pg_catalog.pg_class rel JOIN pg_catalog.pg_namespace nsp ON rel.relnamespace = nsp.oid join pg_catalog.pg_inherits inh ON inh.inhparent = rel.oid join table_path_data pt ON inh.inhrelid = pt.oid ) select CASE WHEN relkind = 'p' THEN path ELSE ':table.' || t.oid || ':/' || t.relname END AS path from table_path_data order by height desc limit 1) || CASE WHEN c.contype = 'c' THEN '/:check_constraint.' || c.oid WHEN c.contype = 'f' THEN '/:foreign_key.' || c.oid WHEN c.contype = 'p' THEN '/:primary_key.' || c.conindid WHEN c.contype = 'u' THEN '/:unique_constraint.' || c.conindid WHEN c.contype = 'x' THEN '/:exclusion_constraint.' || c.conindid END || ':/' || case when tf.relname is null then c.conname else c.conname || ' -> ' || tf.relname end AS obj_path, n.nspname AS schema_name, True AS show_node, NULL AS other_info from pg_catalog.pg_constraint c left join pg_catalog.pg_class t on c.conrelid = t.oid left join pg_catalog.pg_class tf on c.confrelid = tf.oid left join pg_catalog.pg_namespace n on t.relnamespace = n.oid where c.contypid = 0 AND c.contype IN ('c', 'f', 'p', 'u', 'x') AND CASE WHEN n.nspname = ANY ('{information_schema}') THEN false ELSE true END UNION select 'rule'::text AS obj_type, r.rulename AS obj_name, ':schema.' || n.oi[...]

Date: 2022-03-15 10:07:50
Duration: 0ms
Database: db_rscms_simulasi
User: developer
Application: pgAdmin 4 - DB:db_rscms_simulasi