explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VeBz

Settings
# exclusive inclusive rows x rows loops node
1. 693.651 9,724.611 ↓ 15.0 226,201 1

Hash Join (cost=1,292,557.99..1,331,345.81 rows=15,101 width=8) (actual time=8,838.261..9,724.611 rows=226,201 loops=1)

  • Hash Cond: (geolocatio3_.address_id = address4_.id)
2. 192.847 192.847 ↑ 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.007..192.847 rows=1,513,797 loops=1)

3. 121.173 8,838.113 ↓ 17.3 411,849 1

Hash (cost=1,292,260.04..1,292,260.04 rows=23,836 width=8) (actual time=8,838.113..8,838.113 rows=411,849 loops=1)

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

Seq Scan on address_t address4_ (cost=0.00..1,292,260.04 rows=23,836 width=8) (actual time=2.531..8,716.940 rows=411,849 loops=1)

  • Filter: ((f_unaccent((city_dutch)::text) = 'Bruxelles'::text) OR (f_unaccent((city_french)::text) = 'Bruxelles'::text))
  • Rows Removed by Filter: 1977687
Planning time : 0.248 ms