Re: very slow selects on a small table - Mailing list pgsql-performance
| From | Brian Cox |
|---|---|
| Subject | Re: very slow selects on a small table |
| Date | |
| Msg-id | 4A397303.7030207@ca.com Whole thread Raw |
| In response to | very slow selects on a small table (Brian Cox <brian.cox@ca.com>) |
| Responses |
Re: very slow selects on a small table
|
| List | pgsql-performance |
Tom Lane [tgl@sss.pgh.pa.us] wrote:
> That is a pretty odd trace for a Postgres backend; apparently it's
> repeatedly acquiring and releasing a meg or two worth of memory, which
> is not very normal within a single query. Can you tell us more about
> the query it's running? An EXPLAIN plan would be particularly
> interesting. Also, could you try to determine which files 144 and 65
> refer to (see lsof)?
Here's the explain and a current strace and lsof. The strace shows even
less I/O activity.
Thanks,
Brian
cemdb=# explain select * from ts_stats_transetgroup_user_daily a where
a.ts_id in (select b.ts_id from ts_stats_transetgroup_user_daily
b,ts_stats_transet_user_interval c, ts_transetgroup_transets_map m where
b.ts_transet_group_id = m.ts_transet_group_id and
m.ts_transet_incarnation_id = c.ts_transet_incarnation_id and
c.ts_user_incarnation_id = b.ts_user_incarnation_id and
c.ts_interval_start_time >= '2009-6-16 01:00' and
c.ts_interval_start_time < '2009-6-16 02:00');
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Hash IN Join (cost=128162.63..211221.43 rows=231127 width=779)
Hash Cond: (a.ts_id = b.ts_id)
-> Seq Scan on ts_stats_transetgroup_user_daily a
(cost=0.00..80511.26 rows=247451 width=779)
-> Hash (cost=126718.09..126718.09 rows=231127 width=8)
-> Hash Join (cost=82370.45..126718.09 rows=231127 width=8)
Hash Cond: ((m.ts_transet_group_id =
b.ts_transet_group_id) AND (c.ts_user_incarnation_id =
b.ts_user_incarnation_id))
-> Hash Join (cost=3.32..27316.61 rows=211716 width=16)
Hash Cond: (c.ts_transet_incarnation_id =
m.ts_transet_incarnation_id)
-> Index Scan using
ts_stats_transet_user_interval_starttime on
ts_stats_transet_user_interval c (cost=0.00..25857.75 rows=211716 width=16)
Index Cond: ((ts_interval_start_time >=
'2009-06-16 01:00:00-07'::timestamp with time zone) AND
(ts_interval_start_time < '2009-06-16 02:00:00-07'::timestamp with time
zone))
-> Hash (cost=2.58..2.58 rows=117 width=16)
-> Seq Scan on ts_transetgroup_transets_map
m (cost=0.00..2.58 rows=117 width=16)
-> Hash (cost=80511.26..80511.26 rows=247451 width=24)
-> Seq Scan on ts_stats_transetgroup_user_daily b
(cost=0.00..80511.26 rows=247451 width=24)
(14 rows)
[root@rdl64xeoserv01 log]# strace -p 7397
Process 7397 attached - interrupt to quit
mmap2(NULL, 266240, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x95515000
mmap2(NULL, 528384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x95494000
mmap2(NULL, 1052672, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS,
-1, 0) = 0x95393000
munmap(0x95393000, 1052672) = 0
munmap(0x95494000, 528384) = 0
munmap(0x95515000, 266240) = 0
brk(0x8603000) = 0x8603000
brk(0x85fb000) = 0x85fb000
_llseek(164, 0, [201940992], SEEK_END) = 0
brk(0x85eb000) = 0x85eb000
brk(0x8613000) = 0x8613000
mmap2(NULL, 266240, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x95515000
mmap2(NULL, 528384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x95494000
mmap2(NULL, 1052672, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS,
-1, 0) = 0x95393000
munmap(0x95393000, 1052672) = 0
munmap(0x95494000, 528384) = 0
munmap(0x95515000, 266240) = 0
brk(0x8603000) = 0x8603000
brk(0x85fb000) = 0x85fb000
_llseek(164, 0, [201940992], SEEK_END) = 0
brk(0x85eb000) = 0x85eb000
brk(0x8613000) = 0x8613000
mmap2(NULL, 266240, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x95515000
mmap2(NULL, 528384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x95494000
mmap2(NULL, 1052672, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS,
-1, 0) = 0x95393000
munmap(0x95393000, 1052672) = 0
munmap(0x95494000, 528384) = 0
munmap(0x95515000, 266240) = 0
brk(0x8603000) = 0x8603000
brk(0x85fb000) = 0x85fb000
_llseek(164, 0, [201940992], SEEK_END) = 0
brk(0x85eb000) = 0x85eb000
brk(0x8613000) = 0x8613000
mmap2(NULL, 266240, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x95515000
mmap2(NULL, 528384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x95494000
mmap2(NULL, 1052672, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS,
-1, 0) = 0x95393000
munmap(0x95393000, 1052672) = 0
munmap(0x95494000, 528384) = 0
munmap(0x95515000, 266240) = 0
brk(0x8603000) = 0x8603000
brk(0x85fb000) = 0x85fb000
_llseek(164, 0, [201940992], SEEK_END) = 0
[root@rdl64xeoserv01 log]# lsof -p 7397
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
postmaste 7397 postgres cwd DIR 8,2 4096 12681488
/var/lib/pgsql/data
postmaste 7397 postgres rtd DIR 8,2 4096 2 /
postmaste 7397 postgres txt REG 8,2 3304132 3514609
/usr/bin/postgres
postmaste 7397 postgres mem REG 8,2 45889 4718642
/lib/libnss_files-2.3.4.so
postmaste 7397 postgres mem REG 8,2 136016 3510667
/usr/lib/libk5crypto.so.3.0
postmaste 7397 postgres mem REG 8,2 202976 3514362
/usr/lib/libldap-2.2.so.7.0.6
postmaste 7397 postgres mem REG 8,2 48548 3514621
/usr/lib/liblber-2.2.so.7.0.6
postmaste 7397 postgres mem REG 8,2 82320 3514622
/usr/lib/libsasl2.so.2.0.19
postmaste 7397 postgres mem REG 8,2 106397 4719545
/lib/ld-2.3.4.so
postmaste 7397 postgres mem REG 8,2 7004 4719556
/lib/libcom_err.so.2.1
postmaste 7397 postgres mem REG 8,2 1454802 4719546
/lib/tls/libc-2.3.4.so
postmaste 7397 postgres mem REG 8,2 15324 4719549
/lib/libdl-2.3.4.so
postmaste 7397 postgres mem REG 8,2 178019 4719550
/lib/tls/libm-2.3.4.so
postmaste 7397 postgres mem REG 8,2 63624 3512751
/usr/lib/libz.so.1.2.1.2
postmaste 7397 postgres mem REG 8,2 27191 4719553
/lib/libcrypt-2.3.4.so
postmaste 7397 postgres mem REG 8,2 79488 4719551
/lib/libresolv-2.3.4.so
postmaste 7397 postgres mem REG 8,2 32024 4718594
/lib/libpam.so.0.77
postmaste 7397 postgres mem REG 8,2 60116 4718721
/lib/libaudit.so.0.0.0
postmaste 7397 postgres mem REG 8,2 82944 3514353
/usr/lib/libgssapi_krb5.so.2.2
postmaste 7397 postgres mem REG 8,2 415188 3514352
/usr/lib/libkrb5.so.3.2
postmaste 7397 postgres mem REG 8,2 213600 24708638
/opt/PostgreSQL/8.3/lib/libssl.so.0.9.7a
postmaste 7397 postgres mem REG 8,2 945120 24708627
/opt/PostgreSQL/8.3/lib/libcrypto.so.0.9.7a
postmaste 7397 postgres DEL REG 0,6 5177344
/SYSV0052e2c1
postmaste 7397 postgres mem REG 8,2 48533072 3509415
/usr/lib/locale/locale-archive
postmaste 7397 postgres 0r CHR 1,3 1969 /dev/null
postmaste 7397 postgres 1w FIFO 0,7 9913597 pipe
postmaste 7397 postgres 2w FIFO 0,7 9913597 pipe
postmaste 7397 postgres 3u REG 8,2 368640 12812420
/var/lib/pgsql/data/base/26611279/1259
postmaste 7397 postgres 4u REG 8,2 8192 12812368
/var/lib/pgsql/data/base/26611279/2601
postmaste 7397 postgres 5u REG 8,2 8192 12812341
/var/lib/pgsql/data/base/26611279/2615
postmaste 7397 postgres 6u REG 8,2 16384 12812326
/var/lib/pgsql/data/base/26611279/2684
postmaste 7397 postgres 7u IPv4 9913600 UDP
localhost.localdomain:35057->localhost.localdomain:35057
postmaste 7397 postgres 8u IPv4 10045960 TCP
localhost.localdomain:postgres->localhost.localdomain:53377 (ESTABLISHED)
postmaste 7397 postgres 9u REG 8,2 16384 12812366
/var/lib/pgsql/data/base/26611279/2685
postmaste 7397 postgres 10u REG 8,2 253952 12812354
/var/lib/pgsql/data/base/26611279/2662
postmaste 7397 postgres 11u REG 8,2 286720 12812359
/var/lib/pgsql/data/base/26611279/2663
postmaste 7397 postgres 12u REG 8,2 131072 12812365
/var/lib/pgsql/data/base/26611279/2609
postmaste 7397 postgres 13u REG 8,2 98304 12812430
/var/lib/pgsql/data/base/26611279/2675
postmaste 7397 postgres 14u REG 8,2 2097152 12812406
/var/lib/pgsql/data/base/26611279/1249
postmaste 7397 postgres 15u REG 8,2 1130496 12812363
/var/lib/pgsql/data/base/26611279/2659
postmaste 7397 postgres 16u REG 8,2 122880 12812373
/var/lib/pgsql/data/base/26611279/2604
postmaste 7397 postgres 17u REG 8,2 16384 12813349
/var/lib/pgsql/data/base/26611279/27241082
postmaste 7397 postgres 18u REG 8,2 16777216 26427412
/var/lib/pgsql/data/pg_xlog/00000001000002C30000001E (deleted)
postmaste 7397 postgres 19u REG 8,2 16384 12813350
/var/lib/pgsql/data/base/26611279/27241083
postmaste 7397 postgres 20u REG 8,2 16384 12813351
/var/lib/pgsql/data/base/26611279/27241084
postmaste 7397 postgres 21u REG 8,2 16384 12813352
/var/lib/pgsql/data/base/26611279/27241085
postmaste 7397 postgres 22u REG 8,2 16384 12813353
/var/lib/pgsql/data/base/26611279/27241086
postmaste 7397 postgres 23u REG 8,2 16384 12813354
/var/lib/pgsql/data/base/26611279/27241087
postmaste 7397 postgres 24u REG 8,2 16384 12813355
/var/lib/pgsql/data/base/26611279/27241088
postmaste 7397 postgres 25u REG 8,2 16384 12813356
/var/lib/pgsql/data/base/26611279/27241089
postmaste 7397 postgres 26u REG 8,2 16384 12813357
/var/lib/pgsql/data/base/26611279/27241090
postmaste 7397 postgres 27u REG 8,2 16384 12813358
/var/lib/pgsql/data/base/26611279/27241091
postmaste 7397 postgres 28u REG 8,2 1073741824 12813640
/var/lib/pgsql/data/base/26611279/27236833
postmaste 7397 postgres 29u REG 8,2 1073741824 12812645
/var/lib/pgsql/data/base/26611279/27236833.1
postmaste 7397 postgres 30u REG 8,2 1073741824 12812681
/var/lib/pgsql/data/base/26611279/27236833.2
postmaste 7397 postgres 31u REG 8,2 1073741824 24133635
/var/lib/pgsql/data/base/26611279/27236833.3
postmaste 7397 postgres 32u REG 8,2 1073741824 24133636
/var/lib/pgsql/data/base/26611279/27236833.4
postmaste 7397 postgres 33u REG 8,2 1073741824 24133664
/var/lib/pgsql/data/base/26611279/27236833.5
postmaste 7397 postgres 34u REG 8,2 1073741824 12813227
/var/lib/pgsql/data/base/26611279/27236833.6
postmaste 7397 postgres 35u REG 8,2 1073741824 12812305
/var/lib/pgsql/data/base/26611279/27236833.7
postmaste 7397 postgres 36u REG 8,2 1073741824 24133637
/var/lib/pgsql/data/base/26611279/27236833.8
postmaste 7397 postgres 37u REG 8,2 1073741824 24133634
/var/lib/pgsql/data/base/26611279/27236833.9
postmaste 7397 postgres 38u REG 8,2 1073741824 24133639
/var/lib/pgsql/data/base/26611279/27236833.10
postmaste 7397 postgres 39u REG 8,2 1073741824 24133640
/var/lib/pgsql/data/base/26611279/27236833.11
postmaste 7397 postgres 40u REG 8,2 1073741824 24133641
/var/lib/pgsql/data/base/26611279/27236833.12
postmaste 7397 postgres 41u REG 8,2 1073741824 24133643
/var/lib/pgsql/data/base/26611279/27236833.13
postmaste 7397 postgres 42u REG 8,2 1073741824 24133646
/var/lib/pgsql/data/base/26611279/27236833.14
postmaste 7397 postgres 43u REG 8,2 1073741824 24133652
/var/lib/pgsql/data/base/26611279/27236833.15
postmaste 7397 postgres 44u REG 8,2 1073741824 24133654
/var/lib/pgsql/data/base/26611279/27236833.16
postmaste 7397 postgres 45u REG 8,2 1073741824 28295169
/var/lib/pgsql/data/base/26611279/27236833.17
postmaste 7397 postgres 46u REG 8,2 1073741824 32489473
/var/lib/pgsql/data/base/26611279/27236833.18
postmaste 7397 postgres 47u REG 8,2 1073741824 12812808
/var/lib/pgsql/data/base/26611279/27236833.19
postmaste 7397 postgres 48u REG 8,2 1073741824 12812811
/var/lib/pgsql/data/base/26611279/27236833.20
postmaste 7397 postgres 49u REG 8,2 1073741824 12812812
/var/lib/pgsql/data/base/26611279/27236833.21
postmaste 7397 postgres 50u REG 8,2 1073741824 32489475
/var/lib/pgsql/data/base/26611279/27236833.22
postmaste 7397 postgres 51u REG 8,2 1073741824 32489487
/var/lib/pgsql/data/base/26611279/27236833.23
postmaste 7397 postgres 52u REG 8,2 1073741824 32489488
/var/lib/pgsql/data/base/26611279/27236833.24
postmaste 7397 postgres 53u REG 8,2 1073741824 12812838
/var/lib/pgsql/data/base/26611279/27236833.25
postmaste 7397 postgres 54u REG 8,2 1073741824 32489486
/var/lib/pgsql/data/base/26611279/27236833.26
postmaste 7397 postgres 55u REG 8,2 1073741824 32489490
/var/lib/pgsql/data/base/26611279/27236833.27
postmaste 7397 postgres 56u REG 8,2 1073741824 32489476
/var/lib/pgsql/data/base/26611279/27236833.28
postmaste 7397 postgres 57u REG 8,2 1073741824 32489477
/var/lib/pgsql/data/base/26611279/27236833.29
postmaste 7397 postgres 58u REG 8,2 1073741824 12812862
/var/lib/pgsql/data/base/26611279/27236833.30
postmaste 7397 postgres 59u REG 8,2 977092608 32489492
/var/lib/pgsql/data/base/26611279/27241806
postmaste 7397 postgres 60u REG 8,2 824860672 32489493
/var/lib/pgsql/data/base/26611279/27241838
postmaste 7397 postgres 61u REG 8,2 824303616 32489494
/var/lib/pgsql/data/base/26611279/27241839
postmaste 7397 postgres 62u REG 8,2 824770560 32489495
/var/lib/pgsql/data/base/26611279/27241840
postmaste 7397 postgres 63u REG 8,2 1024270336 32489496
/var/lib/pgsql/data/base/26611279/27241841
postmaste 7397 postgres 64u REG 8,2 1024016384 32489497
/var/lib/pgsql/data/base/26611279/27241842
postmaste 7397 postgres 65u REG 8,2 1073741824 32489498
/var/lib/pgsql/data/base/26611279/27241843
postmaste 7397 postgres 66u REG 8,2 1073741824 32489499
/var/lib/pgsql/data/base/26611279/27241844
postmaste 7397 postgres 67u REG 8,2 824172544 32489500
/var/lib/pgsql/data/base/26611279/27241845
postmaste 7397 postgres 68u REG 8,2 824639488 32489501
/var/lib/pgsql/data/base/26611279/27241846
postmaste 7397 postgres 69u REG 8,2 16384 12812471
/var/lib/pgsql/data/base/26611279/26611350
postmaste 7397 postgres 70u REG 8,2 155648 12812401
/var/lib/pgsql/data/base/26611279/2610
postmaste 7397 postgres 71u REG 8,2 16384 12812744
/var/lib/pgsql/data/base/26611279/26612401
postmaste 7397 postgres 72u REG 8,2 16384 12813163
/var/lib/pgsql/data/base/26611279/26612835
postmaste 7397 postgres 73u REG 8,2 16384 12813164
/var/lib/pgsql/data/base/26611279/26612836
postmaste 7397 postgres 74u REG 8,2 16384 12813165
/var/lib/pgsql/data/base/26611279/26612837
postmaste 7397 postgres 75u REG 8,2 352256 12812314
/var/lib/pgsql/data/base/26611279/2696
postmaste 7397 postgres 76u REG 8,2 9469952 12812377
/var/lib/pgsql/data/base/26611279/2619
postmaste 7397 postgres 77u REG 8,2 8192 12813369
/var/lib/pgsql/data/base/26611279/27241102
postmaste 7397 postgres 78u REG 8,2 16384 12813370
/var/lib/pgsql/data/base/26611279/27241103
postmaste 7397 postgres 79u REG 8,2 16384 12813371
/var/lib/pgsql/data/base/26611279/27241104
postmaste 7397 postgres 80u REG 8,2 16384 12813372
/var/lib/pgsql/data/base/26611279/27241105
postmaste 7397 postgres 81u REG 8,2 16384 12813373
/var/lib/pgsql/data/base/26611279/27241106
postmaste 7397 postgres 82u REG 8,2 16384 12813374
/var/lib/pgsql/data/base/26611279/27241107
postmaste 7397 postgres 83u REG 8,2 16384 12813375
/var/lib/pgsql/data/base/26611279/27241108
postmaste 7397 postgres 84u REG 8,2 16384 12813376
/var/lib/pgsql/data/base/26611279/27241109
postmaste 7397 postgres 85u REG 8,2 16384 12813377
/var/lib/pgsql/data/base/26611279/27241110
postmaste 7397 postgres 86u REG 8,2 16384 12813378
/var/lib/pgsql/data/base/26611279/27241111
postmaste 7397 postgres 87u REG 8,2 8192 12813401
/var/lib/pgsql/data/base/26611279/27241134
postmaste 7397 postgres 88u REG 8,2 16384 12813402
/var/lib/pgsql/data/base/26611279/27241135
postmaste 7397 postgres 89u REG 8,2 16384 12813403
/var/lib/pgsql/data/base/26611279/27241136
postmaste 7397 postgres 90u REG 8,2 16384 12813404
/var/lib/pgsql/data/base/26611279/27241137
postmaste 7397 postgres 91u REG 8,2 16384 12813405
/var/lib/pgsql/data/base/26611279/27241138
postmaste 7397 postgres 92u REG 8,2 16384 12813406
/var/lib/pgsql/data/base/26611279/27241139
postmaste 7397 postgres 93u REG 8,2 16384 12813407
/var/lib/pgsql/data/base/26611279/27241140
postmaste 7397 postgres 94u REG 8,2 16384 12813408
/var/lib/pgsql/data/base/26611279/27241141
postmaste 7397 postgres 95u REG 8,2 16384 12813409
/var/lib/pgsql/data/base/26611279/27241142
postmaste 7397 postgres 96u REG 8,2 16384 12813410
/var/lib/pgsql/data/base/26611279/27241143
postmaste 7397 postgres 97u REG 8,2 16384 12813411
/var/lib/pgsql/data/base/26611279/27241144
postmaste 7397 postgres 98u REG 8,2 32768 12813451
/var/lib/pgsql/data/base/26611279/26630701
postmaste 7397 postgres 99u REG 8,2 32768 24133805
/var/lib/pgsql/data/base/26611279/27172990
postmaste 7397 postgres 100u REG 8,2 32768 12812473
/var/lib/pgsql/data/base/26611279/27172991
postmaste 7397 postgres 101u REG 8,2 32768 12812504
/var/lib/pgsql/data/base/26611279/27172993
postmaste 7397 postgres 102u REG 8,2 32768 12812474
/var/lib/pgsql/data/base/26611279/27172992
postmaste 7397 postgres 103u REG 8,2 716111872 12813434
/var/lib/pgsql/data/base/26611279/27241167
postmaste 7397 postgres 104u REG 8,2 7602176 12813438
/var/lib/pgsql/data/base/26611279/27241168
postmaste 7397 postgres 105u REG 8,2 24600576 12813441
/var/lib/pgsql/data/base/26611279/27241169
postmaste 7397 postgres 106u REG 8,2 24502272 12813442
/var/lib/pgsql/data/base/26611279/27241170
postmaste 7397 postgres 107u REG 8,2 30048256 12813443
/var/lib/pgsql/data/base/26611279/27241171
postmaste 7397 postgres 108u REG 8,2 24559616 12813444
/var/lib/pgsql/data/base/26611279/27241172
postmaste 7397 postgres 109u REG 8,2 29745152 12813445
/var/lib/pgsql/data/base/26611279/27241173
postmaste 7397 postgres 110u REG 8,2 29851648 12813446
/var/lib/pgsql/data/base/26611279/27241174
postmaste 7397 postgres 111u REG 8,2 27992064 12813447
/var/lib/pgsql/data/base/26611279/27241175
postmaste 7397 postgres 112u REG 8,2 24674304 12813448
/var/lib/pgsql/data/base/26611279/27241176
postmaste 7397 postgres 113u REG 8,2 24690688 12813449
/var/lib/pgsql/data/base/26611279/27241177
postmaste 7397 postgres 114u REG 8,2 763609088 12813423
/var/lib/pgsql/data/base/26611279/27241156
postmaste 7397 postgres 115u REG 8,2 4513792 12813424
/var/lib/pgsql/data/base/26611279/27241157
postmaste 7397 postgres 116u REG 8,2 24756224 12813425
/var/lib/pgsql/data/base/26611279/27241158
postmaste 7397 postgres 117u REG 8,2 24387584 12813426
/var/lib/pgsql/data/base/26611279/27241159
postmaste 7397 postgres 118u REG 8,2 29843456 12813427
/var/lib/pgsql/data/base/26611279/27241160
postmaste 7397 postgres 119u REG 8,2 24641536 12813428
/var/lib/pgsql/data/base/26611279/27241161
postmaste 7397 postgres 120u REG 8,2 30130176 12813429
/var/lib/pgsql/data/base/26611279/27241162
postmaste 7397 postgres 121u REG 8,2 30023680 12813430
/var/lib/pgsql/data/base/26611279/27241163
postmaste 7397 postgres 122u REG 8,2 29220864 12813431
/var/lib/pgsql/data/base/26611279/27241164
postmaste 7397 postgres 123u REG 8,2 24592384 12813432
/var/lib/pgsql/data/base/26611279/27241165
postmaste 7397 postgres 124u REG 8,2 24674304 12813433
/var/lib/pgsql/data/base/26611279/27241166
postmaste 7397 postgres 125u REG 8,2 1073741824 12812865
/var/lib/pgsql/data/base/26611279/27236833.31
postmaste 7397 postgres 126u REG 8,2 649412608 12813412
/var/lib/pgsql/data/base/26611279/27241145
postmaste 7397 postgres 127u REG 8,2 18046976 12813413
/var/lib/pgsql/data/base/26611279/27241146
postmaste 7397 postgres 128u REG 8,2 23617536 12813414
/var/lib/pgsql/data/base/26611279/27241147
postmaste 7397 postgres 129u REG 8,2 23568384 12813415
/var/lib/pgsql/data/base/26611279/27241148
postmaste 7397 postgres 130u REG 8,2 28614656 12813416
/var/lib/pgsql/data/base/26611279/27241149
postmaste 7397 postgres 131u REG 8,2 23306240 12813417
/var/lib/pgsql/data/base/26611279/27241150
postmaste 7397 postgres 132u REG 8,2 28483584 12813418
/var/lib/pgsql/data/base/26611279/27241151
postmaste 7397 postgres 133u REG 8,2 28499968 12813419
/var/lib/pgsql/data/base/26611279/27241152
postmaste 7397 postgres 134u REG 8,2 21676032 12813420
/var/lib/pgsql/data/base/26611279/27241153
postmaste 7397 postgres 135u REG 8,2 23429120 12813421
/var/lib/pgsql/data/base/26611279/27241154
postmaste 7397 postgres 136u REG 8,2 23445504 12813422
/var/lib/pgsql/data/base/26611279/27241155
postmaste 7397 postgres 137u REG 8,2 205619200 12813778
/var/lib/pgsql/data/base/26611279/27236971
postmaste 7397 postgres 138u REG 8,2 65536 12813513
/var/lib/pgsql/data/base/26611279/27236747
postmaste 7397 postgres 139u REG 8,2 170000384 12813779
/var/lib/pgsql/data/base/26611279/27236972
postmaste 7397 postgres 140u REG 8,2 170262528 12813780
/var/lib/pgsql/data/base/26611279/27236973
postmaste 7397 postgres 141u REG 8,2 149225472 12813310
/var/lib/pgsql/data/base/26611279/27241048
postmaste 7397 postgres 142u REG 8,2 65536 12813559
/var/lib/pgsql/data/base/26611279/27236793
postmaste 7397 postgres 143u REG 8,2 149168128 12813312
/var/lib/pgsql/data/base/26611279/27241050
postmaste 7397 postgres 144u REG 8,2 1073741824 32489478
/var/lib/pgsql/data/base/26611279/27236833.32
postmaste 7397 postgres 145u REG 8,2 53567488 32489479
/var/lib/pgsql/data/base/26611279/27241844.1
postmaste 7397 postgres 146u REG 8,2 170016768 12813772
/var/lib/pgsql/data/base/26611279/27236965
postmaste 7397 postgres 147u REG 8,2 1073741824 12813770
/var/lib/pgsql/data/base/26611279/27236963
postmaste 7397 postgres 148u REG 8,2 1073741824 12813228
/var/lib/pgsql/data/base/26611279/27236963.1
postmaste 7397 postgres 149u REG 8,2 1073741824 24133642
/var/lib/pgsql/data/base/26611279/27236963.2
postmaste 7397 postgres 150u REG 8,2 1073741824 32489474
/var/lib/pgsql/data/base/26611279/27236963.3
postmaste 7397 postgres 151u REG 8,2 1073741824 32489489
/var/lib/pgsql/data/base/26611279/27236963.4
postmaste 7397 postgres 152u REG 8,2 573038592 12812863
/var/lib/pgsql/data/base/26611279/27236963.5
postmaste 7397 postgres 153u REG 8,2 207003648 12813776
/var/lib/pgsql/data/base/26611279/27236969
postmaste 7397 postgres 154u REG 8,2 52887552 32489480
/var/lib/pgsql/data/base/26611279/27241843.1
postmaste 7397 postgres 155u REG 8,2 206692352 12813774
/var/lib/pgsql/data/base/26611279/27236967
postmaste 7397 postgres 156u REG 8,2 206381056 12813777
/var/lib/pgsql/data/base/26611279/27236970
postmaste 7397 postgres 157u REG 8,2 170360832 12813773
/var/lib/pgsql/data/base/26611279/27236966
postmaste 7397 postgres 158u REG 8,2 16384 12813686
/var/lib/pgsql/data/base/26611279/27236879
postmaste 7397 postgres 159u REG 8,2 162889728 12813771
/var/lib/pgsql/data/base/26611279/27236964
postmaste 7397 postgres 160u REG 8,2 190480384 12813315
/var/lib/pgsql/data/base/26611279/27241053
postmaste 7397 postgres 161u REG 8,2 169484288 12813775
/var/lib/pgsql/data/base/26611279/27236968
postmaste 7397 postgres 162u REG 8,2 65536 12813512
/var/lib/pgsql/data/base/26611279/27236746
postmaste 7397 postgres 163u REG 8,2 16384 12813728
/var/lib/pgsql/data/base/26611279/27236921
postmaste 7397 postgres 164u REG 8,2 201940992 32489481
/var/lib/pgsql/data/base/26611279/27236833.33
postmaste 7397 postgres 165u REG 8,2 16384 12813692
/var/lib/pgsql/data/base/26611279/27236885
postmaste 7397 postgres 166u REG 8,2 16384 12813693
/var/lib/pgsql/data/base/26611279/27236886
pgsql-performance by date: