explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P1MF : Optimization for: Optimization for: Optimization for: Optimization for: plan #Fbt; plan #xf1jV; plan #Kw0d; plan #Mj6U

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.068 160.134 ↓ 12.5 100 1

HashAggregate (cost=13,397.40..13,397.56 rows=8 width=17) (actual time=160.117..160.134 rows=100 loops=1)

  • Group Key: cm.id_meter, (cvpc.kmaxima)::numeric(7,3), 'load_process_itine'::text, now()
2. 56.126 160.066 ↓ 12.8 102 1

Hash Join (cost=71.18..13,397.32 rows=8 width=17) (actual time=54.519..160.066 rows=102 loops=1)

  • Hash Cond: ((cm.code_meter)::text = (cvpc.code_meter)::text)
3. 103.220 103.220 ↑ 1.0 215,531 1

Seq Scan on cmc_meter cm (cost=0.00..12,214.32 rows=222,332 width=26) (actual time=0.022..103.220 rows=215,531 loops=1)

4. 0.044 0.720 ↓ 12.8 102 1

Hash (cost=71.08..71.08 rows=8 width=27) (actual time=0.720..0.720 rows=102 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
5. 0.182 0.676 ↓ 12.8 102 1

Bitmap Heap Scan on v_m_pci_principal_carga cvpc (cost=40.51..71.08 rows=8 width=27) (actual time=0.505..0.676 rows=102 loops=1)

  • Recheck Cond: ((grupo = 101655) AND (territorio = 'ERZ'::text))
  • Heap Blocks: exact=37
6. 0.007 0.494 ↓ 0.0 0 1

BitmapAnd (cost=40.51..40.51 rows=8 width=0) (actual time=0.494..0.494 rows=0 loops=1)

7. 0.031 0.031 ↑ 1.0 102 1

Bitmap Index Scan on in_v_m_pci_principal_carga_grupo (cost=0.00..5.05 rows=102 width=0) (actual time=0.031..0.031 rows=102 loops=1)

  • Index Cond: (grupo = 101655)
8. 0.456 0.456 ↑ 1.0 1,456 1

Bitmap Index Scan on in_v_m_pci_principal_carga_territorio (cost=0.00..35.21 rows=1,456 width=0) (actual time=0.456..0.456 rows=1,456 loops=1)

  • Index Cond: (territorio = 'ERZ'::text)
Planning time : 1.499 ms
Execution time : 160.202 ms