Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VsEQU-0004D5-Qq for pgsql-performance@arkaria.postgresql.org; Sun, 15 Dec 2013 16:20:19 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VsEQU-0007ht-6j for pgsql-performance@arkaria.postgresql.org; Sun, 15 Dec 2013 16:20:18 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VsEQS-0007hS-Ok for pgsql-performance@postgresql.org; Sun, 15 Dec 2013 16:20:16 +0000 Received: from mrelay.celltick.com ([212.150.2.147]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VsEQJ-0003PJ-Q8 for pgsql-performance@postgresql.org; Sun, 15 Dec 2013 16:20:15 +0000 Received: from Cobra.celltick.com ([172.17.252.101]) by Cobra.celltick.com ([172.17.252.101]) with mapi id 14.03.0158.001; Sun, 15 Dec 2013 18:18:20 +0200 From: Yuri Levinsky To: "pgsql-performance@postgresql.org" Subject: Current query of the PL/pgsql procedure. Thread-Topic: Current query of the PL/pgsql procedure. Thread-Index: Ac75sUKZGDxYuNp9SiyESE/JhRf7WA== Date: Sun, 15 Dec 2013 16:18:18 +0000 Message-ID: Accept-Language: he-IL, en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-originating-ip: [172.17.252.126] Content-Type: multipart/related; boundary="_004_C9278837BA426D4DBDF8996DB89023260B685BCobracelltickcom_"; type="multipart/alternative" MIME-Version: 1.0 X-Pg-Spam-Score: 0.3 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --_004_C9278837BA426D4DBDF8996DB89023260B685BCobracelltickcom_ Content-Type: multipart/alternative; boundary="_000_C9278837BA426D4DBDF8996DB89023260B685BCobracelltickcom_" --_000_C9278837BA426D4DBDF8996DB89023260B685BCobracelltickcom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Dear ALL, I am running PL/pgsql procedure with sql statements that taking a long time= . I able to see them in the log just after their completion. How can I see = currently running SQL statement? I am able to see in pg_stat_activity only= my call to function. Many thanks in advance. Sincerely yours, [Description: Celltick logo_highres] Yuri Levinsky, DBA Celltick Technologies Ltd., 32 Maskit St., Herzliya 46733, Israel Mobile: +972 54 6107703, Office: +972 9 9710239; Fax: +972 9 9710222 --_000_C9278837BA426D4DBDF8996DB89023260B685BCobracelltickcom_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Dear ALL,

I am running PL/pgsql procedure with sql statemen= ts that taking a long time. I able to see them in the log just after their = completion. How can I see currently running SQL statement?  I am able to see in pg_stat_activity only my call to function. Many thanks= in advance.

 

Sincerely yours,

 =

3D"Description:

Yuri Levinsky, DBA

Celltick Technologies Ltd., 32= Maskit St., Herzliya 46733, Israel

Mobile: +972 54 6107703, O= ffice: +972 9 9710239; Fax: +972 9 9710222

 

--_000_C9278837BA426D4DBDF8996DB89023260B685BCobracelltickcom_-- --_004_C9278837BA426D4DBDF8996DB89023260B685BCobracelltickcom_ Content-Type: image/jpeg; name="image003.jpg" Content-Description: image003.jpg Content-Disposition: inline; filename="image003.jpg"; size=2228; creation-date="Sun, 15 Dec 2013 16:18:18 GMT"; modification-date="Sun, 15 Dec 2013 16:18:18 GMT" Content-ID: Content-Transfer-Encoding: base64 /9j/4AAQSkZJRgABAQEAkACQAAD/2wBDAAoHBwkHBgoJCAkLCwoMDxkQDw4ODx4WFxIZJCAmJSMg IyIoLTkwKCo2KyIjMkQyNjs9QEBAJjBGS0U+Sjk/QD3/2wBDAQsLCw8NDx0QEB09KSMpPT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT3/wAARCAA1AI8DASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2aiii gAooooAKKKKACiiigAooooAKKKSgCKWSOJS8jqqjuTVWa+R7OSS2kWQr/dOa5nx9LcxwwiMkW5Pz layfBhlOrmKEu1sy5fJrkrVJNulBHdDBKVB1eY3/AD5BIJVc7z3rTvdft9Ms4pLrPmOPuDqad/Yi b87z5ZOdtYni7Q7m5liuLVTIqLt29xWOTYGdOo1VejPKxlWpClzQ1ZtaR4htdYJWIlZAOUPWtYcG uE8PadJpEx1LU2FvCq4GTyxrsrO+g1CETWrh09RXr4qMIVOSmycHKtOjz1UXKKwtd8W6XoDRxXk2 64l/1cEY3O34CsuT4jaZaOn9owXVnG5wJJU4zWJ0nY0VDFKs0SSRNlHUEEeh6U5mKg8EkDPHegCS iuY0nxva6t4jm0ZbSeG5hUsxfpikn8b2dv4oh0GS2uFuZj8rEfKaAOooqJpFV1UsAzcAGqWu63a+ HdKl1C/JWCMgEqMnmgDSoqlpmp2+sadFe2bFoZRlSat4JHoaAHUlc14k8bWnhm7toLy3mb7Q4jR1 HGa6JHEkauOjAEUAcxqGqSTXTQywpJCH2+WRzW7ZWFtZxZtYVj3cnikmsbeV2l8seaRgN6Vyl5P4 k02SRF/fRsfkYDoKxweFqc8nOSuLF4xUoqKi7Bq+s6hp3iFN8gFtuztHpXSL4g05lUm7jG7pk15x fNdyXDPfB/OI4LdKXTbJb++itGfbu4LV70sHD2SlJ2PmaWY1I1HGKvfodv4n0l/EOnxGxmRihzjP Bp3hXRptHtHS4kDSOc7VPArKsYL3wxqUcMkjS2dw2xf9k109vYG3ummaUlSOATXiYij7OonT1v1P psPjJ1KXJJWPN/hg8fibxbrfiC5QPIzYh3chB7V6PrWj2ut6VNZXiKUkXrjkH1Feb/CRRofiPW9A mOJoWyue9erkdMdu9WM5e48SRaJPaaBYQyajqCRgGNTjao7k1JpfjKG61w6NqFs9jqIXckTnIcex rh9GgfUPixrsRvJLS4ZRtI6lfSuwi8CRN4ktdYur6ae5tBiPdxxQBi6cAPjjf7QADaDOPXFJ4yJH xW8MnG7arHaO/NO08Y+ON9jp9kH8qPFmR8XfDOO6n+dAED+LdTufiP8AZX0qTZBESIQ4yf8AarpP FfiC30/wwLvV9Ie4t35kgJB2/WsK1Y/8Lvusf8+gzW98SSB4E1LJ42UASx+JtJ0nwjbans+zWciD yoVGTk9AKzr/AOIE2kWkV7qmjTwWEpAEu8EjPQkVxviCY22heBmnx9jV0Mw7Z7Zr1y6sbTVLHybq FJbeQA7GGR7UAcF8UruK+8PaLdW53RS3SMrY5xxXQ6r4tXRr7T9Mispbu5ukG1ImGVHqfQVz/wAW ovsug6VDZqsey6VYxjhT2/Cn/D+9H9u39vryhfEbYJdujxdtntQB3sDSSxK0sfluRymc4rC8Q+JU 0tTb24ElwfXotb8reXG79wMivMobd9d8QPGzHEjksw9K6sLSjKTnNaI83MMROlBU6b96RFNcX2s3 IkeN5XUfdUcCqzeda3AJUxSIcjPBr1SysILCBYoUAAGCccmqOseHLfVYyWG2YfdYV2UsfBPllH3T gqZVU0qJ+8R6JrNrrNrGsoXz06q3X6itrgj5hx6V5zc+GtW0yXzIMuV6MnWrtl4r1K1k+z3duXYD v1rnqYZSblRd0dVDGyguWurNEXjrwxFGw8VafcSWWo243MYxxL7GuT0/4zaxfPHbNa26sW2mQE5/ KiiuE9c6DxtoiwW9v4ysLh7XUolUtsGVk+tL4K+Jt/4kvYbe4tIYwUJZlJycUUUAZGnazP8A8LSl 1Ehd8v7hk7Yo8X61P/wsPTr3aubFtsadjn1oooAueLr6Tw54rsvElqA01zBteFvukfWr/jTxBLqf gK23QpH/AGkCHwc7PpRRQA3RNIh8Z/D5dL1EkC0H7qZPvDHSua0n4lat4dujojhL2OBtiSynDYzi iigDY+J2pzX8OnRHEaptnOOcn0qv4xu2vdJ0jXIgLfUbcgLNH1IHY0UUAdjpHiW41bwnJezRoJlT Bx396x/B+TryuT94E4oor0cOv9nmeLjf97pno1KKKK85bHtDX+7VZtNtWuvtDRKZMYziiimm1sTK Ke6P/9k= --_004_C9278837BA426D4DBDF8996DB89023260B685BCobracelltickcom_--