explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2zdO

Settings
# exclusive inclusive rows x rows loops node
1. 0.417 1,658.700 ↓ 10.2 82 1

HashAggregate (cost=250.55..320.25 rows=8 width=84) (actual time=1,658.668..1,658.700 rows=82 loops=1)

  • Group Key: cede.code_estate, cvpc.territorio, (SubPlan 1), epc.vutmx, epc.vutmy, epc.vutmz, epc.timezone, epc.vgeodes, epc.tfuenutm, epc.tfiabutm, f_pci_get_ind_mandatory_capture(cede.code_estate, 'F'::character varying, 'S'::character varying, '00'::character varying, '00'::character varying, '57'::character varying, 'NA'::character varying), 'N'::text, 'N'::text, 'load_process_itine'::text, now()
2. 1,646.885 1,658.283 ↓ 12.2 98 1

Nested Loop (cost=36.04..250.25 rows=8 width=84) (actual time=29.007..1,658.283 rows=98 loops=1)

3. 0.152 2.676 ↓ 12.2 98 1

Nested Loop (cost=36.04..133.60 rows=8 width=36) (actual time=0.545..2.676 rows=98 loops=1)

4. 0.172 0.662 ↓ 12.2 98 1

Bitmap Heap Scan on v_m_pci_principal_carga cvpc (cost=35.62..66.00 rows=8 width=24) (actual time=0.504..0.662 rows=98 loops=1)

  • Recheck Cond: ((grupo = 101655) AND (territorio = 'ERZ'::text))
  • Heap Blocks: exact=41
5. 0.010 0.490 ↓ 0.0 0 1

BitmapAnd (cost=35.62..35.62 rows=8 width=0) (actual time=0.490..0.490 rows=0 loops=1)

6. 0.071 0.071 ↑ 1.0 98 1

Bitmap Index Scan on in_v_m_pci_principal_carga_grupo (cost=0.00..5.02 rows=98 width=0) (actual time=0.071..0.071 rows=98 loops=1)

  • Index Cond: (grupo = 101655)
7. 0.409 0.409 ↑ 1.0 1,342 1

Bitmap Index Scan on in_v_m_pci_principal_carga_territorio (cost=0.00..30.35 rows=1,342 width=0) (actual time=0.409..0.409 rows=1,342 loops=1)

  • Index Cond: (territorio = 'ERZ'::text)
8. 1.862 1.862 ↑ 1.0 1 98

Index Scan using in_cmc_estate_deriv_extract_code_derivation on cmc_estate_deriv_extract cede (cost=0.42..8.44 rows=1 width=32) (actual time=0.018..0.019 rows=1 loops=98)

  • Index Cond: ((code_derivation)::text = (cvpc.derivation)::text)
9. 0.490 6.370 ↑ 4.0 1 98

Append (cost=0.00..5.84 rows=4 width=118) (actual time=0.025..0.065 rows=1 loops=98)

10. 0.000 0.000 ↓ 0.0 0 98

Seq Scan on estate epc (cost=0.00..0.00 rows=1 width=292) (actual time=0.000..0.000 rows=0 loops=98)

  • Filter: ((cede.code_estate)::text = (estate)::text)
11. 2.352 2.352 ↑ 1.0 1 98

Index Scan using pk_estate_ges_erz_une on estate_ges_erz_une epc_1 (cost=0.43..1.47 rows=1 width=61) (actual time=0.023..0.024 rows=1 loops=98)

  • Index Cond: ((estate)::text = (cede.code_estate)::text)
12. 2.940 2.940 ↓ 0.0 0 98

Index Scan using pk_estate_sev on estate_sev epc_2 (cost=0.43..2.62 rows=1 width=65) (actual time=0.030..0.030 rows=0 loops=98)

  • Index Cond: ((estate)::text = (cede.code_estate)::text)
13. 0.588 0.588 ↓ 0.0 0 98

Index Scan using pk_estate_fec on estate_fec epc_3 (cost=0.43..1.75 rows=1 width=54) (actual time=0.006..0.006 rows=0 loops=98)

  • Index Cond: ((estate)::text = (cede.code_estate)::text)
14.          

SubPlan (forNested Loop)

15. 0.196 2.352 ↑ 1.0 1 98

HashAggregate (cost=8.44..8.45 rows=1 width=8) (actual time=0.024..0.024 rows=1 loops=98)

  • Group Key: cmc_supply.id_itinerary_orig
16. 2.156 2.156 ↑ 1.0 1 98

Index Scan using uk_supply_derivation on cmc_supply (cost=0.42..8.44 rows=1 width=8) (actual time=0.021..0.022 rows=1 loops=98)

  • Index Cond: ((code_derivation)::text = (cvpc.derivation)::text)
Planning time : 5.470 ms
Execution time : 1,658.900 ms