explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3tcA

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 732,685.191 ↓ 0.0 0 1

Update on t_cv_adq (cost=221,638.66..341,277.82 rows=113,838 width=928) (actual time=732,685.191..732,685.191 rows=0 loops=1)

2.          

CTE updates

3. 130.090 130.099 ↑ 366.2 5,672 1

Index Scan using t_parc_adq_dt_conc_pg_idx on t_parcelas_adq parc (cost=0.45..129,036.53 rows=2,077,338 width=4) (actual time=64.222..130.099 rows=5,672 loops=1)

  • Index Cond: (dt_conc_pagto > $0)
  • Filter: ((fl_conc_pagto)::text ~~ 'LIQUIDADO%'::text)
4.          

Initplan (forIndex Scan)

5. 0.009 0.009 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.008..0.009 rows=1 loops=1)

6. 2,144.108 732,685.187 ↓ 0.0 0 1

Hash Join (cost=92,602.13..212,241.29 rows=113,838 width=928) (actual time=732,685.187..732,685.187 rows=0 loops=1)

  • Hash Cond: (updates.t_cv_adq_id = t_cv_adq.id)
7. 140.448 140.448 ↑ 366.2 5,672 1

CTE Scan on updates (cost=0.00..41,546.76 rows=2,077,338 width=32) (actual time=64.259..140.448 rows=5,672 loops=1)

8. 1,759.327 730,400.631 ↓ 1.0 362,819 1

Hash (cost=47,342.33..47,342.33 rows=359,824 width=900) (actual time=730,400.631..730,400.631 rows=362,819 loops=1)

  • Buckets: 262144 Batches: 4 Memory Usage: 26398kB
9. 728,641.304 728,641.304 ↓ 1.0 362,819 1

Index Scan using t_cv_adq_fl_conc_pagto_id1 on t_cv_adq (cost=0.43..47,342.33 rows=359,824 width=900) (actual time=117.199..728,641.304 rows=362,819 loops=1)

  • Index Cond: ((fl_conc_pagto)::text = 'N'::text)
Planning time : 1,723.205 ms
Execution time : 732,689.761 ms