explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nyi9

Settings
# exclusive inclusive rows x rows loops node
1. 0.059 16.306 ↓ 0.0 0 1

Delete on tb_contrato_fatura_resumo (cost=52.96..135.97 rows=10 width=34) (actual time=16.306..16.306 rows=0 loops=1)

2. 0.009 16.247 ↑ 1.0 10 1

Nested Loop (cost=52.96..135.97 rows=10 width=34) (actual time=16.205..16.247 rows=10 loops=1)

3. 0.021 16.188 ↑ 1.0 10 1

HashAggregate (cost=52.67..52.77 rows=10 width=32) (actual time=16.181..16.188 rows=10 loops=1)

  • Group Key: "ANY_subquery".id
4. 0.019 16.167 ↑ 1.0 10 1

Subquery Scan on ANY_subquery (cost=0.00..52.65 rows=10 width=32) (actual time=16.159..16.167 rows=10 loops=1)

5. 0.004 16.148 ↑ 1.0 10 1

Limit (cost=0.00..52.55 rows=10 width=4) (actual time=16.144..16.148 rows=10 loops=1)

6. 16.144 16.144 ↑ 82.2 10 1

Seq Scan on tb_contrato_fatura_resumo tb_contrato_fatura_resumo_1 (cost=0.00..4,319.38 rows=822 width=4) (actual time=16.141..16.144 rows=10 loops=1)

  • Filter: (contrato_fatura_id = 377)
  • Rows Removed by Filter: 57826
7. 0.050 0.050 ↑ 1.0 1 10

Index Scan using tb_contrato_fatura_resumo_pkey on tb_contrato_fatura_resumo (cost=0.29..8.31 rows=1 width=10) (actual time=0.004..0.005 rows=1 loops=10)

  • Index Cond: (id = "ANY_subquery".id)
Planning time : 0.393 ms
Execution time : 18,690.912 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint tb_contrato_fatura_desconto_fk 29.858 ms 10 2.986 ms
for constraint tb_contrato_fatura_endereco_fk 12.979 ms 10 1.298 ms
for constraint tb_contrato_fatura_servico_fk 2,281.358 ms 10 228.136 ms
for constraint tb_contrato_fatura_bilhetacao_fk 16,350.291 ms 10 1,635.029 ms