explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JHSH

Settings
# exclusive inclusive rows x rows loops node
1. 11.749 47.021 ↑ 75.3 9 1

Gather (cost=1,000.00..13,135.88 rows=678 width=18) (actual time=34.834..47.021 rows=9 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 35.272 35.272 ↑ 94.0 3 3 / 3

Parallel Seq Scan on estoquecomb ec (cost=0.00..12,068.08 rows=282 width=18) (actual time=28.071..35.272 rows=3 loops=3)

  • Filter: ((esc_qtde > '0'::numeric) AND (esc_data <= '2020-05-31 00:00:00'::timestamp without time zone) AND (cfg_chave = ANY ('{894,895,1123,1248,1361,1368,1417,1515,1525,1741,1777,1791,1908,1922,2363,2491,2492}'::bigint[])))
  • Rows Removed by Filter: 131464
Planning time : 0.409 ms