Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.paradedb.com/llms.txt

Use this file to discover all available pages before exploring further.

Legacy Docs: This page describes our legacy API. It will be deprecated in a future version. Please use the v2 API where possible.

Limit

Passing LIMIT into a query can significantly improve query times for queries that return large result sets.
SELECT description, rating, category
FROM mock_items
WHERE description @@@ 'shoes'
LIMIT 5;

Offset

OFFSET can be used with LIMIT to paginate through results.
SELECT description, rating, category
FROM mock_items
WHERE description @@@ 'shoes'
LIMIT 1 OFFSET 2;