To reproduce

Go to the demo box and issue these two commands

tables() where table_name = 'fx_trades';
wal_transactions('fx_trades');

Timestamp is interpreted as microseconds, but table has timestamp_ns, so it shows incorrect information

QuestDB version:

9.3.1

OS, in case of Docker specify Docker and the Host OS:

ubuntu

File System, in case of Docker specify Host File System:

ext4

Full Name:

javier

Affiliation:

questdb

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

• Yes, I have

Additional context

No response