explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ShzT

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 10,254.535 ↑ 1.0 1 1

Finalize Aggregate (cost=143,649.98..143,649.99 rows=1 width=8) (actual time=10,254.534..10,254.535 rows=1 loops=1)

  • Filter: (count(1) > 0)
2. 64.756 10,307.147 ↓ 1.5 3 1

Gather (cost=143,649.76..143,649.97 rows=2 width=16) (actual time=10,253.172..10,307.147 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 93.882 10,242.391 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=142,649.76..142,649.77 rows=1 width=16) (actual time=10,242.391..10,242.391 rows=1 loops=3)

4. 57.572 10,148.509 ↑ 1.2 247,766 3 / 3

Parallel Append (cost=0.43..141,112.37 rows=307,479 width=0) (actual time=0.764..10,148.509 rows=247,766 loops=3)

5. 10,090.937 10,090.937 ↑ 1.2 247,766 3 / 3

Parallel Index Only Scan using _hyper_36_217_chunk_eta_prediction_position_ts_idx on _hyper_36_217_chunk eta_prediction (cost=0.43..139,574.97 rows=307,479 width=0) (actual time=0.763..10,090.937 rows=247,766 loops=3)

  • Index Cond: ((position_ts >= '2020-01-20 00:00:00'::timestamp without time zone) AND (position_ts <= '2020-01-22 00:00:00'::timestamp without time zone))
  • Heap Fetches: 743300
Planning time : 1.550 ms
Execution time : 10,307.215 ms