explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OG27

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

Aggregate (cost=338,875.18..338,875.19 rows=1 width=32) (actual time=871.144..871.144 rows=1 loops=1)

2. 3.672 872.477 ↓ 1.5 3 1

Gather (cost=338,874.96..338,875.17 rows=2 width=32) (actual time=871.054..872.477 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 27.301 868.805 ↑ 1.0 1 3 / 3

Aggregate (cost=337,874.96..337,874.97 rows=1 width=32) (actual time=868.805..868.805 rows=1 loops=3)

4. 841.504 841.504 ↑ 1.2 76,053 3 / 3

Seq Scan on lineitem lineitem (cost=0..337,401.21 rows=94,748 width=12) (actual time=0.016..841.504 rows=76,053 loops=3)

  • Filter: ((l_shipdate >= '1996-01-01'::date) AND (l_shipdate < '1997-01-01'::date) AND (l_discount >= 0.05) AND (l_discount <= 0.07) AND (l_quantity < '24'::numeric))
Planning time : 0.083 ms
Execution time : 872.518 ms