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 2953.225 ↑ 1.0 5 1

Limit (cost=192072.010..192072.050 rows=5 width=16) (actual time=2953.216..2953.225 rows=5 loops=1)

2. 0.009 2953.221 ↑ 37946.6 5 1

Unique (cost=192072.010..193495.010 rows=189733 width=16) (actual time=2953.214..2953.221 rows=5 loops=1)

3. 305.039 2953.212 ↑ 37946.6 5 1

Sort (cost=192072.010..192546.350 rows=189733 width=16) (actual time=2953.212..2953.212 rows=5 loops=1)

  • Sort Key: charlie, quebec
  • Sort Method: external merge Disk: 9968kB
4. 2603.567 2648.173 ↓ 1.6 300000 1

Bitmap Heap Scan on papa (cost=4672.730..172193.990 rows=189733 width=16) (actual time=46.451..2648.173 rows=300000 loops=1)

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

Bitmap Index Scan on five (cost=0.000..4625.300 rows=189733 width=0) (actual time=44.606..44.606 rows=300000 loops=1)

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