explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UWgB

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 40.342 ↓ 0.0 0 1

Update on t_cv_adq (cost=249.36..10,643.43 rows=219 width=928) (actual time=40.342..40.342 rows=0 loops=1)

2.          

CTE updates

3. 6.051 12.440 ↑ 1.0 4,000 1

Limit (cost=0.45..248.93 rows=4,000 width=4) (actual time=0.054..12.440 rows=4,000 loops=1)

4.          

Initplan (forLimit)

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. 6.380 6.380 ↑ 519.3 4,000 1

Index Scan using t_parc_adq_dt_conc_pg_idx on t_parcelas_adq parc (cost=0.43..129,046.41 rows=2,077,338 width=4) (actual time=0.051..6.380 rows=4,000 loops=1)

  • Index Cond: (dt_conc_pagto > $0)
  • Filter: ((fl_conc_pagto)::text ~~ 'LIQUIDADO%'::text)
7. 8.395 40.338 ↓ 0.0 0 1

Nested Loop (cost=0.43..10,394.50 rows=219 width=928) (actual time=40.338..40.338 rows=0 loops=1)

8. 19.943 19.943 ↑ 1.0 4,000 1

CTE Scan on updates (cost=0.00..80.00 rows=4,000 width=32) (actual time=0.062..19.943 rows=4,000 loops=1)

9. 12.000 12.000 ↓ 0.0 0 4,000

Index Scan using t_cv_adq_pkey on t_cv_adq (cost=0.43..2.57 rows=1 width=900) (actual time=0.003..0.003 rows=0 loops=4,000)

  • Index Cond: (id = updates.t_cv_adq_id)
  • Filter: ((fl_conc_pagto)::text = 'N'::text)
  • Rows Removed by Filter: 1
Planning time : 0.524 ms
Execution time : 40.541 ms