explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WbGL

Settings
# exclusive inclusive rows x rows loops node
1. 2,117.736 44,003.586 ↑ 1.0 21,319,358 1

Subquery Scan on t1 (cost=4,346,965.03..4,616,025.83 rows=21,524,864 width=8) (actual time=35,297.504..44,003.586 rows=21,319,358 loops=1)

2. 15,458.344 41,885.850 ↑ 1.0 21,319,358 1

Sort (cost=4,346,965.03..4,400,777.19 rows=21,524,864 width=16) (actual time=35,297.502..41,885.850 rows=21,319,358 loops=1)

  • Sort Key: orders.order_date DESC
  • Sort Method: external merge Disk: 541704kB
3. 26,427.506 26,427.506 ↑ 1.0 21,319,358 1

Seq Scan on orders (cost=0.00..1,409,984.32 rows=21,524,864 width=16) (actual time=0.018..26,427.506 rows=21,319,358 loops=1)

  • Filter: ((order_date >= to_date('20180101'::text, 'YYYYMMDD'::text)) AND (order_date <= to_date('20190101'::text, 'YYYYMMDD'::text)))
  • Rows Removed by Filter: 12874928
Planning time : 0.191 ms
Execution time : 44,863.897 ms