This is a cryptographically signed message in MIME format.

--------------ms020509010007030104060907
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable

Hello,

I'd like to know if it is possible to find out the query beeing
processed for some connection? I know theres a "Select * from
pg_stat_activity", but if query is very long it gets "cut" and it is the =

end of it that interests me.

--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050



--------------ms020509010007030104060907
Content-Type: application/pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIGJjCC
Aw8wggJ4oAMCAQICCQCB1aFglJHbtzANBgkqhkiG9w0BAQQFADBNMQswCQYD VQQGEwJMVDEL
MAkGA1UECBMCTFQxDjAMBgNVBAoTBW5Tb2Z0MQ4wDAYDVQQLEwVuU29mdDER MA8GA1UEAxMI
blNvZnQgQ0EwHhcNMDkwNjI1MTgyNDUzWhcNMTAwNjI1MTgyNDUzWjBpMQsw CQYDVQQGEwJM
VDEQMA4GA1UEBxMHVmlsbml1czEOMAwGA1UEChMFblNvZnQxGDAWBgNVBAMT D0p1bGl1cyBU
dXNrZW5pczEeMBwGCSqGSIb3DQEJARYPanVsaXVzQG5zb2Z0Lmx0MIGfMA0G CSqGSIb3DQEB
AQUAA4GNADCBiQKBgQC73A+rjzOkfYrVAGaI/pYg0F8RzO7Dti2hhk+bctS4 Ibaz3uPCQi+7
siuWP6zx8wKF6ck3vNVBOMveZzvmjMFeAXnbbBaf0o2QFZ0L083vJawq7lic fLTI5QTTPqvP
jgC8KBWyvWpq6qy1Q7jp3or7A2FKE3fBo68eKr9l/yfE3wIDAQABo4HaMIHX MAkGA1UdEwQC
MAAwLAYJYIZIAYb4QgENBB8WHU9wZW5TU0wgR2VuZXJhdGVkIENlcnRpZmlj YXRlMB0GA1Ud
DgQWBBRtQ3sJDUF6zNynzZXcGFkSbQVCzTB9BgNVHSMEdjB0gBS/CyhXUMKf LMp4f10XvzPh
YV5vRKFRpE8wTTELMAkGA1UEBhMCTFQxCzAJBgNVBAgTAkxUMQ4wDAYDVQQK EwVuU29mdDEO
MAwGA1UECxMFblNvZnQxETAPBgNVBAMTCG5Tb2Z0IENBggkAgdWhYJSR27Iw DQYJKoZIhvcN
AQEEBQADgYEAeSEQ2HdWubGGZWZf+AUFFdsoiFTe4QL6V3z8X1tk7/nOZHOf HdViQRjoGoeg
MVEr5WEv072Pd6Q9IhE2euAB4gVHy3BM3MKGFgB94irjEpm4uHSpRWHF+yp9 up+51F75M8aG
4tZWtbqd7zU0NXwR1ibRWnprWrpmRwgSiN+xVqYwggMPMIICeKADAgECAgkA gdWhYJSR27cw
DQYJKoZIhvcNAQEEBQAwTTELMAkGA1UEBhMCTFQxCzAJBgNVBAgTAkxUMQ4w DAYDVQQKEwVu
U29mdDEOMAwGA1UECxMFblNvZnQxETAPBgNVBAMTCG5Tb2Z0IENBMB4XDTA5 MDYyNTE4MjQ1
M1oXDTEwMDYyNTE4MjQ1M1owaTELMAkGA1UEBhMCTFQxEDAOBgNVBAcTB1Zp bG5pdXMxDjAM
BgNVBAoTBW5Tb2Z0MRgwFgYDVQQDEw9KdWxpdXMgVHVza2VuaXMxHjAcBgkq hkiG9w0BCQEW
D2p1bGl1c0Buc29mdC5sdDCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA u9wPq48zpH2K
1QBmiP6WINBfEczuw7YtoYZPm3LUuCG2s97jwkIvu7Irlj+s8fMChenJN7zV QTjL3mc75ozB
XgF522wWn9KNkBWdC9PN7yWsKu5YnHy0yOUE0z6rz44AvCgVsr1qauqstUO4 6d6K+wNhShN3
waOvHiq/Zf8nxN8CAwEAAaOB2jCB1zAJBgNVHRMEAjAAMCwGCWCGSAGG+EIB DQQfFh1PcGVu
U1NMIEdlbmVyYXRlZCBDZXJ0aWZpY2F0ZTAdBgNVHQ4EFgQUbUN7CQ1Beszc p82V3BhZEm0F
Qs0wfQYDVR0jBHYwdIAUvwsoV1DCnyzKeH9dF78z4WFeb0ShUaRPME0xCzAJ BgNVBAYTAkxU
MQswCQYDVQQIEwJMVDEOMAwGA1UEChMFblNvZnQxDjAMBgNVBAsTBW5Tb2Z0 MREwDwYDVQQD
EwhuU29mdCBDQYIJAIHVoWCUkduyMA0GCSqGSIb3DQEBBAUAA4GBAHkhENh3 VrmxhmVmX/gF
BRXbKIhU3uEC+ld8/F9bZO/5zmRznx3VYkEY6BqHoDFRK+VhL9O9j3ekPSIR NnrgAeIFR8tw
TNzChhYAfeIq4xKZuLh0qUVhxfsqfbqfudRe+TPGhuLWVrW6ne81NDV8EdYm 0Vp6a1q6ZkcI
EojfsVamMYICmjCCApYCAQEwWjBNMQswCQYDVQQGEwJMVDELMAkGA1UECBMC TFQxDjAMBgNV
BAoTBW5Tb2Z0MQ4wDAYDVQQLEwVuU29mdDERMA8GA1UEAxMIblNvZnQgQ0EC CQCB1aFglJHb
tzAJBgUrDgMCGgUAoIIBljAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwG CSqGSIb3DQEJ
BTEPFw0wOTEwMjIwNzUyMDlaMCMGCSqGSIb3DQEJBDEWBBTYGu6yGHZnzj4O D8uRAb9+kATy
JzBfBgkqhkiG9w0BCQ8xUjBQMAsGCWCGSAFlAwQBAjAKBggqhkiG9w0DBzAO BggqhkiG9w0D
AgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgw aQYJKwYBBAGC
NxAEMVwwWjBNMQswCQYDVQQGEwJMVDELMAkGA1UECBMCTFQxDjAMBgNVBAoT BW5Tb2Z0MQ4w
DAYDVQQLEwVuU29mdDERMA8GA1UEAxMIblNvZnQgQ0ECCQCB1aFglJHbtzBr BgsqhkiG9w0B
CRACCzFcoFowTTELMAkGA1UEBhMCTFQxCzAJBgNVBAgTAkxUMQ4wDAYDVQQK EwVuU29mdDEO
MAwGA1UECxMFblNvZnQxETAPBgNVBAMTCG5Tb2Z0IENBAgkAgdWhYJSR27cw DQYJKoZIhvcN
AQEBBQAEgYAoENxDPTf9GrbXi/yUzp3oCOkAOkGvOhzQtuL6TAZwcXAozAL/ GVEE9vybBeKP
m2THN4Ka0cK3vMmuacpwvT3McEMyKy9o2YdK2QZeAf7dnPr3/qjMPwqgTmDb rVoYC6oxPsk9
PW0ZZewQlqMbjHv8KNmHQq5LmaMwsdTA2O4pjAAAAAAAAA==
--------------ms020509010007030104060907--

