explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jKJfc

Settings
# exclusive inclusive rows x rows loops node
1. 829.795 5,224.041 ↓ 15.0 226,201 1

Hash Join (cost=58,992.27..97,780.09 rows=15,101 width=8) (actual time=4,165.743..5,224.041 rows=226,201 loops=1)

  • Hash Cond: (geolocatio3_.address_id = address4_.id)
2. 228.571 228.571 ↑ 1.0 1,513,797 1

Seq Scan on geolocation_address_context_t geolocatio3_ (cost=0.00..32,959.77 rows=1,513,877 width=16) (actual time=0.006..228.571 rows=1,513,797 loops=1)

3. 120.426 4,165.675 ↓ 17.3 411,849 1

Hash (cost=58,694.32..58,694.32 rows=23,836 width=8) (actual time=4,165.675..4,165.675 rows=411,849 loops=1)

  • Buckets: 131072 (originally 32768) Batches: 8 (originally 1) Memory Usage: 3073kB
4. 2,995.900 4,045.249 ↓ 17.3 411,849 1

Bitmap Heap Scan on address_t address4_ (cost=540.00..58,694.32 rows=23,836 width=8) (actual time=1,057.862..4,045.249 rows=411,849 loops=1)

  • Recheck Cond: ((f_unaccent((city_dutch)::text) = 'Bruxelles'::text) OR (f_unaccent((city_french)::text) = 'Bruxelles'::text))
  • Heap Blocks: exact=49400
5. 0.001 1,049.349 ↓ 0.0 0 1

BitmapOr (cost=540.00..540.00 rows=23,895 width=0) (actual time=1,049.349..1,049.349 rows=0 loops=1)

6. 726.757 726.757 ↓ 14.8 177,237 1

Bitmap Index Scan on city_nl_idx (cost=0.00..262.04 rows=11,948 width=0) (actual time=726.757..726.757 rows=177,237 loops=1)

  • Index Cond: (f_unaccent((city_dutch)::text) = 'Bruxelles'::text)
7. 322.591 322.591 ↓ 34.5 411,733 1

Bitmap Index Scan on city_fr_idx (cost=0.00..266.04 rows=11,948 width=0) (actual time=322.591..322.591 rows=411,733 loops=1)

  • Index Cond: (f_unaccent((city_french)::text) = 'Bruxelles'::text)
Planning time : 3.454 ms