explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IKrP

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 2,883.629 ↑ 1.0 1 1

Aggregate (cost=292,878.89..292,878.90 rows=1 width=8) (actual time=2,883.628..2,883.629 rows=1 loops=1)

  • Buffers: shared hit=198 read=220345
  • I/O Timings: read=4552.728
2. 0.002 2,883.620 ↓ 0.0 0 1

Nested Loop (cost=1,000.56..292,878.88 rows=1 width=4) (actual time=2,883.619..2,883.620 rows=0 loops=1)

  • Join Filter: (((unidade1_.id_gestora = unidade2_.id_gestora) AND (unidade2_.id_gestora = 10)) OR (unidade1_.id_gestora <> unidade2_.id_gestora))
  • Buffers: shared hit=198 read=220345
  • I/O Timings: read=4552.728
3. 0.000 2,883.618 ↓ 0.0 0 1

Nested Loop (cost=1,000.28..292,870.57 rows=1 width=12) (actual time=2,883.617..2,883.618 rows=0 loops=1)

  • Buffers: shared hit=198 read=220345
  • I/O Timings: read=4552.728
4. 11.317 2,887.796 ↓ 0.0 0 1

Gather (cost=1,000.00..292,862.27 rows=1 width=12) (actual time=2,883.605..2,887.796 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=198 read=220345
  • I/O Timings: read=4552.728
5. 2,876.479 2,876.479 ↓ 0.0 0 3

Parallel Seq Scan on movimentacao_bem movimentac0_ (cost=0.00..291,862.17 rows=1 width=12) (actual time=2,876.478..2,876.479 rows=0 loops=3)

  • Filter: ((data_recebimento IS NOT NULL) AND (id_usuario_estorno IS NULL) AND (data_recebimento IS NOT NULL) AND (id_usuario_estorno IS NULL) AND (tipo_status_movimentacao = 1))
  • Rows Removed by Filter: 4565581
  • Buffers: shared hit=198 read=220345
  • I/O Timings: read=4552.728
6. 0.000 0.000 ↓ 0.0 0

Index Scan using unidade_pkey on unidade unidade1_ (cost=0.28..8.30 rows=1 width=8) (never executed)

  • Index Cond: (id_unidade = movimentac0_.id_unidade_destino)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using unidade_pkey on unidade unidade2_ (cost=0.28..8.30 rows=1 width=8) (never executed)

  • Index Cond: (id_unidade = movimentac0_.id_unidade_origem)
Planning time : 1.270 ms
Execution time : 2,887.919 ms