explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rxvw : yugabyte tpchq1

Settings
# exclusive inclusive rows x rows loops node
1. 0.058 73,642.536 ↑ 50.0 4 1

QUERY PLAN l_linestatus ------------------------------------------------------------------------------------------------------------------------------------- l_returnflag, Sort (cost=153.64..154.14 rows=200 width=80) (actual time=73,642.535..73,642.536 rows=4 loops=1)

  • Sort Key: l_returnflag, l_linestatus
  • Sort Method: quicksort Memory: 25kB
2. 2,284.103 73,642.478 ↑ 50.0 4 1

HashAggregate (cost=142.50..146.00 rows=200 width=80) (actual time=73,642.476..73,642.478 rows=4 loops=1)

  • Group Key: l_returnflag, l_linestatus
3. 71,358.375 71,358.375 ↓ 5,915.4 5,915,401 1

Foreign Scan on lineitem_2 (cost=0.00..102.50 rows=1,000 width=48) (actual time=41.235..71,358.375 rows=5,915,401 loops=1)

  • Filter: (l_shipdate <= '1998-09-02 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 84,599
Planning time : 37.735 ms
Execution time : 73,646.102 ms