mirror of
https://github.com/neondatabase/neon.git
synced 2026-01-03 19:42:55 +00:00
cf7a596a15
There are quite a few benefits to this approach:
- Reduce config duplication
- The two sql_exporter configs were super similar with just a few
differences
- Pull SQL queries into standalone files
- That means we could run a SQL formatter on the file in the future
- It also means access to syntax highlighting
- In the future, run different queries for different PG versions
- This is relevant because right now, we have queries that are failing
on PG 17 due to catalog updates
Signed-off-by: Tristan Partin <tristan@neon.tech>
8 lines
464 B
SQL
8 lines
464 B
SQL
SELECT
|
|
(SELECT setting FROM pg_settings WHERE name = 'neon.timeline_id') AS timeline_id,
|
|
-- Postgres creates temporary snapshot files of the form %X-%X.snap.%d.tmp.
|
|
-- These temporary snapshot files are renamed to the actual snapshot files
|
|
-- after they are completely built. We only WAL-log the completely built
|
|
-- snapshot files
|
|
(SELECT COUNT(*) FROM pg_ls_dir('pg_logical/snapshots') AS name WHERE name LIKE '%.snap') AS num_logical_snapshot_files;
|