explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7KLu

Settings
# exclusive inclusive rows x rows loops node
1. 59.968 801.189 ↑ 1.0 1 1

Aggregate (cost=129,655.01..129,655.03 rows=1 width=33) (actual time=801.189..801.189 rows=1 loops=1)

2. 134.486 741.221 ↑ 1.0 75,983 1

Hash Join (cost=11,586.91..128,320.78 rows=76,242 width=33) (actual time=125.217..741.221 rows=75,983 loops=1)

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

Bitmap Heap Scan on lineitem (cost=1,621.91..114,568.94 rows=76,242 width=20) (actual time=22.117..504.364 rows=75,983 loops=1)

  • Recheck Cond: ((l_shipdate >= '1995-09-01'::date) AND (l_shipdate < '1995-10-01 00:00:00'::timestamp without time zone))
  • Rows Removed by Index Recheck: 1586268
4. 20.484 20.484 ↑ 1.0 75,983 1

Bitmap Index Scan on idx_lineitem_shipdate (cost=0.00..1,602.85 rows=76,242 width=0) (actual time=20.484..20.484 rows=75,983 loops=1)

  • Index Cond: ((l_shipdate >= '1995-09-01'::date) AND (l_shipdate < '1995-10-01 00:00:00'::timestamp without time zone))
5. 56.539 102.371 ↑ 1.0 200,000 1

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

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

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