Skip to main content

Cost Limits

Prevent expensive queries with per-query byte limits.

How It Works​

Before running, Querylab.io estimates bytes to be processed. If it exceeds your limit, a warning appears.

Default limit: 100 GB

Warning Modal​

Query would process 500 GB (estimated $3.13),
exceeding your limit of 100 GB.

[Cancel]  [Run Once]  [Update Once]  [Update Permanently]
  • Cancel: Return to editor
  • Run Once: Run without changing limit
  • Update Once: Use new limit this time only
  • Update Permanently: Change limit for all future queries

Configuration​

Found in the editor's configuration panel:

  • Docked Panel (wide screen): Right side of editor
  • Floating Panel (split view): Click floating config button

Set "Maximum GB Processed" to your desired limit.

Use CaseLimit
Development10 GB
Analytics100 GB
Data Engineering1 TB

When Limit is Exceeded​

Options to reduce cost:

  1. Add -- querylab:tablesample=1 for 99% savings during development
  2. Add WHERE filters (dates, partitions)
  3. Select fewer columns (avoid SELECT *)