Re: very slow selects on a small table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 

Tom Lane [tgl@xxxxxxxxxxxxx] 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 

--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux