explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OHoW : q1

Settings
# exclusive inclusive rows x rows loops node
1. 0.050 16,315.452 ↑ 1.5 4 1

Sort (cost=423,596.47..423,596.49 rows=6 width=25) (actual time=16,315.450..16,315.452 rows=4 loops=1)

  • Sort Key: l_returnflag, l_linestatus
  • Sort Method: quicksort Memory: 25kB
  • Planning time: 11.690 ms
  • Execution time: 16315.915 ms
2. 13,094.382 16,315.402 ↑ 1.5 4 1

HashAggregate (cost=423,596.23..423,596.39 rows=6 width=25) (actual time=16,315.396..16,315.402 rows=4 loops=1)

  • Group Key: l_returnflag, l_linestatus
3. 3,221.020 3,221.020 ↑ 1.0 5,900,882 1

Seq Scan on lineitem (cost=0.00..187,518.19 rows=5,901,951 width=25) (actual time=0.491..3,221.020 rows=5,900,882 loops=1)

  • Filter: (l_shipdate <= '1998-08-25 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 100333