explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bt1

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

Update on t_cv_adq adq (cost=323,787.92..601,179.42 rows=341,514 width=928) (actual rows= loops=)

2.          

CTE parc

3. 0.000 0.000 ↓ 0.0

Seq Scan on t_parcelas_adq parc_1 (cost=0.00..231,185.79 rows=6,232,015 width=4) (actual rows= loops=)

  • Filter: ((fl_conc_pagto)::text ~~ 'LIQUIDADO%'::text)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=92,602.13..369,993.63 rows=341,514 width=928) (actual rows= loops=)

  • Hash Cond: (parc.t_cv_adq_id = adq.id)
5. 0.000 0.000 ↓ 0.0

CTE Scan on parc (cost=0.00..124,640.30 rows=6,232,015 width=32) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=47,342.33..47,342.33 rows=359,824 width=900) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using t_cv_adq_fl_conc_pagto_id1 on t_cv_adq adq (cost=0.43..47,342.33 rows=359,824 width=900) (actual rows= loops=)

  • Index Cond: ((fl_conc_pagto)::text = 'N'::text)