KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a table with ~50M rows and a btree index on (tenant_id, created_at). When I run SELECT * FROM events WHERE tenant_id = 42 AND created_at > '2025-01-01' the planner chooses a sequential scan. EXPLAIN ANALYZE shows the seq scan is 40x slower. I've run ANALYZE and the statistics look correct...
Tags (comma-separated)
Save Edits
Cancel