explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Psgf

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

Aggregate (cost=497,635.7..497,635.72 rows=1 width=32) (actual time=472.955..472.955 rows=1 loops=1)

2. 3.804 474.160 ↓ 1.5 3 1

Gather (cost=497,635.47..497,635.68 rows=2 width=64) (actual time=472.793..474.16 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 32.392 470.356 ↑ 1.0 1 3 / 3

Aggregate (cost=496,635.47..496,635.48 rows=1 width=64) (actual time=470.356..470.356 rows=1 loops=3)

4. 18.994 437.964 ↑ 1.3 50,163 3 / 3

Nested Loop (cost=0.43..495,493.97 rows=65,228 width=33) (actual time=0.038..437.964 rows=50,163 loops=3)

5. 18.970 18.970 ↑ 1.3 133,333 3 / 3

Seq Scan on part part (cost=0..9,859.67 rows=166,667 width=25) (actual time=0.006..18.97 rows=133,333 loops=3)

6. 400.000 400.000 ↓ 0.0 0 400,000 / 3

Index Scan using lineitem_pkey_sdate on lineitem lineitem (cost=0.43..2.9 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=400,000)

  • Index Cond: ((l_partkey = part.p_partkey) AND (l_shipdate >= '1993-11-01'::date) AND (l_shipdate < '1993-12-01'::date))
Planning time : 0.142 ms
Execution time : 474.224 ms