explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 9Nv

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.004 2,953.225 ↑ 1.0 5 1

Limit (cost=192,072.010..192,072.050 rows=5 width=16) (actual time=2,953.216..2,953.225 rows=5 loops=1)

2. 0.009 2,953.221 ↑ 37,946.6 5 1

Unique (cost=192,072.010..193,495.010 rows=189,733 width=16) (actual time=2,953.214..2,953.221 rows=5 loops=1)

3. 305.039 2,953.212 ↑ 37,946.6 5 1

Sort (cost=192,072.010..192,546.350 rows=189,733 width=16) (actual time=2,953.212..2,953.212 rows=5 loops=1)

  • Sort Key: charlie, quebec
  • Sort Method: external merge Disk: 9968kB
4. 2,603.567 2,648.173 ↓ 1.6 300,000 1

Bitmap Heap Scan on papa (cost=4,672.730..172,193.990 rows=189,733 width=16) (actual time=46.451..2,648.173 rows=300,000 loops=1)

  • Recheck Cond: (tango = ANY ('alpha'::numeric[]))
5. 44.606 44.606 ↓ 1.6 300,000 1

Bitmap Index Scan on five (cost=0.000..4,625.300 rows=189,733 width=0) (actual time=44.606..44.606 rows=300,000 loops=1)

  • Index Cond: (tango = ANY ('alpha'::numeric[]))