explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RHHb

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 2.544 ↑ 1.0 5 1

Limit (cost=1.27..3,878.21 rows=5 width=172) (actual time=0.245..2.544 rows=5 loops=1)

2. 0.183 2.539 ↑ 12.4 5 1

Nested Loop (cost=1.27..48,075.41 rows=62 width=172) (actual time=0.244..2.539 rows=5 loops=1)

3. 0.006 0.151 ↑ 13.0 5 1

Nested Loop (cost=0.84..2,420.02 rows=65 width=85) (actual time=0.137..0.151 rows=5 loops=1)

4. 0.008 0.119 ↑ 5.0 1 1

Nested Loop (cost=0.42..2,356.20 rows=5 width=85) (actual time=0.118..0.119 rows=1 loops=1)

5. 0.043 0.043 ↑ 14.5 4 1

Seq Scan on top_challenge_list (cost=0.00..30.26 rows=58 width=57) (actual time=0.036..0.043 rows=4 loops=1)

  • Filter: (is_active AND ((template_challenge)::text = 'top_turnover'::text))
  • Rows Removed by Filter: 26
6. 0.068 0.068 ↓ 0.0 0 4

Index Scan using ref_people_xperf1 on ref_people (cost=0.42..40.09 rows=1 width=28) (actual time=0.017..0.017 rows=0 loops=4)

  • Index Cond: (id_int = top_challenge_list.id_int_manager)
  • Filter: (is_active AND (id_statut <> 2) AND (COALESCE(id_qualification, 1) >= 1) AND (id_type = 5))
  • Rows Removed by Filter: 4
7. 0.026 0.026 ↑ 4.0 5 1

Index Scan using ref_genealogy_xperf5 on ref_genealogy (cost=0.42..12.56 rows=20 width=8) (actual time=0.017..0.026 rows=5 loops=1)

  • Index Cond: (id_int = ref_people.id_int)
  • Filter: is_active
8. 0.150 0.150 ↑ 1.0 1 5

Index Scan using ref_people_xperf1 on ref_people filleuls (cost=0.42..0.82 rows=1 width=47) (actual time=0.012..0.030 rows=1 loops=5)

  • Index Cond: (id_int = ref_genealogy.id_int_level)
  • Filter: (is_active AND (id_type = ANY ('{5,14}'::integer[])))
  • Rows Removed by Filter: 7
9.          

SubPlan (forNested Loop)

10. 0.020 1.165 ↑ 1.0 1 5

Aggregate (cost=361.46..361.47 rows=1 width=8) (actual time=0.233..0.233 rows=1 loops=5)

11. 1.145 1.145 ↓ 0.0 0 5

Index Scan using ref_transaction_xperf4 on ref_transaction (cost=0.42..361.46 rows=1 width=8) (actual time=0.155..0.229 rows=0 loops=5)

  • Index Cond: (id_int_agent_out = filleuls.id_int)
  • Filter: (is_active AND (date_acte IS NOT NULL) AND (date_acte >= top_challenge_list.date_deb_challenge) AND (date_acte <= top_challenge_list.date_fin_challenge) AND (id_type_transaction = 1))
  • Rows Removed by Filter: 100
12. 0.020 0.890 ↑ 1.0 1 5

Aggregate (cost=373.99..374.00 rows=1 width=8) (actual time=0.177..0.178 rows=1 loops=5)

13. 0.870 0.870 ↓ 0.0 0 5

Index Scan using ref_transaction_xperf3 on ref_transaction ref_transaction_1 (cost=0.42..373.99 rows=1 width=8) (actual time=0.117..0.174 rows=0 loops=5)

  • Index Cond: (id_int_agent_in = filleuls.id_int)
  • Filter: (is_active AND (date_acte IS NOT NULL) AND (date_acte >= top_challenge_list.date_deb_challenge) AND (date_acte <= top_challenge_list.date_fin_challenge) AND (id_type_transaction = 1))
  • Rows Removed by Filter: 102
Planning time : 2.916 ms
Execution time : 2.900 ms