explain.depesz.com

PostgreSQL's explain analyze made readable

Result: exS

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,685.561 ↓ 0.0 0 1

Limit (cost=10,827.88..10,827.90 rows=7 width=16) (actual time=1,685.561..1,685.561 rows=0 loops=1)

  • Sort Key: case0_.reception_date DESC, case0_.id DESC
  • Sort Method: quicksort Memory: 25kB
  • Group Key: geolocatio3_.geolocation_id
  • Recheck Cond: ((f_unaccent(upper((street_name_french)::text)) ~~ '%Prosper%'::text) OR (f_unaccent(upper((street_name_dutch)::text)) ~~ '%Prosper%'::text))
  • Rows Removed by Index Recheck: 966
  • Heap Blocks: exact=457
  • Index Cond: (f_unaccent(upper((street_name_french)::text)) ~~ '%Prosper%'::text)
  • Index Cond: (f_unaccent(upper((street_name_dutch)::text)) ~~ '%Prosper%'::text)
  • Index Cond: (address_id = address4_.id)
  • Index Cond: (geolocation_id = geolocatio3_.geolocation_id)
  • Filter: ((NOT a_new_version_exists) AND ((case_type)::text <> 'ENVIRONMENT'::text) AND (SubPlan 1))
  • Index Cond: (case0_.id = case_id)
  • Index Cond: (external_id = case0_.id)
  • Filter: ((reference_type_id <> 10035) AND (upper((reference)::text) ~~ '%9767%'::text))
2. 1,685.560 1,685.560 ↓ 0.0 0 1

Sort (cost=10,827.88..10,827.90 rows=7 width=16) (actual time=1,685.560..1,685.560 rows=0 loops=1)

3. 1,685.555 1,685.555 ↓ 0.0 0 1

Nested Loop Semi Join (cost=6,550.01..10,827.78 rows=7 width=16) (actual time=1,685.555..1,685.555 rows=0 loops=1)

4. 1,685.555 1,685.555 ↓ 0.0 0 1

Nested Loop (cost=6,549.58..10,521.42 rows=139 width=16) (actual time=1,685.555..1,685.555 rows=0 loops=1)

5. 1,685.554 1,685.554 ↓ 0.0 0 1

HashAggregate (cost=6,549.16..6,552.28 rows=312 width=8) (actual time=1,685.554..1,685.554 rows=0 loops=1)

6. 1,685.553 1,685.553 ↓ 0.0 0 1

Nested Loop (cost=37.44..6,548.38 rows=312 width=8) (actual time=1,685.553..1,685.553 rows=0 loops=1)

7. 1,685.552 1,685.552 ↓ 0.0 0 1

Bitmap Heap Scan on address_t address4_ (cost=37.02..2,274.41 rows=523 width=8) (actual time=1,685.552..1,685.552 rows=0 loops=1)

8. 1,585.462 1,585.462 ↓ 0.0 0 1

BitmapOr (cost=37.02..37.02 rows=523 width=0) (actual time=1,585.462..1,585.462 rows=0 loops=1)

9. 750.744 750.744 ↓ 3.7 966 1

Bitmap Index Scan on address_fr_upper_gist_idx (cost=0.00..18.38 rows=262 width=0) (actual time=750.744..750.744 rows=966 loops=1)

10. 834.715 834.715 ↓ 3.0 778 1

Bitmap Index Scan on address_nl_upper_gist_idx (cost=0.00..18.38 rows=262 width=0) (actual time=834.715..834.715 rows=778 loops=1)

11. 0.000 0.000 ↓ 0.0 0

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

12. 0.000 0.000 ↓ 0.0 0

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

13. 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.66 rows=3 width=8) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Index Scan using reference_case_idx on reference_t reference2_ (cost=0.43..2.20 rows=1 width=8) (never executed)