| 362605 |
0:19:31.175403 |
SELECT * FROM view_downtime_oee_v1 |
| 3047211 |
22:55:50.150375 |
START_REPLICATION SLOT "datastream_pis19_staging_7" LOGICAL 23E5/651B3250 ("proto_version" '1', "publication_names" 'datastream_pis19_staging_pub', "messages" 'true') |
| 3046479 |
22:56:31.983412 |
START_REPLICATION SLOT "datastream_slot_pis" LOGICAL 23E5/6553A770 ("proto_version" '1', "publication_names" 'datastream_pub_pis', "messages" 'true') |
| 3046276 |
22:56:42.151235 |
START_REPLICATION SLOT "datastream_slot_wms" LOGICAL 23E5/65306590 ("proto_version" '1', "publication_names" 'datastream_pub_wms', "messages" 'true') |
| 3046294 |
22:56:41.485924 |
START_REPLICATION SLOT "datastream_slot_portox" LOGICAL 23E5/651B3118 ("proto_version" '1', "publication_names" 'datastream_pub_portox', "messages" 'true') |
| 3046299 |
22:56:41.263716 |
START_REPLICATION SLOT "datastream_slot_portal" LOGICAL 23E5/65182630 ("proto_version" '1', "publication_names" 'datastream_pub_portal', "messages" 'true') |
| 3046339 |
22:56:37.531836 |
START_REPLICATION SLOT "datastream_slot" LOGICAL 23E5/6545A6A8 ("proto_version" '1', "publication_names" 'datastream_pub', "messages" 'true') |
| 361865 |
0:20:59.594983 |
SELECT * FROM inventory_dashboard_scrap_report |
| 361866 |
0:20:59.505408 |
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 |
| 371626 |
0:20:59.505408 |
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 |
| 368065 |
0:11:32.845344 |
START_REPLICATION SLOT "debezium_portal_db" LOGICAL 23F6/721899F8 ("proto_version" '1', "publication_names" 'dbz_publication', "messages" 'true') |
| 368325 |
0:11:06.817074 |
START_REPLICATION SLOT "debezium_porto_db" LOGICAL 23F6/719D0DB8 ("proto_version" '1', "publication_names" 'dbz_publication', "messages" 'true') |
| 361869 |
0:20:14.647869 |
SET client_encoding TO 'UTF8';
select * from view_purchase_order_by_total |
| 369423 |
0:08:56.658629 |
DELETE FROM "master_erp_users_groups" WHERE id IN (162924) |
| 362099 |
0:20:37.187264 |
SET client_encoding TO 'UTF8';
select * from view_purchase_request_by_product |
| 371627 |
0:20:59.505408 |
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 |
| 361870 |
0:20:58.739764 |
SELECT * FROM dm_stock_sm_all_plant |
| 361871 |
0:20:57.943666 |
SELECT * FROM view_inventory_adjustment |
| 362119 |
0:20:33.425106 |
SELECT * FROM view_journal_item_balance_per_account2 |
| 362112 |
0:20:15.320968 |
SELECT * FROM view_selisih_sm_vs_bom_v2 |
| 362123 |
0:20:33.034963 |
SELECT * FROM view_si_net_by_product |
| 362124 |
0:20:27.315475 |
SELECT * FROM view_scm_si_net_with_sostate; |
| 362176 |
0:20:25.307750 |
SELECT * FROM view_scm_all_si |
| 362180 |
0:20:23.089116 |
SET client_encoding TO 'UTF8';
select * from view_purchase_order_by_product |
| 362341 |
0:19:58.040163 |
SET client_encoding TO 'UTF8';
SELECT * FROM view_sales_analytic |
| 362236 |
0:20:21.035464 |
SET client_encoding TO 'UTF8';SELECT * FROM view_scm_so_si_net |