explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sain

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

Limit (cost=2.99..32,372.15 rows=25 width=16) (actual time=3,898.394..3,898.394 rows=0 loops=1)

2. 0.002 3,898.394 ↓ 0.0 0 1

Nested Loop (cost=2.99..784,631.60 rows=606 width=16) (actual time=3,898.394..3,898.394 rows=0 loops=1)

3. 0.000 3,898.392 ↓ 0.0 0 1

Nested Loop (cost=2.99..784,622.18 rows=606 width=24) (actual time=3,898.392..3,898.392 rows=0 loops=1)

  • Join Filter: (p.definition_id = pdt.id)
4. 0.000 3,898.392 ↓ 0.0 0 1

Nested Loop (cost=2.99..781,960.25 rows=606 width=32) (actual time=3,898.392..3,898.392 rows=0 loops=1)

5. 0.000 3,898.392 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.56..781,490.50 rows=700 width=24) (actual time=3,898.392..3,898.392 rows=0 loops=1)

6. 0.000 3,898.392 ↓ 0.0 0 1

Nested Loop (cost=2.13..781,057.25 rows=700 width=32) (actual time=3,898.392..3,898.392 rows=0 loops=1)

7. 0.001 3,898.392 ↓ 0.0 0 1

Nested Loop (cost=1.71..780,639.97 rows=700 width=32) (actual time=3,898.392..3,898.392 rows=0 loops=1)

8. 134.450 3,898.391 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.28..780,263.57 rows=700 width=32) (actual time=3,898.391..3,898.391 rows=0 loops=1)

  • Filter: ((SubPlan 1) ~~ '%ROUGE%'::text)
  • Rows Removed by Filter: 438444
9. 0.000 2,010.165 ↓ 1.0 438,444 1

Nested Loop Left Join (cost=0.85..389,187.25 rows=437,754 width=40) (actual time=0.846..2,010.165 rows=438,444 loops=1)

10. 721.035 721.035 ↓ 1.0 438,444 1

Index Scan using case_reception_date_idx on case_t c (cost=0.42..124,947.57 rows=437,754 width=48) (actual time=0.827..721.035 rows=438,444 loops=1)

  • Filter: ((NOT deleted) AND (NOT a_new_version_exists) AND ((case_type)::text = 'URBANISM'::text))
  • Rows Removed by Filter: 279885
11. 1,315.332 1,315.332 ↑ 1.0 1 438,444

Index Scan using geolocation__case_idx on geolocation_t g (cost=0.42..0.59 rows=1 width=24) (actual time=0.002..0.003 rows=1 loops=438,444)

  • Index Cond: (case_id = c.id)
12. 1,315.332 1,315.332 ↑ 1.0 1 438,444

Index Scan using pk_address_t on address_t ad (cost=0.43..0.85 rows=1 width=29) (actual time=0.003..0.003 rows=1 loops=438,444)

  • Index Cond: (id = g.target_principal_address_id)
13.          

SubPlan (forNested Loop Left Join)

14. 438.444 438.444 ↑ 1.0 1 438,444

Result (cost=0.00..0.03 rows=1 width=32) (actual time=0.000..0.001 rows=1 loops=438,444)

15. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_configuration_t on configuration_t config (cost=0.42..0.53 rows=1 width=16) (never executed)

  • Index Cond: (id = c.configuration_id)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_phase_t on phase_t p (cost=0.43..0.59 rows=1 width=24) (never executed)

  • Index Cond: (id = config.current_phase_id)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using geolocation_localization_context_geolocation_id_idx on geolocation_localization_context_t glc (cost=0.43..0.61 rows=1 width=16) (never executed)

  • Index Cond: (g.id = geolocation_id)
  • Filter: ((context_type)::text = 'TARGET'::text)
18. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_case_actor_authority on case_actor_authority_t actors1_ (cost=0.43..0.66 rows=1 width=16) (never executed)

  • Index Cond: ((case_id = c.id) AND (authority_abstract_id = 20))
  • Heap Fetches: 0
19. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..8.38 rows=292 width=8) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Seq Scan on phase_definition_t pdt (cost=0.00..6.92 rows=292 width=8) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.85 rows=1 width=8) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Seq Scan on authority_abstract_t abstractau2_ (cost=0.00..1.85 rows=1 width=8) (never executed)

  • Filter: (id = 20)
Planning time : 13.956 ms