explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 2v8 : Normal @60s

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.001 17,838.588 ↑ 25.0 1 1

Limit (cost=0.000..19,814.710 rows=25 width=83) (actual time=7.900..17,838.588 rows=1 loops=1)

2. 17,838.587 17,838.587 ↑ 3,499.0 1 1

Index Scan Backward using echo on five november (cost=0.000..2,773,266.380 rows=3,499 width=83) (actual time=7.900..17,838.587 rows=1 loops=1)

  • Filter: ((sierra OR (victor_five = 'zulu_delta'::bpchar)) AND (xray = 36) AND (victor_juliet = ANY ('zulu_zulu'::bpchar[])) AND (foxtrot = ANY ('papa'::integer[])))
  • Rows Removed by Filter: 28733952