explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IBys

Settings
# exclusive inclusive rows x rows loops node
1. 2.684 32,064.479 ↓ 1,314.0 1,314 1

Sort (cost=94,160.60..94,160.61 rows=1 width=75) (actual time=32,063.592..32,064.479 rows=1,314 loops=1)

  • Sort Key: p.data
  • Sort Method: quicksort Memory: 233kB
2. 8,642.075 32,061.795 ↓ 1,314.0 1,314 1

Nested Loop (cost=0.00..94,160.59 rows=1 width=75) (actual time=314.994..32,061.795 rows=1,314 loops=1)

  • Join Filter: (p.loteproducao = loteproducao.codigo)
  • Rows Removed by Join Filter: 12752370
3. 7,350.152 13,559.464 ↓ 1,314.0 1,314 1

Nested Loop (cost=0.00..93,691.49 rows=1 width=75) (actual time=313.200..13,559.464 rows=1,314 loops=1)

  • Join Filter: (p.produto = produto.codigo)
  • Rows Removed by Join Filter: 8221698
4. 310.766 310.766 ↓ 1,314.0 1,314 1

Seq Scan on producaocaixa p (cost=0.00..92,913.47 rows=1 width=44) (actual time=308.758..310.766 rows=1,314 loops=1)

  • Filter: ((data >= '2019-11-22 00:00:00'::timestamp without time zone) AND (data <= '2019-11-22 23:59:59.999'::timestamp without time zone) AND (situacaolote = ANY ('{2,4}'::integer[])))
  • Rows Removed by Filter: 2473736
5. 5,898.546 5,898.546 ↓ 1.0 6,258 1,314

Seq Scan on produto (cost=0.00..700.23 rows=6,223 width=35) (actual time=0.001..4.489 rows=6,258 loops=1,314)

6. 9,860.256 9,860.256 ↓ 1.0 9,706 1,314

Seq Scan on loteproducao (cost=0.00..347.93 rows=9,693 width=4) (actual time=0.002..7.504 rows=9,706 loops=1,314)

Planning time : 0.505 ms
Execution time : 32,065.376 ms