Commitf2dcff4

Andrey Kazarinov

authored and

committed

[PGPRO-7366] add function which shows memory usage

function memctx_htab_sizes outputs allocated sizes and used sizes of aqo's memory contexts and hash tables

1 parent93a2291 commitf2dcff4Copy full SHA for f2dcff4

File tree

+25

-0

lines changed

+25

-0

lines changed

Lines changed: 16 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -98,3 +98,19 @@ AS 'MODULE_PATHNAME', 'aqo_queries'`
`98`	`98`	`LANGUAGE C STRICT VOLATILE PARALLEL SAFE;`
`99`	`99`
`100`	`100`	`CREATEVIEWaqo_queriesASSELECT*FROM aqo_queries();`
	`101`	`+`
	`102`	`+CREATEFUNCTIONaqo_memory_usage(`
	`103`	`+ OUT nametext,`
	`104`	`+ OUT allocated_sizeint,`
	`105`	`+ OUT used_sizeint`
	`106`	`+)`
	`107`	`+RETURNS SETOF record`
	`108`	`+AS $$`
	`109`	`+SELECT name, total_bytes, used_bytesFROM pg_backend_memory_contexts`
	`110`	`+WHERE nameLIKE'AQO%'`
	`111`	`+UNION`
	`112`	`+SELECT name, allocated_size, sizeFROM pg_shmem_allocations`
	`113`	`+WHERE nameLIKE'AQO%';`
	`114`	`+$$ LANGUAGE SQL;`
	`115`	`+COMMENT ON FUNCTION aqo_memory_usage() IS`
	`116`	+'Show allocated sizes and used sizes of aqo`s memory contexts and hash tables';

Lines changed: 9 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -160,6 +160,9 @@`
`160`	`160`	`WHERE v.exec_time > 0.");`
`161`	`161`	`is($res, 3);`
`162`	`162`
	`163`	`+$res =$node->safe_psql('postgres',"SELECT * FROM aqo_memory_usage() AS t1");`
	`164`	`+note("MEMORY:\n$res\n");`
	`165`	`+`
`163`	`166`	`# ##############################################################################`
`164`	`167`	`#`
`165`	`168`	`# pgbench on a database with AQO in 'learn' mode.`
`@@ -184,6 +187,9 @@`
`184`	`187`	`"$TRANSACTIONS",'-c',"$CLIENTS",'-j',"$THREADS" ],`
`185`	`188`	`'pgbench in frozen mode');`
`186`	`189`
	`190`	`+$res =$node->safe_psql('postgres',"SELECT * FROM aqo_memory_usage() AS t1");`
	`191`	`+note("MEMORY:\n$res\n");`
	`192`	`+`
`187`	`193`	`# ##############################################################################`
`188`	`194`	`#`
`189`	`195`	`# Check procedure of ML-knowledge data cleaning.`
`@@ -299,6 +305,9 @@`
`299`	`305`	`is($new_stat_count ==$stat_count -$pgb_stat_count, 1,`
`300`	`306`	`'Total number of samples in aqo_query_stat');`
`301`	`307`
	`308`	`+$res =$node->safe_psql('postgres',"SELECT * FROM aqo_memory_usage() AS t1");`
	`309`	`+note("MEMORY:\n$res\n");`
	`310`	`+`
`302`	`311`	`# ##############################################################################`
`303`	`312`	`#`
`304`	`313`	`# AQO works after moving to another schema`

Comments

(0)