Technical Blog

Show all queries running in PostgreSQL database

Sometimes its useful to check what all queries are running in the database when debugging.
Using tcpdump command we can do this.
So for postgresql just execute this command in terminal

sudo tcpdump -i lo -s0 -nl -w- dst port postgres | strings -n8

This will show all queries running in database.
Posted by Unknown No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)
Buy Apple MacBook Pro MF840HN/A Notebook (Intel Core i5- 8GBRAM- 256GB ... from Snapdeal

Blog Archive

  • ►  2015 (1)
    • ►  January (1)
  • ►  2014 (6)
    • ►  December (1)
    • ►  October (1)
    • ►  September (1)
    • ►  May (1)
    • ►  March (1)
    • ►  February (1)
  • ▼  2013 (10)
    • ►  September (1)
    • ►  August (1)
    • ►  July (3)
    • ▼  May (1)
      • Show all queries running in PostgreSQL database
    • ►  February (1)
    • ►  January (3)
  • ►  2012 (4)
    • ►  December (1)
    • ►  September (2)
    • ►  July (1)
  • ►  2011 (1)
    • ►  January (1)
  • ►  2010 (7)
    • ►  December (4)
    • ►  June (2)
    • ►  March (1)
  • ►  2009 (23)
    • ►  December (18)
    • ►  November (2)
    • ►  October (3)

About Me

Unknown
View my complete profile

Categories

  • DOS [COMMAND] (4)
  • Java (2)
  • JavaScript (2)
  • Linux (1)
  • MDX (1)
  • Mondrian (1)
  • postgres (1)
  • Registry Hack (6)
  • Trick (16)
  • Virus (4)
Simple theme. Powered by Blogger.