explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 43d

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 90526.660 91009.728 ↓ 9.0 30082 1

Bitmap Heap Scan on adresses (cost=12858.60..356119.75 rows=3341 width=72) (actual time=641.584..91009.728 rows=30082 loops=1)

  • Recheck Cond: ((pays)::text = 'France'::text)
  • Filter: (upper((ville)::text) = 'TOULOUSE'::text)
2. 483.068 483.068 ↓ 1.0 685741 1

Bitmap Index Scan on adr_pays (cost=0.00..12857.76 rows=668237 width=0) (actual time=483.068..483.068 rows=685741 loops=1)

  • Index Cond: ((pays)::text = 'France'::text)