explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mqqJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 805.286 ↓ 0.0 0 1

Limit (cost=5,431.06..5,431.07 rows=4 width=16) (actual time=805.286..805.286 rows=0 loops=1)

2. 0.008 805.285 ↓ 0.0 0 1

Sort (cost=5,431.06..5,431.07 rows=4 width=16) (actual time=805.285..805.285 rows=0 loops=1)

  • Sort Key: case0_.reception_date DESC, case0_.id DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.000 805.277 ↓ 0.0 0 1

Nested Loop Semi Join (cost=3,257.45..5,431.02 rows=4 width=16) (actual time=805.277..805.277 rows=0 loops=1)

4. 0.001 805.277 ↓ 0.0 0 1

Nested Loop (cost=3,257.02..5,268.73 rows=78 width=16) (actual time=805.277..805.277 rows=0 loops=1)

5. 0.002 805.276 ↓ 0.0 0 1

HashAggregate (cost=3,256.60..3,258.16 rows=156 width=8) (actual time=805.276..805.276 rows=0 loops=1)

  • Group Key: geolocatio3_.geolocation_id
6. 0.002 805.274 ↓ 0.0 0 1

Nested Loop (cost=0.84..3,256.21 rows=156 width=8) (actual time=805.274..805.274 rows=0 loops=1)

7. 805.272 805.272 ↓ 0.0 0 1

Index Scan using sortable_address_fr_nl_upper_gist_idx on address_t address4_ (cost=0.41..1,073.00 rows=262 width=8) (actual time=805.272..805.272 rows=0 loops=1)

  • Index Cond: (f_unaccent(upper((street_name_fr_nl)::text)) ~~ '%Prosper%'::text)
  • Rows Removed by Index Recheck: 966
8. 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.32 rows=1 width=16) (never executed)

  • Index Cond: (address_id = address4_.id)
9. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (geolocation_id = geolocatio3_.geolocation_id)
  • Filter: ((NOT a_new_version_exists) AND ((case_type)::text <> 'URBANISME'::text) AND (SubPlan 1))
10.          

SubPlan (for Index Scan)

11. 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)

  • Index Cond: (case0_.id = case_id)
12. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (external_id = case0_.id)
  • Filter: ((reference_type_id <> 10035) AND (upper((reference)::text) ~~ '%9767%'::text))