explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fI34

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1,228.638 ↓ 0.0 0 1

Delete on tb_arquivo_entrada (cost=54,941.38..56,006.27 rows=265 width=38) (actual time=1,228.638..1,228.638 rows=0 loops=1)

2. 0.000 1,228.635 ↓ 0.0 0 1

Nested Loop (cost=54,941.38..56,006.27 rows=265 width=38) (actual time=1,228.635..1,228.635 rows=0 loops=1)

3. 0.178 1,228.244 ↑ 1.0 100 1

HashAggregate (cost=54,940.95..54,941.95 rows=100 width=40) (actual time=1,228.213..1,228.244 rows=100 loops=1)

  • Group Key: "ANY_subquery".id
4. 0.125 1,228.066 ↑ 1.0 100 1

Subquery Scan on ANY_subquery (cost=0.00..54,940.70 rows=100 width=40) (actual time=1,143.714..1,228.066 rows=100 loops=1)

5. 0.029 1,227.941 ↑ 1.0 100 1

Limit (cost=0.00..54,939.70 rows=100 width=8) (actual time=1,143.698..1,227.941 rows=100 loops=1)

6. 1,227.912 1,227.912 ↑ 2.8 100 1

Seq Scan on tb_arquivo_entrada tb_arquivo_entrada_1 (cost=0.00..154,380.55 rows=281 width=8) (actual time=1,143.696..1,227.912 rows=100 loops=1)

  • Filter: ((nom_arquivo)::text ~~ 'ORI94%'::text)
  • Rows Removed by Filter: 2,819,430
7. 0.400 0.400 ↓ 0.0 0 100

Index Scan using arquivo_origem_idx on tb_arquivo_entrada (cost=0.43..10.61 rows=3 width=14) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (id_arquivo_origem = "ANY_subquery".id)
Planning time : 1.501 ms
Execution time : 1,228.770 ms