this query can be more optimized for performance

[github-actions]

PostgresPartitionPages returns leaf-partition page counts using a recursive CTE over pg_inherits. Works on all Postgres versions (10+); used as fallback for PG < 12.

---

olake/pkg/jdbc/jdbc.go

Lines 158 to 163 in 72486ac

	// TODO:check this query might be more optimized for performance
	// PostgresPartitionPages returns leaf-partition page counts using a recursive CTE over
	// pg_inherits. Works on all Postgres versions (10+); used as fallback for PG < 12.
	func PostgresPartitionPages(stream types.StreamInterface) string {
	return fmt.Sprintf(`
	WITH RECURSIVE partition_tree AS (

---

This issue was generated by todo-issue based on a TODO comment in 72486ac. It's been assigned to @vikaxsh because they committed the code.