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. 90,526.660 91,009.728 ↓ 9.0 30,082 1

Bitmap Heap Scan on adresses (cost=12,858.60..356,119.75 rows=3,341 width=72) (actual time=641.584..91,009.728 rows=30,082 loops=1)

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

Bitmap Index Scan on adr_pays (cost=0.00..12,857.76 rows=668,237 width=0) (actual time=483.068..483.068 rows=685,741 loops=1)

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