explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hyyr

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 87.114 ↑ 1.0 1 1

Aggregate (cost=58,082.70..58,082.71 rows=1 width=16) (actual time=87.114..87.114 rows=1 loops=1)

2. 2.105 63.953 ↓ 228.1 23,495 1

Nested Loop (cost=0.86..57,913.99 rows=103 width=16) (actual time=18.642..63.953 rows=23,495 loops=1)

3. 54.369 54.369 ↓ 47.9 2,493 1

Index Scan using icontrato1 on contrato c (cost=0.43..57,673.05 rows=52 width=8) (actual time=18.634..54.369 rows=2,493 loops=1)

  • Index Cond: (procod = 28)
  • Filter: ((condatcad >= '2019-09-10'::date) AND (condatcad <= '2019-10-30'::date) AND (conati = 0))
  • Rows Removed by Filter: 63,789
4. 7.479 7.479 ↑ 1.4 9 2,493

Index Scan using contrato_parcela_iu0021 on contrato_parcela cp (cost=0.43..4.50 rows=13 width=16) (actual time=0.001..0.003 rows=9 loops=2,493)

  • Index Cond: (concod = c.concod)
5.          

SubPlan (for Aggregate)

6. 23.495 23.495 ↓ 0.0 0 23,495

Index Only Scan using contrato_parcela_retoma_iu0011 on contrato_parcela_retomada cpm (cost=0.43..2.84 rows=2 width=0) (actual time=0.001..0.001 rows=0 loops=23,495)

  • Index Cond: (conparseq = cp.conparseq)
  • Heap Fetches: 2,141
7. 0.000 0.000 ↓ 0.0 0

Seq Scan on contrato_parcela_retomada cpm_1 (cost=0.00..40,286.11 rows=1,190,511 width=8) (never executed)

Planning time : 0.353 ms
Execution time : 87.152 ms