explain-analyze.info | L3

Query Plan as raw text

Summary

Time		Node
Node (ms)	Percent	Node
110393.346	100.00%	¶	`Sort (cost=697197.5..697197.54 rows=6 width=51) (actual time=110393.344..110393.346 rows=4 loops=1) Sort Key: l_returnflag, l_linestatus`
110393.187	100.00%	¶	`-> HashAggregate (cost=697196.58..697197.27 rows=6 width=51) (actual time=110393.167..110393.187 rows=4 loops=1)`
10391.639	9.41%	¶	`-> Seq Scan on lineitem (cost=0.0..258642.03 rows=5847394 width=51) (actual time=0.025..10391.639 rows=5914748 loops=1) Filter: (l_shipdate <= '1998-09-01 23:59:57'::timestamp without time zone)`

Run-time

1 minute 50.393709 seconds (110393.709 ms)

Highlighted rows indicate a disparity between the number of rows estimated and actually returned. You may want to run ANALYZE to update the server's statistics.
For more information on using EXPLAIN and interpreting its output, see the Postgres documentation, in particular the EXPLAIN and ANALYZE references pages, and Using Explain.