On Thu, Oct 22, 2009 at 1:52 AM, Julius Tuskenis <julius [at] nsoft.lt> wrote:
> Hello,
>
> I'd like to know if it is possible to find out the query beeing processed
> for some connection? I know theres a "Select * from pg_stat_activity", but
> if query is very long it gets "cut" and it is the end of it that interests
> me.

I usually log long running queries which gets the whole thing. (I
think...) Logs can get big if you set the minimum too low and log a
lot. But the query only gets logged when it's done, so you might not
have the right connection afterwards. But you'd have the query.

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

This is a cryptographically signed message in MIME format.

--------------ms050701040801050803010501
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable

Thank you. I'll ask to log long lasting queries, but still - isn't there =

a way to see on what postgres works in real time?

2009.10.22 11:14, Scott Marlowe ra=C5=A1=C4=97:
> On Thu, Oct 22, 2009 at 1:52 AM, Julius Tuskenis<julius [at] nsoft.lt> wrot=
e:
>
>> Hello,
>>
>> I'd like to know if it is possible to find out the query beeing proces=
sed
>> for some connection? I know theres a "Select * from pg_stat_activity",=
but
>> if query is very long it gets "cut" and it is the end of it that inter=
ests
>> me.
>>
> I usually log long running queries which gets the whole thing. (I
> think...) Logs can get big if you set the minimum too low and log a
> lot. But the query only gets logged when it's done, so you might not
> have the right connection afterwards. But you'd have the query.
>
>


