explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sgzq

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

Finalize Aggregate (cost=147,731.74..147,731.75 rows=1 width=8) (actual time=343.596..343.596 rows=1 loops=1)

2. 8.712 346.302 ↓ 1.5 3 1

Gather (cost=147,731.52..147,731.73 rows=2 width=8) (actual time=340.974..346.302 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 4.305 337.590 ↑ 1.0 1 3

Partial Aggregate (cost=146,731.52..146,731.53 rows=1 width=8) (actual time=337.590..337.590 rows=1 loops=3)

4. 175.599 333.285 ↑ 1.4 52,934 3

Nested Loop (cost=0.86..146,546.69 rows=73,933 width=0) (actual time=0.079..333.285 rows=52,934 loops=3)

5. 157.683 157.683 ↑ 1.4 52,934 3

Parallel Index Scan using i_traslados_estado on traslados (cost=0.43..95,376.42 rows=73,933 width=4) (actual time=0.040..157.683 rows=52,934 loops=3)

  • Index Cond: (estado = 'A'::text)
6. 0.003 0.003 ↑ 1.0 1 158,801

Index Only Scan using i_docdeu_consdocdeu_key on docdeu (cost=0.42..0.69 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=158,801)

  • Index Cond: (consdocdeu = traslados.consdocdeu)
  • Heap Fetches: 4905
Planning time : 0.596 ms
Execution time : 346.396 ms