explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s3ne

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

Update on t_cv_adq adq (cost=0.86..405,381.53 rows=341,514 width=906) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=0.86..405,381.53 rows=341,514 width=906) (actual rows= loops=)

3. 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)
4. 0.000 0.000 ↓ 0.0

Index Scan using fk_t_parcelas_adq_t_cv_adq1_id on t_parcelas_adq parc (cost=0.43..0.99 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (t_cv_adq_id = adq.id)
  • Filter: ((fl_conc_pagto)::text ~~ 'LIQUIDADO%'::text)