explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T6eS

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.269 ↑ 1.0 1 1

Limit (cost=1,000.00..524,386.34 rows=1 width=394) (actual time=0.268..0.269 rows=1 loops=1)

2. 672.477 2,010.202 ↑ 1.0 1 1

Gather (cost=1,000.00..524,386.34 rows=1 width=394) (actual time=0.268..2,010.202 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,337.725 1,337.725 ↓ 0.0 0 3 / 3

Parallel Seq Scan on spree_orders (cost=0.00..523,386.24 rows=1 width=394) (actual time=1,337.725..1,337.725 rows=0 loops=3)

  • Filter: (split_parent_id = 9,737,593)
  • Rows Removed by Filter: 5,031,819
Planning time : 0.097 ms
Execution time : 2,010.236 ms