explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UNBe

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 56.024 ↑ 1.0 1 1

Aggregate (cost=57,680.66..57,680.67 rows=1 width=16) (actual time=56.024..56.024 rows=1 loops=1)

2. 0.003 56.000 ↓ 2.5 5 1

Nested Loop (cost=0.86..57,677.39 rows=2 width=16) (actual time=33.832..56.000 rows=5 loops=1)

3. 55.989 55.989 ↑ 1.0 1 1

Index Scan using icontrato1 on contrato c (cost=0.43..57,672.75 rows=1 width=8) (actual time=33.824..55.989 rows=1 loops=1)

  • Index Cond: (procod = 28)
  • Filter: ((condatcad >= '2019-10-01'::date) AND (condatcad <= '2019-10-30'::date) AND (conati = 0))
  • Rows Removed by Filter: 66,281
4. 0.008 0.008 ↑ 2.6 5 1

Index Scan using contrato_parcela_iu0021 on contrato_parcela cp (cost=0.43..4.51 rows=13 width=16) (actual time=0.005..0.008 rows=5 loops=1)

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

SubPlan (for Aggregate)

6. 0.010 0.010 ↑ 2.0 1 5

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.002..0.002 rows=1 loops=5)

  • Index Cond: (conparseq = cp.conparseq)
  • Heap Fetches: 3
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 : 1.211 ms
Execution time : 56.139 ms