explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Chnd

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

Subquery Scan on x (cost=3.51..43,127.28 rows=1,000 width=160) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Limit (cost=3.51..43,094.78 rows=1,000 width=90) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=3.51..1,295,068.40 rows=30,054 width=90) (actual rows= loops=)

  • Merge Cond: (iptubase.j01_matric = iptuant.j40_matric)
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=3.22..109,588.58 rows=30,054 width=75) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=2.94..100,106.69 rows=30,054 width=79) (actual rows= loops=)

  • Merge Cond: (iptubase.j01_matric = iptumatzonaentrega.j86_matric)
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.79..99,935.03 rows=30,054 width=75) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.50..89,837.26 rows=30,054 width=79) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Merge Join (cost=2.21..78,314.44 rows=30,054 width=60) (actual rows= loops=)

  • Merge Cond: (iptubase.j01_matric = iptunump.j20_matric)
9. 0.000 0.000 ↓ 0.0

Merge Join (cost=0.71..67,458.52 rows=36,405 width=56) (actual rows= loops=)

  • Merge Cond: (iptucalc.j23_matric = iptubase.j01_matric)
10. 0.000 0.000 ↓ 0.0

Index Scan using iptucalc_ae_matr_pk on iptucalc (cost=0.42..65,031.40 rows=36,405 width=44) (actual rows= loops=)

  • Index Cond: (j23_anousu = 2019)
11. 0.000 0.000 ↓ 0.0

Index Scan using iptubase_matr_pk on iptubase (cost=0.29..1,890.01 rows=36,781 width=12) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Scan using iptunump_ae_matr_pk on iptunump (cost=0.42..10,726.16 rows=30,364 width=8) (actual rows= loops=)

  • Index Cond: (j20_anousu = 2019)
13. 0.000 0.000 ↓ 0.0

Index Scan using lote_idbq_pk on lote (cost=0.29..0.37 rows=1 width=19) (actual rows= loops=)

  • Index Cond: (j34_idbql = iptubase.j01_idbql)
14. 0.000 0.000 ↓ 0.0

Index Only Scan using cgm_numc_pk on cgm (cost=0.29..0.33 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (z01_numcgm = iptubase.j01_numcgm)
15. 0.000 0.000 ↓ 0.0

Index Scan using iptumatzonaentrega_matric_in on iptumatzonaentrega (cost=0.15..74.75 rows=2,040 width=8) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Index Only Scan using loteloteam_idbq_lote_pk on loteloteam (cost=0.29..0.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (j34_idbql = lote.j34_idbql)
17. 0.000 0.000 ↓ 0.0

Index Scan using iptuant_matr_pk on iptuant (cost=0.29..1,960.53 rows=35,533 width=23) (actual rows= loops=)

18.          

SubPlan (forMerge Left Join)

19. 0.000 0.000 ↓ 0.0

Limit (cost=2.16..39.11 rows=1 width=40) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Subquery Scan on x_1 (cost=2.16..39.11 rows=1 width=40) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.16..39.08 rows=1 width=60) (actual rows= loops=)

22.          

Initplan (forNested Loop Left Join)

23. 0.000 0.000 ↓ 0.0

Limit (cost=0.14..1.01 rows=1 width=5) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Index Scan Backward using cfiptu_ae_pk on cfiptu (cost=0.14..12.42 rows=14 width=5) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.86..24.93 rows=1 width=36) (actual rows= loops=)

  • Join Filter: (iptubase_1.j01_matric = promitente.j41_matric)
26. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.58..16.62 rows=1 width=32) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Index Scan using iptubase_matr_pk on iptubase iptubase_1 (cost=0.29..8.31 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (j01_matric = iptucalc.j23_matric)
28. 0.000 0.000 ↓ 0.0

Index Scan using cgm_numc_pk on cgm cgm_1 (cost=0.29..8.31 rows=1 width=28) (actual rows= loops=)

  • Index Cond: (z01_numcgm = iptubase_1.j01_numcgm)
29. 0.000 0.000 ↓ 0.0

Index Scan using promitente_matr_numc_pk on promitente (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (j41_matric = iptucalc.j23_matric)
  • Filter: (j41_tipopro IS TRUE)
30. 0.000 0.000 ↓ 0.0

Index Scan using cgm_numc_pk on cgm promite (cost=0.29..8.31 rows=1 width=28) (actual rows= loops=)

  • Index Cond: (z01_numcgm = promitente.j41_numcgm)
31.          

SubPlan (forNested Loop Left Join)

32. 0.000 0.000 ↓ 0.0

Aggregate (cost=4.30..4.31 rows=1 width=4) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Index Only Scan using promitente_matr_numc_pk on promitente promitente_1 (cost=0.28..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (j41_matric = iptubase_1.j01_matric)