当方linux環境でPostgresSqlを使用しています。
原因もこれがなんなのかも不明で申し訳ないのですが、毎日特定の時間にプロセスがはしり?ACCESS SHARE LOCKが走っているようで、原因に心当たりのある方がいらっしゃいましたらご教示願えましたら幸いです。
ちなみに下記のクエリを実行しているプログラムを探したのですが見当たりませんでした・・・
select * from pg_stat_activity; 【上記を実行したところ、プロセス上で流れていると思われるクエリ↓】 SELECT typinput='array_in'::regproc, typtype FROM pg_catalog.pg_type LEFT JOIN (select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r ] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r using ( nspname ) ) as sp ON sp.nspoid = typnamespace WHERE typname = $1 ORDER BY sp.r, pg_type.oid DESC LIMIT 1 【テーブルのロック状態】 SELECT l.pid, db.datname, c.relname, l.locktype, l.mode FROM pg_locks l LEFT JOIN pg_class c ON l.relation=c.relfilenode LEFT JOIN pg_database db ON l.database = db.oid ORDER BY l.pid; pid | granted | datname | locktype | relation | relation | transactionid | mode ------+---------+---------+------------+----------+----------------------------+---------------+----------------- 1095 | t | testdb | relation | 2684 | pg_namespace_nspname_index | | AccessShareLock 1095 | t | testdb | relation | 2704 | pg_type_typname_nsp_index | | AccessShareLock 1095 | t | testdb | relation | 2703 | pg_type_oid_index | | AccessShareLock 1095 | t | testdb | relation | 2615 | pg_namespace | | AccessShareLock 1095 | t | testdb | relation | 1247 | pg_type | | AccessShareLock 1095 | t | testdb | relation | 122973 | pk_mst_____test | | AccessShareLock 1095 | t | testdb | relation | 123195 | pk_trn_receipt_base | | AccessShareLock 1095 | t | testdb | relation | 121979 | mst_____test | | AccessShareLock 1095 | t | testdb | relation | 122547 | trn____test_test | | AccessShareLock 1095 | t | testdb | relation | 123075 | pk_mst__test | | AccessShareLock 1095 | t | | virtualxid | | | | ExclusiveLock 1095 | t | testdb | relation | 122220 | mst__test | | AccessShareLock 1095 | t | testdb | relation | 2685 | pg_namespace_oid_index | | AccessShareLock 1342 | t | testdb | relation | 122220 | mst__test | | AccessShareLock 1342 | t | testdb | relation | 2684 | pg_namespace_nspname_index | | AccessShareLock 1342 | t | testdb | relation | 2704 | pg_type_typname_nsp_index | | AccessShareLock 1342 | t | testdb | relation | 2703 | pg_type_oid_index | | AccessShareLock 1342 | t | testdb | relation | 2615 | pg_namespace | | AccessShareLock 1342 | t | testdb | relation | 1247 | pg_type | | AccessShareLock 1342 | t | testdb | relation | 122973 | pk_mst_____test | | AccessShareLock 1342 | t | testdb | relation | 123195 | pk_trn_receipt_base | | AccessShareLock 1342 | t | testdb | relation | 121979 | mst_____test | | AccessShareLock 1342 | t | testdb | relation | 122547 | trn_receipt_base | | AccessShareLock 1342 | t | testdb | relation | 123075 | pk_mst__test | | AccessShareLock 1342 | t | | virtualxid | | | | ExclusiveLock 1342 | t | testdb | relation | 2685 | pg_namespace_oid_index | | AccessShareLock 1627 | t | testdb | relation | 2704 | pg_type_typname_nsp_index | | AccessShareLock 1627 | t | testdb | relation | 2703 | pg_type_oid_index | | AccessShareLock 1627 | t | testdb | relation | 2615 | pg_namespace | | AccessShareLock 1627 | t | testdb | relation | 1247 | pg_type | | AccessShareLock 1627 | t | testdb | relation | 122973 | pk_mst_____test | | AccessShareLock 1627 | t | testdb | relation | 123195 | pk_trn_receipt_base | | AccessShareLock 1627 | t | testdb | relation | 121979 | mst_____test | | AccessShareLock 1627 | t | testdb | relation | 122547 | trn_receipt_base | | AccessShareLock 1627 | t | testdb | relation | 123075 | pk_mst__test | | AccessShareLock 1627 | t | | virtualxid | | | | ExclusiveLock 1627 | t | testdb | relation | 122220 | mst__test | | AccessShareLock 1627 | t | testdb | relation | 2685 | pg_namespace_oid_index | | AccessShareLock 1627 | t | testdb | relation | 2684 | pg_namespace_nspname_index | | AccessShareLock
情報が少なく申し訳ございません、なにか他に確認すべきこと等ございましたら併せてコメント頂けませんでしょうか。
何卒宜しくお願い致します。
回答1件
あなたの回答
tips
プレビュー