explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I5j3

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 987,429.875 ↓ 0.0 0 1

Update on t_cv_adq adq (cost=0.43..609,567.33 rows=179,912 width=900) (actual time=987,429.875..987,429.875 rows=0 loops=1)

2. 575,993.124 987,429.870 ↓ 0.0 0 1

Index Scan using t_cv_adq_fl_conc_pagto_id1 on t_cv_adq adq (cost=0.43..609,567.33 rows=179,912 width=900) (actual time=987,429.870..987,429.870 rows=0 loops=1)

  • Index Cond: ((fl_conc_pagto)::text = 'N'::text)
  • Filter: (SubPlan 2)
  • Rows Removed by Filter: 362819
3.          

SubPlan (forIndex Scan)

4. 411,436.746 411,436.746 ↓ 0.0 0 362,819

Index Scan using fk_t_parcelas_adq_t_cv_adq1_id on t_parcelas_adq parc (cost=0.45..2.67 rows=1 width=4) (actual time=1.134..1.134 rows=0 loops=362,819)

  • Index Cond: (t_cv_adq_id = adq.id)
  • Filter: (((fl_conc_pagto)::text ~~ 'LIQUIDADO%'::text) AND (dt_conc_pagto > $0))
  • Rows Removed by Filter: 1
5.          

Initplan (forIndex Scan)

6. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

Planning time : 609.795 ms
Execution time : 987,430.065 ms