is there any query to get the total daily ingest size? we are running signoz on premise

it will be difficult to get daily ingest size for self-hosted SigNoz. But you can get overall size using the following clickhouse query:

SELECT
	database,
	table,
	formatReadableSize(sum(data_compressed_bytes) AS size) AS compressed,
	formatReadableSize(sum(data_uncompressed_bytes) AS usize) AS uncompressed,
	round(usize / size, 2) AS compr_rate,
	sum(rows) AS rows,
	count() AS part_count
FROM system.parts
WHERE (active = 1) AND (database LIKE 'signoz_%')
GROUP BY
	database,
	table
ORDER BY size DESC;