explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dXir

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 62,490.271 ↑ 1.0 1 1

Aggregate (cost=7,087.46..7,087.47 rows=1 width=8) (actual time=62,490.271..62,490.271 rows=1 loops=1)

2. 0.000 62,490.262 ↓ 0.0 0 1

Nested Loop (cost=5,683.82..7,087.15 rows=122 width=8) (actual time=62,490.262..62,490.262 rows=0 loops=1)

3. 0.002 62,490.262 ↓ 0.0 0 1

HashAggregate (cost=5,683.40..5,686.06 rows=266 width=8) (actual time=62,490.262..62,490.262 rows=0 loops=1)

  • Group Key: geolocatio2_.geolocation_id
4. 0.000 62,490.260 ↓ 0.0 0 1

Nested Loop (cost=76.82..5,682.73 rows=266 width=8) (actual time=62,490.260..62,490.260 rows=0 loops=1)

5. 19,496.306 62,490.260 ↓ 0.0 0 1

Bitmap Heap Scan on address_t address3_ (cost=76.39..2,019.80 rows=446 width=8) (actual time=62,490.260..62,490.260 rows=0 loops=1)

  • Recheck Cond: ((f_unaccent(upper((sortable_address_fr)::text)) ~~ '%rue%'::text) OR (f_unaccent(upper((sortable_address_nl)::text)) ~~ '%rue%'::text))
  • Rows Removed by Index Recheck: 1670434
  • Heap Blocks: exact=49145 lossy=33306
6. 0.001 42,993.954 ↓ 0.0 0 1

BitmapOr (cost=76.39..76.39 rows=446 width=0) (actual time=42,993.954..42,993.954 rows=0 loops=1)

7. 15,521.771 15,521.771 ↓ 4,890.3 1,095,436 1

Bitmap Index Scan on sortable_address_fr_upper_gist_idx (cost=0.00..38.09 rows=224 width=0) (actual time=15,521.771..15,521.771 rows=1,095,436 loops=1)

  • Index Cond: (f_unaccent(upper((sortable_address_fr)::text)) ~~ '%rue%'::text)
8. 27,472.182 27,472.182 ↓ 1,176.7 261,223 1

Bitmap Index Scan on sortable_address_nl_upper_gist_idx (cost=0.00..38.08 rows=222 width=0) (actual time=27,472.182..27,472.182 rows=261,223 loops=1)

  • Index Cond: (f_unaccent(upper((sortable_address_nl)::text)) ~~ '%rue%'::text)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using geolocation_address_context_t_address_idx on geolocation_address_context_t geolocatio2_ (cost=0.43..8.20 rows=1 width=16) (never executed)

  • Index Cond: (address_id = address3_.id)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using case_geolocation_id_idx on case_t case0_ (cost=0.42..5.26 rows=1 width=16) (never executed)

  • Index Cond: (geolocation_id = geolocatio2_.geolocation_id)
  • Filter: ((NOT a_new_version_exists) AND ((case_type)::text <> 'UTG'::text) AND (SubPlan 1))
11.          

SubPlan (for Index Scan)

12. 0.000 0.000 ↓ 0.0 0

Index Scan using case_actor_authority_case_idx on case_actor_authority_t actors1_ (cost=0.43..8.67 rows=3 width=8) (never executed)

  • Index Cond: (case0_.id = case_id)
Planning time : 5.138 ms
Execution time : 62,491.273 ms