explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E3OF

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 154.811 ↑ 1.0 10 1

Limit (cost=1.26..6.53 rows=10 width=151) (actual time=16.689..154.811 rows=10 loops=1)

2. 0.007 154.793 ↑ 6,783.0 10 1

Append (cost=1.26..35,728.07 rows=67,830 width=151) (actual time=16.687..154.793 rows=10 loops=1)

3. 46.652 154.786 ↑ 1.5 10 1

Nested Loop (cost=1.26..2,117.54 rows=15 width=151) (actual time=16.685..154.786 rows=10 loops=1)

4. 0.025 8.324 ↑ 1.9 15 1

Nested Loop (cost=0.84..2,085.85 rows=29 width=80) (actual time=8.250..8.324 rows=15 loops=1)

5. 0.006 5.254 ↑ 5.0 1 1

Nested Loop (cost=0.42..1,989.63 rows=5 width=80) (actual time=5.253..5.254 rows=1 loops=1)

6. 0.718 0.718 ↑ 68.0 1 1

Seq Scan on top_challenge_list (cost=0.00..69.36 rows=68 width=52) (actual time=0.718..0.718 rows=1 loops=1)

  • Filter: (is_active AND ((template_challenge)::text = 'top_sales'::text) AND (date_fin_challenge >= CURRENT_DATE))
  • Rows Removed by Filter: 39
7. 4.530 4.530 ↑ 1.0 1 1

Index Scan using ref_people_xperf01 on ref_people (cost=0.42..28.23 rows=1 width=28) (actual time=4.530..4.530 rows=1 loops=1)

  • Index Cond: (id_int = top_challenge_list.id_int_manager)
  • Filter: (is_active AND (id_statut <> 2) AND (id_statut <> 2) AND (COALESCE(id_qualification, 1) >= 1) AND (id_type = 5) AND (id_filiale = 2))
8. 3.045 3.045 ↓ 1.5 15 1

Index Scan using ref_genealogy_xperf05 on ref_genealogy (cost=0.42..19.14 rows=10 width=8) (actual time=2.992..3.045 rows=15 loops=1)

  • Index Cond: (id_int = ref_people.id_int)
  • Filter: (is_active AND (level >= 0) AND (level <= 5))
  • Rows Removed by Filter: 5
9. 99.810 99.810 ↑ 1.0 1 15

Index Scan using ref_people_xperf01 on ref_people filleuls (cost=0.42..0.94 rows=1 width=43) (actual time=3.554..6.654 rows=1 loops=15)

  • Index Cond: (id_int = ref_genealogy.id_int_level)
  • Filter: (is_active AND (id_type = 5))
  • Rows Removed by Filter: 6
10. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..32,593.07 rows=67,815 width=151) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Seq Scan on top_challenge_list top_challenge_list_1 (cost=0.00..71.98 rows=5 width=52) (never executed)

  • Filter: ((id_int_manager IS NULL) AND is_active AND (id_filiale = 2) AND ((template_challenge)::text = 'top_sales'::text) AND (date_fin_challenge >= CURRENT_DATE))
12. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.42..13,566.80 rows=13,563 width=43) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Index Scan using ref_people_xperf12 on ref_people ref_people_1 (cost=0.42..13,498.99 rows=13,563 width=43) (never executed)

  • Index Cond: (is_active = true)
  • Filter: (is_active AND (id_statut <> 2) AND (id_filiale = 2) AND (id_type = 5))
Planning time : 54.690 ms