explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FXeA

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 24,869.920 ↑ 1.0 1 1

Finalize Aggregate (cost=1,786,068.07..1,786,068.08 rows=1 width=8) (actual time=24,869.920..24,869.920 rows=1 loops=1)

2. 8.006 24,870.953 ↓ 1.5 3 1

Gather (cost=1,786,067.86..1,786,068.07 rows=2 width=8) (actual time=24,869.799..24,870.953 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.004 24,862.947 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=1,785,067.86..1,785,067.87 rows=1 width=8) (actual time=24,862.947..24,862.947 rows=1 loops=3)

4. 4,521.487 24,862.943 ↑ 4,813,470.0 1 3 / 3

Parallel Hash Join (cost=535.28..1,773,034.18 rows=4,813,470 width=4) (actual time=18,258.880..24,862.943 rows=1 loops=3)

  • Hash Cond: ((ta.it_documento)::integer = (tbc.it_registro)::integer)
5. 20,337.389 20,337.389 ↑ 1.2 19,871,731 3 / 3

Parallel Seq Scan on tb_arquivos ta (cost=0.00..1,651,035.63 rows=24,839,663 width=8) (actual time=0.013..20,337.389 rows=19,871,731 loops=3)

6. 2.214 4.067 ↑ 1.8 7,469 3 / 3

Parallel Hash (cost=370.53..370.53 rows=13,180 width=4) (actual time=4.066..4.067 rows=7,469 loops=3)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,184kB
7. 1.853 1.853 ↑ 1.8 7,469 3 / 3

Parallel Index Only Scan using tb_buscador_cache_it_registro_with_it_historico_pesquisa on tb_buscador_cache tbc (cost=0.29..370.53 rows=13,180 width=4) (actual time=0.048..1.853 rows=7,469 loops=3)

  • Index Cond: (it_historico_pesquisa = 881)
  • Heap Fetches: 0
Planning time : 0.840 ms
Execution time : 24,871.060 ms