see seq postgres code example

Example: check current sequence value postgres

SELECT last_value FROM sequence_name;