--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050



--------------ms050701040801050803010501
Content-Type: application/pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIGJjCC
Aw8wggJ4oAMCAQICCQCB1aFglJHbtzANBgkqhkiG9w0BAQQFADBNMQswCQYD VQQGEwJMVDEL
MAkGA1UECBMCTFQxDjAMBgNVBAoTBW5Tb2Z0MQ4wDAYDVQQLEwVuU29mdDER MA8GA1UEAxMI
blNvZnQgQ0EwHhcNMDkwNjI1MTgyNDUzWhcNMTAwNjI1MTgyNDUzWjBpMQsw CQYDVQQGEwJM
VDEQMA4GA1UEBxMHVmlsbml1czEOMAwGA1UEChMFblNvZnQxGDAWBgNVBAMT D0p1bGl1cyBU
dXNrZW5pczEeMBwGCSqGSIb3DQEJARYPanVsaXVzQG5zb2Z0Lmx0MIGfMA0G CSqGSIb3DQEB
AQUAA4GNADCBiQKBgQC73A+rjzOkfYrVAGaI/pYg0F8RzO7Dti2hhk+bctS4 Ibaz3uPCQi+7
siuWP6zx8wKF6ck3vNVBOMveZzvmjMFeAXnbbBaf0o2QFZ0L083vJawq7lic fLTI5QTTPqvP
jgC8KBWyvWpq6qy1Q7jp3or7A2FKE3fBo68eKr9l/yfE3wIDAQABo4HaMIHX MAkGA1UdEwQC
MAAwLAYJYIZIAYb4QgENBB8WHU9wZW5TU0wgR2VuZXJhdGVkIENlcnRpZmlj YXRlMB0GA1Ud
DgQWBBRtQ3sJDUF6zNynzZXcGFkSbQVCzTB9BgNVHSMEdjB0gBS/CyhXUMKf LMp4f10XvzPh
YV5vRKFRpE8wTTELMAkGA1UEBhMCTFQxCzAJBgNVBAgTAkxUMQ4wDAYDVQQK EwVuU29mdDEO
MAwGA1UECxMFblNvZnQxETAPBgNVBAMTCG5Tb2Z0IENBggkAgdWhYJSR27Iw DQYJKoZIhvcN
AQEEBQADgYEAeSEQ2HdWubGGZWZf+AUFFdsoiFTe4QL6V3z8X1tk7/nOZHOf HdViQRjoGoeg
MVEr5WEv072Pd6Q9IhE2euAB4gVHy3BM3MKGFgB94irjEpm4uHSpRWHF+yp9 up+51F75M8aG
4tZWtbqd7zU0NXwR1ibRWnprWrpmRwgSiN+xVqYwggMPMIICeKADAgECAgkA gdWhYJSR27cw
DQYJKoZIhvcNAQEEBQAwTTELMAkGA1UEBhMCTFQxCzAJBgNVBAgTAkxUMQ4w DAYDVQQKEwVu
U29mdDEOMAwGA1UECxMFblNvZnQxETAPBgNVBAMTCG5Tb2Z0IENBMB4XDTA5 MDYyNTE4MjQ1
M1oXDTEwMDYyNTE4MjQ1M1owaTELMAkGA1UEBhMCTFQxEDAOBgNVBAcTB1Zp bG5pdXMxDjAM
BgNVBAoTBW5Tb2Z0MRgwFgYDVQQDEw9KdWxpdXMgVHVza2VuaXMxHjAcBgkq hkiG9w0BCQEW
D2p1bGl1c0Buc29mdC5sdDCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA u9wPq48zpH2K
1QBmiP6WINBfEczuw7YtoYZPm3LUuCG2s97jwkIvu7Irlj+s8fMChenJN7zV QTjL3mc75ozB
XgF522wWn9KNkBWdC9PN7yWsKu5YnHy0yOUE0z6rz44AvCgVsr1qauqstUO4 6d6K+wNhShN3
waOvHiq/Zf8nxN8CAwEAAaOB2jCB1zAJBgNVHRMEAjAAMCwGCWCGSAGG+EIB DQQfFh1PcGVu
U1NMIEdlbmVyYXRlZCBDZXJ0aWZpY2F0ZTAdBgNVHQ4EFgQUbUN7CQ1Beszc p82V3BhZEm0F
Qs0wfQYDVR0jBHYwdIAUvwsoV1DCnyzKeH9dF78z4WFeb0ShUaRPME0xCzAJ BgNVBAYTAkxU
MQswCQYDVQQIEwJMVDEOMAwGA1UEChMFblNvZnQxDjAMBgNVBAsTBW5Tb2Z0 MREwDwYDVQQD
EwhuU29mdCBDQYIJAIHVoWCUkduyMA0GCSqGSIb3DQEBBAUAA4GBAHkhENh3 VrmxhmVmX/gF
BRXbKIhU3uEC+ld8/F9bZO/5zmRznx3VYkEY6BqHoDFRK+VhL9O9j3ekPSIR NnrgAeIFR8tw
TNzChhYAfeIq4xKZuLh0qUVhxfsqfbqfudRe+TPGhuLWVrW6ne81NDV8EdYm 0Vp6a1q6ZkcI
EojfsVamMYICmjCCApYCAQEwWjBNMQswCQYDVQQGEwJMVDELMAkGA1UECBMC TFQxDjAMBgNV
BAoTBW5Tb2Z0MQ4wDAYDVQQLEwVuU29mdDERMA8GA1UEAxMIblNvZnQgQ0EC CQCB1aFglJHb
tzAJBgUrDgMCGgUAoIIBljAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwG CSqGSIb3DQEJ
BTEPFw0wOTEwMjIwODM4MThaMCMGCSqGSIb3DQEJBDEWBBSDdRP/yDelT27G A2lDmvrsddKu
WTBfBgkqhkiG9w0BCQ8xUjBQMAsGCWCGSAFlAwQBAjAKBggqhkiG9w0DBzAO BggqhkiG9w0D
AgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgw aQYJKwYBBAGC
NxAEMVwwWjBNMQswCQYDVQQGEwJMVDELMAkGA1UECBMCTFQxDjAMBgNVBAoT BW5Tb2Z0MQ4w
DAYDVQQLEwVuU29mdDERMA8GA1UEAxMIblNvZnQgQ0ECCQCB1aFglJHbtzBr BgsqhkiG9w0B
CRACCzFcoFowTTELMAkGA1UEBhMCTFQxCzAJBgNVBAgTAkxUMQ4wDAYDVQQK EwVuU29mdDEO
MAwGA1UECxMFblNvZnQxETAPBgNVBAMTCG5Tb2Z0IENBAgkAgdWhYJSR27cw DQYJKoZIhvcN
AQEBBQAEgYCOJYnzAgrzKIt/611ktEDAUvX86AI7Mw6JcWSJ3r7HWoakc3Ao HEwyxh3Sy0g6
zowzT3EKjQeIBzgWrU/vI7eOBk+DzOZiMkbo7T5uBq1HRKXeaNFysYIkGMPh bp38xjYoB0/E
ayJ4p6hIr366BPZZbZjolBRLKcHEvPX69xGXzAAAAAAAAA==
--------------ms050701040801050803010501--

