as_ofΒΆ

Note

Cockroach only.

You can use as_of clause with the following queries:

To retrieve historical data from 5 minutes ago:

await Band.select().where(
    Band.name == 'Pythonistas'
).as_of('-5min')

This generates an AS OF SYSTEM TIME clause. See documentation.

This clause accepts a wide variety of time and interval string formats.

This is very useful for performance, as it will reduce transaction contention across a cluster.