explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uo1K : tpch6

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=167,544.93..167,544.94 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Aggregate (cost=167,544.93..167,544.94 rows=1 width=32) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Gather Motion 16:1 (slice1; segments: 16) (cost=167,544.74..167,544.92 rows=1 width=32) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Aggregate (cost=167,544.74..167,544.75 rows=1 width=32) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on lineitem (cost=0.00..166,643.40 rows=22,534 width=16) (actual rows= loops=)

  • Filter: l_shipdate >= '1997-01-01'::date AND l_shipdate < '1998-01-01 00:00:00'::timestamp without time zone AND l_discount >= 0.05 AND l_discount <= 0.07 AND l_q