On Thu, Oct 22, 2009 at 2:38 AM, Julius Tuskenis <julius [at] nsoft.lt> wrote:
> Thank you. I'll ask to log long lasting queries, but still - isn't there a
> way to see on what postgres works in real time?

I don't know.

You can adjust it per database btw, so if you have permissions on the
db itself, a simple

alter database smarlowe set log_min_duration_statement=1000;

Pretty sure you have to be a superuser to set that. But no need to
even reload your db.

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

On Thu, Oct 22, 2009 at 10:38 AM, Julius Tuskenis <julius [at] nsoft.lt> wrote:

> Thank you. I'll ask to log long lasting queries, but still - isn't there a
> way to see on what postgres works in real time?

I use pg_top for that.

http://ptop.projects.postgresql.org/

--
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

On Thu, Oct 22, 2009 at 2:50 AM, Jaume Sabater <jsabater [at] gmail.com> wrote:
> On Thu, Oct 22, 2009 at 10:38 AM, Julius Tuskenis <julius [at] nsoft.lt> wrote:
>
>> Thank you. I'll ask to log long lasting queries, but still - isn't there a
>> way to see on what postgres works in real time?
>
> I use pg_top for that.

Does it give full queries, even if they're long? That would be really
useful sometimes.

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Scott Marlowe <scott.marlowe [at] gmail.com> writes:
> Does it give full queries, even if they're long? That would be really
> useful sometimes.

There is no mechanism other than pg_stat_activity for seeing what
another backend is currently doing.

In recent releases you can change track_activity_query_size to set the
cutoff point for truncation of pg_stat_activity's copy of the current
query. This is a straight tradeoff of shared memory space against
capability, and I don't recommend raising the setting to the moon.
But certainly you can make it higher than the default 1K.

regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin