Re: very slow selects on a small table
От | Brian Cox |
---|---|
Тема | Re: very slow selects on a small table |
Дата | |
Msg-id | 4A397303.7030207@ca.com обсуждение исходный текст |
Ответ на | very slow selects on a small table (Brian Cox <brian.cox@ca.com>) |
Ответы |
Re: very slow selects on a small table
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | 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 по дате отправления: