explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wzc5

Settings
# exclusive inclusive rows x rows loops node
1. 0.060 5.768 ↓ 12.2 98 1

Nested Loop (cost=36.04..180.65 rows=8 width=64) (actual time=0.377..5.768 rows=98 loops=1)

2. 0.102 2.180 ↓ 12.2 98 1

Nested Loop (cost=36.04..133.60 rows=8 width=16) (actual time=0.345..2.180 rows=98 loops=1)

3. 0.102 0.412 ↓ 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.320..0.412 rows=98 loops=1)

  • Recheck Cond: ((grupo = 101655) AND (territorio = 'ERZ'::text))
  • Heap Blocks: exact=41
4. 0.007 0.310 ↓ 0.0 0 1

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

5. 0.028 0.028 ↑ 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.028..0.028 rows=98 loops=1)

  • Index Cond: (grupo = 101655)
6. 0.275 0.275 ↑ 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.275..0.275 rows=1,342 loops=1)

  • Index Cond: (territorio = 'ERZ'::text)
7. 1.666 1.666 ↑ 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.017..0.017 rows=1 loops=98)

  • Index Cond: ((code_derivation)::text = (cvpc.derivation)::text)
8. 0.196 3.528 ↑ 4.0 1 98

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

9. 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)
10. 2.058 2.058 ↑ 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.021..0.021 rows=1 loops=98)

  • Index Cond: ((estate)::text = (cede.code_estate)::text)
11. 0.686 0.686 ↓ 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.007..0.007 rows=0 loops=98)

  • Index Cond: ((estate)::text = (cede.code_estate)::text)
12. 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)