explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4PL1

Settings
# exclusive inclusive rows x rows loops node
1. 122.295 731.575 ↑ 1.0 1 1

Aggregate (cost=118,908.18..118,908.19 rows=1 width=8) (actual time=731.575..731.575 rows=1 loops=1)

2. 609.280 609.280 ↑ 1.0 1,844,877 1

Seq Scan on otex_orders t4 (cost=0.00..114,246.96 rows=1,864,488 width=4) (actual time=1.988..609.280 rows=1,844,877 loops=1)

  • Filter: (receive_date IS NOT NULL)
  • Rows Removed by Filter: 696,386
Planning time : 0.198 ms
Execution time : 731.616 ms