explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NcqD

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

Subquery Scan on a (cost=9,740.49..26,686.80 rows=100 width=605) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Limit (cost=9,740.49..9,746.99 rows=100 width=533) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on adv_exploitation (cost=0.00..20,808.42 rows=320,442 width=533) (actual rows= loops=)

4.          

SubPlan (forSubquery Scan)

5. 0.000 0.000 ↓ 0.0

Aggregate (cost=90.93..90.94 rows=1 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using idx_fma_chep_dasort on "IPGMOU" ipgmou (cost=0.57..90.91 rows=8 width=13) (actual rows= loops=)

  • Index Cond: ((a.numerocheptel = "CHEIPG") AND ("COSU" = '0'::bpchar) AND ("DASORT" IS NULL))
  • Filter: (a.codepayscheptel = "COPAIP")
7. 0.000 0.000 ↓ 0.0

Result (cost=1.55..1.56 rows=1 width=8) (actual rows= loops=)

8.          

Initplan (forResult)

9. 0.000 0.000 ↓ 0.0

Limit (cost=0.57..1.55 rows=1 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Only Scan Backward using idx_fma_chep_dasort on "IPGMOU" ipgmou_1 (cost=0.57..1,297.79 rows=1,319 width=8) (actual rows= loops=)

  • Index Cond: (("CHEIPG" = a.numerocheptel) AND ("COSU" = '0'::bpchar) AND ("DASORT" IS NOT NULL))
11. 0.000 0.000 ↓ 0.0

Result (cost=3.74..3.75 rows=1 width=8) (actual rows= loops=)

12.          

Initplan (forResult)

13. 0.000 0.000 ↓ 0.0

Limit (cost=0.57..3.74 rows=1 width=8) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Only Scan Backward using idx_fma_chep_daench on "IPGMOU" ipgmou_2 (cost=0.57..1,393.50 rows=439 width=8) (actual rows= loops=)

  • Index Cond: (("CHEIPG" = a.numerocheptel) AND ("COSU" = '0'::bpchar) AND ("DAENCH" IS NOT NULL))
  • Filter: ("CAENTR" <> 'N'::bpchar)
15. 0.000 0.000 ↓ 0.0

Result (cost=1.56..1.57 rows=1 width=8) (actual rows= loops=)

16.          

Initplan (forResult)

17. 0.000 0.000 ↓ 0.0

Limit (cost=0.57..1.56 rows=1 width=8) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Index Only Scan Backward using idx_fma_chep_daench on "IPGMOU" ipgmou_3 (cost=0.57..963.93 rows=966 width=8) (actual rows= loops=)

  • Index Cond: (("CHEIPG" = a.numerocheptel) AND ("COSU" = '0'::bpchar) AND ("DAENCH" IS NOT NULL) AND ("CAENTR" = 'N'::bpchar))
19. 0.000 0.000 ↓ 0.0

Aggregate (cost=44.32..44.33 rows=1 width=8) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Index Scan using idx_fma_bobouc_nuenti on "BOBOUC" bobouc (cost=0.57..44.22 rows=41 width=0) (actual rows= loops=)

  • Index Cond: ((a.numerocheptel = "NUENTI") AND ("TYCOMM" = ANY ('{N98,N10}'::bpchar[])) AND ("DAUTIL" IS NULL))
  • Filter: ("COSU" = '0'::bpchar)
21. 0.000 0.000 ↓ 0.0

Aggregate (cost=4.88..4.89 rows=1 width=8) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Index Scan using "idx_REJET_IDENTIFICATION_BOVIN_NUCHEP" on "REJET_IDENTIFICATION_BOVIN" (cost=0.42..4.88 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((a.numerocheptel)::text = ("NUCHEP")::text)
  • Filter: ("ETAT_LOGIQUE" = '1'::numeric)
23. 0.000 0.000 ↓ 0.0

Aggregate (cost=11.58..11.59 rows=1 width=8) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Index Scan using "idx_REJET_ENTREE_SORTIE_BOVIN_NUCHEP" on "REJET_ENTREE_SORTIE_BOVIN" (cost=0.42..11.57 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((a.numerocheptel)::text = ("NUCHEP")::text)
  • Filter: ("ETAT_LOGIQUE" = '1'::numeric)
25. 0.000 0.000 ↓ 0.0

Aggregate (cost=5.36..5.37 rows=1 width=8) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..5.36 rows=1 width=8) (actual rows= loops=)

  • Join Filter: (eget_rattachement_exploitation."ID_EGET_INFO_GENERALE" = eget_espece_elementaire."ID_EGET_INFO_GENERALE")
27. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.58..5.02 rows=1 width=10) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Index Scan using "idx_EGET_RATTACHEMENT_EXPLOITATION_NUCHEP" on "EGET_RATTACHEMENT_EXPLOITATION" eget_rattachement_exploitation (cost=0.29..2.51 rows=1 width=5) (actual rows= loops=)

  • Index Cond: (a.numerocheptel = "NUCHEP")
  • Filter: ("ETAT_LOGIQUE" = '1'::numeric)
29. 0.000 0.000 ↓ 0.0

Index Scan using "EGET_INFO_GENERALE_pkey" on "EGET_INFO_GENERALE" eget_info_generale (cost=0.29..2.51 rows=1 width=5) (actual rows= loops=)

  • Index Cond: ("ID_EGET_INFO_GENERALE" = eget_rattachement_exploitation."ID_EGET_INFO_GENERALE")
  • Filter: ("ETAT_LOGIQUE" = '1'::numeric)
30. 0.000 0.000 ↓ 0.0

Index Scan using "idx_EGET_ESPECE_ELEMENTAIRE_ID_EGET_INFO_GENERALE" on "EGET_ESPECE_ELEMENTAIRE" eget_espece_elementaire (cost=0.29..0.33 rows=1 width=13) (actual rows= loops=)

  • Index Cond: ("ID_EGET_INFO_GENERALE" = eget_info_generale."ID_EGET_INFO_GENERALE")
  • Filter: (("DATE_FIN" IS NULL) AND ("ETAT_LOGIQUE" = '1'::numeric) AND ("ID_ESPECE_ELEMENTAIRE_EGET" = '19'::numeric))
31. 0.000 0.000 ↓ 0.0

Aggregate (cost=5.36..5.37 rows=1 width=8) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..5.36 rows=1 width=8) (actual rows= loops=)

  • Join Filter: (eget_rattachement_exploitation_1."ID_EGET_INFO_GENERALE" = eget_espece_elementaire_1."ID_EGET_INFO_GENERALE")
33. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.58..5.02 rows=1 width=10) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Index Scan using "idx_EGET_RATTACHEMENT_EXPLOITATION_NUCHEP" on "EGET_RATTACHEMENT_EXPLOITATION" eget_rattachement_exploitation_1 (cost=0.29..2.51 rows=1 width=5) (actual rows= loops=)

  • Index Cond: (a.numerocheptel = "NUCHEP")
  • Filter: ("ETAT_LOGIQUE" = '1'::numeric)
35. 0.000 0.000 ↓ 0.0

Index Scan using "EGET_INFO_GENERALE_pkey" on "EGET_INFO_GENERALE" eget_info_generale_1 (cost=0.29..2.51 rows=1 width=5) (actual rows= loops=)

  • Index Cond: ("ID_EGET_INFO_GENERALE" = eget_rattachement_exploitation_1."ID_EGET_INFO_GENERALE")
  • Filter: ("ETAT_LOGIQUE" = '1'::numeric)
36. 0.000 0.000 ↓ 0.0

Index Scan using "idx_EGET_ESPECE_ELEMENTAIRE_ID_EGET_INFO_GENERALE" on "EGET_ESPECE_ELEMENTAIRE" eget_espece_elementaire_1 (cost=0.29..0.33 rows=1 width=13) (actual rows= loops=)

  • Index Cond: ("ID_EGET_INFO_GENERALE" = eget_info_generale_1."ID_EGET_INFO_GENERALE")