Commit662e6d0

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 parent6b4f856 commit662e6d0Copy full SHA for 662e6d0

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

Comments

(0)