explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BaKOb

Settings
# exclusive inclusive rows x rows loops node
1. 64.867 1,751.343 ↑ 1.0 1 1

Aggregate (cost=226,591.06..226,591.08 rows=1 width=33) (actual time=1,751.343..1,751.343 rows=1 loops=1)

2. 150.146 1,686.476 ↑ 1.0 75,983 1

Hash Join (cost=9,965.00..225,256.83 rows=76,242 width=33) (actual time=123.934..1,686.476 rows=75,983 loops=1)

  • Hash Cond: (lineitem.l_partkey = part.p_partkey)
3. 1,419.930 1,419.930 ↑ 1.0 75,983 1

Seq Scan on lineitem (cost=0.00..211,504.98 rows=76,242 width=20) (actual time=0.011..1,419.930 rows=75,983 loops=1)

  • Filter: ((l_shipdate >= '1995-09-01'::date) AND (l_shipdate < '1995-10-01 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 5925232
4. 63.132 116.400 ↑ 1.0 200,000 1

Hash (cost=6,097.00..6,097.00 rows=200,000 width=25) (actual time=116.400..116.400 rows=200,000 loops=1)

  • Buckets: 2048 Batches: 16 Memory Usage: 741kB
5. 53.268 53.268 ↑ 1.0 200,000 1

Seq Scan on part (cost=0.00..6,097.00 rows=200,000 width=25) (actual time=0.002..53.268 rows=200,000 loops=1)