А на старом что strace показывает?

Question

pgsql – PostgreSQL

Daniel

А на старом что strace показывает?

#backend #devops #pgsql #programming #russian

0

10.04.2020

1 ответов

6 просмотров

Andrii · Accepted Answer

на старом все быстро sendto(3, "Q\0\0\2 EXPLAIN (ANALYZE,BUFFERS) S"..., 545, MSG_NOSIGNAL, NULL, 0) = 545 poll([{fd=3, events=POLLIN|POLLERR}], 1, -1) = 1 ([{fd=3, revents=POLLIN}]) recvfrom(3, "T\0\0\0#\0\1QUERY PLAN\0\0\0\0\0\0\0\0\0\0\31\377\377\377\377"..., 16384, 0, NULL, NULL) = 1065 ioctl(1, TCGETS, 0x7ffcc9a1b2a0) = -1 ENOTTY (Inappropriate ioctl for device) ioctl(0, TCGETS, {B38400 opost isig icanon echo ...}) = 0 ioctl(1, TCGETS, 0x7ffcc9a1b230) = -1 ENOTTY (Inappropriate ioctl for device) write(1, " "..., 1241 QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Hash Join (cost=0.24..0.82 rows=6 width=180) (actual time=14.801..16.607 rows=3 loops=1) Hash Cond: (d.datname = pd.datname) Buffers: shared hit=11 -> Seq Scan on pg_database d (cost=0.00..0.22 rows=6 width=68) (actual time=0.067..0.092 rows=3 loops=1) Filter: ((datname !~~* 'template%%%%'::text) AND (datname !~~* 'rdsadmin'::text) AND (datname !~~* 'azure_maintenance'::text) AND (datname !~~* 'postgres'::text)) Rows Removed by Filter: 3 Buffers: shared hit=1 -> Hash (cost=0.16..0.16 rows=6 width=68) (actual time=0.013..0.013 rows=6 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 9kB Buffers: shared hit=1 -> Seq Scan on pg_database pd (cost=0.00..0.16 rows=6 width=68) (actual time=0.003..0.007 rows=6 loops=1) Buffers: shared hit=1 Planning time: 1.129 ms Execution time: 16.709 ms (14 rows) ) = 1241 recvfrom(3, 0x561f76e146c0, 16384, 0, NULL, NULL) = -1 EAGAIN (Resource temporarily unavailable) sendto(3, "X\0\0\0\4", 5, MSG_NOSIGNAL, NULL, 0) = 5 close(3) = 0 rt_sigaction(SIGPIPE, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7fe98e7ba060}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 😍 = 0 exit_group(0) = ? +++ exited with 0 +++

172 похожих чатов

А на старом что strace показывает?

1 ответов

Похожие вопросы