| 4026585 |
16:23:08.201844 |
START_REPLICATION SLOT "debezium_porto_db" LOGICAL 1C8E/18FE1DA0 ("proto_version" '1', "publication_names" 'dbz_publication', "messages" 'true') |
| 4026270 |
16:23:41.378502 |
START_REPLICATION SLOT "debezium_portal_db" LOGICAL 1C8E/19090340 ("proto_version" '1', "publication_names" 'dbz_publication', "messages" 'true') |
| 1727338 |
0:04:15.583887 |
select
relname as table_name,
pg_size_pretty(pg_total_relation_size(relid)) as total_size,
pg_size_pretty(pg_relation_size(relid)) as data_size,
pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as external_size
from pg_catalog.pg_statio_user_tables
order by pg_total_relation_size(relid) desc,
pg_relation_size(relid) desc
limit 10;
|
| 1738280 |
0:02:08.270571 |
SET client_encoding TO 'UTF8';
SELECT * FROM getACPMonthly() |
| 1732854 |
0:05:42.162553 |
SELECT * from dm_dokumen_mo
WHERE
plant = 'EVA1'
and DATE(transaction_date + INTERVAL '7 hours') >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '2 months'
AND DATE(transaction_date + INTERVAL '7 hours') <= CURRENT_DATE
ORDER BY 1 DESC, 2;
|
| 1733371 |
0:05:17.379510 |
SELECT * FROM inventory_dashboard_scrap_report |
| 1733372 |
0:05:23.456727 |
select * from view_cogm_price_vs_bom_price_produksi_hfg |
| 1733651 |
0:04:58.033712 |
SELECT * FROM view_selisih_sm_vs_bom_v2 |
| 1733373 |
0:05:23.442954 |
select * from view_cogm_price_vs_bom_price_portelas |
| 1733374 |
0:05:17.396134 |
SELECT * FROM dm_stock_sm_all_plant |
| 1733532 |
0:04:19.401842 |
SELECT * FROM view_production_mrp_rps |
| 1731130 |
0:06:17.075785 |
UPDATE "dms_folder" SET "dms_id" = 'd1517551-9fb6-44ee-9577-5bafbe2a5a0b', "name" = 'Company Home', "write_date" = '2026-05-21 09:04:33.764627', "write_uid" = 1 WHERE id IN (37803) |
| 1733375 |
0:05:23.409991 |
SELECT
mo_date,
plant,
avg(actual_price),
avg(bom_price),
avg(price_difference)
FROM view_cogm_price_vs_bom_price_portelas
GROUP BY 1,
2 |
| 1733465 |
0:05:17.240489 |
SELECT * FROM view_packing_and_production_qty_prs |
| 1734915 |
0:03:56.076858 |
SET client_encoding TO 'UTF8';SELECT * FROM view_scm_so_si_net |
| 1737059 |
0:02:10.159764 |
SET client_encoding TO 'UTF8';
select * from view_sales_invoice_by_total |
| 1733472 |
0:05:17.007054 |
SELECT
nomor_dokumen,
plant,
type,
state,
transaction_date,
date_finished,
CASE
WHEN EXTRACT(DOW FROM transaction_date) = 6 THEN transaction_date + INTERVAL '2 days'
ELSE transaction_date + INTERVAL '1 day'
END::date AS due_date,
(CURRENT_DATE -
CASE
WHEN EXTRACT(DOW FROM transaction_date) = 6 THEN transaction_date + INTERVAL '2 days'
ELSE transaction_date + INTERVAL '1 day'
END::date
)::TEXT AS aging,
'RI' kategori,
lokasi_sumber,
lokasi_tujuan,
'' AS kategori2,
CASE
WHEN date_finished IS NOT NULL THEN
ABS(EXTRACT(DAY FROM date_finished -
CASE
WHEN EXTRACT(DOW FROM transaction_date) = 6 THEN transaction_date + INTERVAL '2 days'
ELSE transaction_date + INTERVAL '1 day'
END
))::int::text
ELSE NULL
END AS overtolerance
FROM view_receive_item_pis
WHERE transaction_dat |
| 1733670 |
0:04:01.831624 |
SET client_encoding TO 'UTF8';
SELECT * FROM view_scm_so_si_leadtime; |
| 1733671 |
0:04:55.505642 |
SELECT * FROM view_si_net_by_product |
| 1734713 |
0:04:13.186507 |
SELECT * FROM view_goods_issue_movement_v2 |
| 1734946 |
0:03:51.057417 |
SELECT * FROM view_so_sc_do_si_by_total |
| 1733676 |
0:04:20.232163 |
SET client_encoding TO 'UTF8';
select * from view_purchase_order_by_total |
| 1734715 |
0:04:13.163089 |
SELECT * FROM view_perhitungan_kardus |
| 1734503 |
0:04:15.232307 |
select * from view_monitoring_dokumen |
| 1734716 |
0:04:13.066622 |
SELECT
nomor_dokumen,
plant,
type,
state,
transaction_date,
date_finished,
CASE
WHEN EXTRACT(DOW FROM transaction_date) = 6 THEN transaction_date + INTERVAL '2 days'
ELSE transaction_date + INTERVAL '1 day'
END::date AS due_date,
(CURRENT_DATE -
CASE
WHEN EXTRACT(DOW FROM transaction_date) = 6 THEN transaction_date + INTERVAL '2 days'
ELSE transaction_date + INTERVAL '1 day'
END::date
)::TEXT AS aging,
'RI' kategori,
lokasi_sumber,
lokasi_tujuan,
'' AS kategori2,
CASE
WHEN date_finished IS NOT NULL THEN
ABS(EXTRACT(DAY FROM date_finished -
CASE
WHEN EXTRACT(DOW FROM transaction_date) = 6 THEN transaction_date + INTERVAL '2 days'
ELSE transaction_date + INTERVAL '1 day'
END
))::int::text
ELSE NULL
END AS overtolerance
FROM view_receive_item_pis
WHERE transaction_dat |
| 1734502 |
0:04:13.259765 |
SELECT * FROM view_ng_by_product |
| 1734761 |
0:04:09.635391 |
SELECT * FROM view_journal_item_balance_per_account2 |
| 1734544 |
0:04:19.021881 |
SELECT * FROM view_qc_ng_lolos |
| 1734576 |
0:04:18.126316 |
WITH lhp_output AS (
SELECT DISTINCT
nomor_lhp AS nomor_dokumen,
default_code AS product_sku,
tanggal_produksi
FROM
dm_lhp_permesin_output
WHERE
-- plant = 'EVA1' AND
warna IS NOT NULL
),
product_cycle_time AS (
SELECT DISTINCT ON (pt.default_code)
pt.default_code AS product_sku,
pt.product_timer,
pt.product_inject_time,
(pt.product_timer + pt.product_inject_time) AS cycle_time_tanpa_semprot,
pt.product_cleaning_semprot
FROM
product_template pt
JOIN product_category pc
ON pt.categ_id = pc.id
WHERE
pt.active = TRUE
AND (
pc.id IN (11, 104, 156)
OR pc.parent_id = 7
)
ORDER BY
pt.default_code,
pt.write_date DESC
)
SELECT
l.nomor_dokumen,
l.tanggal_produksi,
STRING_AGG(DISTINCT l.product_sku, ', ') AS product_sku,
MAX(p.cycle_time_tanpa_semprot) AS cycle_time,
SUM(p.product_cleaning_semprot) AS |
| 1734604 |
0:04:16.948746 |
SELECT
nomor_lhp_permesin,
tanggal_produksi,
multiplikasi_cetakan,
sub_jendela,
counter_total,
total_produk
FROM dm_lhp_permesin
WHERE
-- plant = 'EVA1' AND
DATE(tanggal_produksi + INTERVAL '7 hours') >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '1 month'
AND DATE(tanggal_produksi + INTERVAL '7 hours') <= CURRENT_DATE
-- AND nomor_lhp_permesin = 'EVA3/171225/01/21' |
| 1734760 |
0:04:09.630955 |
select * from function_view_financial_ratio_yearly() |
| 1734748 |
0:04:11.534720 |
select * from function_view_financial_ratio_monthly() |
| 1734615 |
0:04:16.980766 |
SELECT * FROM view_ng_by_type |
| 1735038 |
0:03:56.254700 |
SELECT * FROM view_scm_all_si |
| 1735276 |
0:03:48.966925 |
SET client_encoding TO 'UTF8';
SELECT * FROM view_sales_invoice_by_total |
| 1735270 |
0:03:49.019465 |
SET client_encoding TO 'UTF8';
SELECT * FROM view_sales_analytic |
| 1735569 |
0:03:38.790864 |
SET client_encoding TO 'UTF8'; SELECT * FROM view_do_analysis |
| 1735282 |
0:03:48.854289 |
SET client_encoding TO 'UTF8';
SELECT * FROM view_sales_order_by_product |
| 1735821 |
0:03:27.438275 |
SET client_encoding TO 'UTF8';
SELECT *, amount_total::float FROM view_sales_analytic |
| 1735565 |
0:03:39.127288 |
SELECT * FROM view_scm_si_net_with_sostate; |
| 1735822 |
0:02:21.955893 |
SET client_encoding TO 'UTF8';
SELECT * FROM view_sales_analytic |
| 1735851 |
0:03:25.239949 |
SET client_encoding TO 'UTF8';
SELECT * FROM view_sales_order_by_product |
| 1736193 |
0:03:11.135776 |
select * from view_so_sc_do_si_by_total WHERE so_date >= date_trunc('year', CURRENT_DATE) - INTERVAL '1 years' |
| 1649357 |
0:20:27.109497 |
START_REPLICATION SLOT "datastream_slot_pis_test" LOGICAL 1C9A/A92CC908 ("proto_version" '1', "publication_names" 'datastream_pub_pis_test', "messages" 'true') |
| 1655282 |
0:17:39.690769 |
UPDATE "dms_folder" SET "dms_id" = 'd1517551-9fb6-44ee-9577-5bafbe2a5a0b', "name" = 'Company Home', "write_date" = '2026-05-21 08:53:11.151167', "write_uid" = 1 WHERE id IN (37803) |
| 1720172 |
0:10:51.747972 |
SELECT refresh_all_mviews(); |