explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 31XR

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 24,494.701 ↑ 1.0 1 1

Sort (cost=314,837.12..314,837.12 rows=1 width=12) (actual time=24,494.700..24,494.701 rows=1 loops=1)

  • Sort Key: date_change DESC
  • Sort Method: quicksort Memory: 25kB
2. 15.332 24,499.884 ↑ 1.0 1 1

Gather (cost=10.00..314,837.11 rows=1 width=12) (actual time=24,311.164..24,499.884 rows=1 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
3. 24,484.552 24,484.552 ↓ 0.0 0 8 / 8

Parallel Seq Scan on tiki_history_tracking_carrier (cost=0.00..314,827.10 rows=1 width=12) (actual time=24,461.635..24,484.552 rows=0 loops=8)

  • Filter: (active AND (sale_id = 96,174,838))
  • Rows Removed by Filter: 11,498,205
Planning time : 2.017 ms
Execution time : 24,500.024 ms