Skip to content

Instantly share code, notes, and snippets.

@ryanaslett

ryanaslett/pgsql file IO

Created February 2, 2017 22:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ryanaslett/f1e284a6ff1dcecb18843da82eb41166 to your computer and use it in GitHub Desktop.
Save ryanaslett/f1e284a6ff1dcecb18843da82eb41166 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pgsql file IO
root@ip-172-31-25-132:~# sysdig -r pgsql.scap -c fdbytes_by fd.filename "fd.directory=/var/lib/postgresql/9.1/main/base/16386"
Bytes fd.filename
--------------------------------------------------------------------------------
88.54G 11685
82.67G 11662
849.55M 11666
269.80M 11665
215.53M pg_internal.init
213.22M 11688
199.01M 11689
177.55M 11787
161.56M 11789
140.15M 11669
131.98M 11696
130.90M 11790
116.29M 11709
114.81M 11668
102.05M 11763
93.72M 11701
80.50M 11678
34.62M 11684
34.17M 11687
30.51M 11713
23.98M 11664
23.21M 11683
19.66M 11768
18.81M 11712
17.57M 11750
15.88M 11694
14.80M 11711
14.59M 11662_fsm
14.29M 11696_fsm
14.11M 11685_fsm
root@ip-172-31-25-132:~#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment