explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kpncZ : Optimization for: Distances Select; plan #8Nf9

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 109.616 ↓ 2.0 3,431 1

Gather Merge (cost=12,088.26..12,284.11 rows=1,703 width=88) (actual time=106.115..109.616 rows=3,431 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 2.450 138.356 ↓ 1.0 1,716 2

Sort (cost=11,088.25..11,092.51 rows=1,703 width=88) (actual time=69.056..69.178 rows=1,716 loops=2)

  • Sort Key: g1.read_date
  • Sort Method: quicksort Memory: 463kB
  • Worker 0: Sort Method: quicksort Memory: 141kB
3. 128.752 135.906 ↓ 1.0 1,716 2

Parallel Hash Join (cost=4,852.54..10,996.85 rows=1,703 width=88) (actual time=4.661..67.953 rows=1,716 loops=2)

  • Hash Cond: (g1.read_date = g2.read_date)
4. 1.914 2.198 ↑ 1.2 1,785 2

Parallel Bitmap Heap Scan on gps_data g1 (cost=103.21..4,223.74 rows=2,185 width=48) (actual time=0.185..1.099 rows=1,785 loops=2)

  • Recheck Cond: (station = '12bd1d70-01b5-11ea-b1df-aec49259cebb'::uuid)
  • Heap Blocks: exact=139
5. 0.284 0.284 ↑ 1.0 3,570 1

Bitmap Index Scan on station_gps_date_idx (cost=0.00..102.28 rows=3,715 width=0) (actual time=0.284..0.284 rows=3,570 loops=1)

  • Index Cond: (station = '12bd1d70-01b5-11ea-b1df-aec49259cebb'::uuid)
6. 1.927 4.956 ↓ 1.2 2,270 2

Parallel Hash (cost=4,726.00..4,726.00 rows=1,866 width=47) (actual time=2.478..2.478 rows=2,270 loops=2)

  • Buckets: 8192 Batches: 1 Memory Usage: 480kB
7. 2.206 3.029 ↓ 2.4 4,541 1

Parallel Bitmap Heap Scan on gps_data g2 (cost=125.13..4,726.00 rows=1,866 width=47) (actual time=0.872..3.029 rows=4,541 loops=1)

  • Recheck Cond: (station = '12bd4728-01b5-11ea-b1df-aec49259cebb'::uuid)
  • Heap Blocks: exact=180
8. 0.823 0.823 ↓ 2.0 9,074 1

Bitmap Index Scan on station_gps_date_idx (cost=0.00..124.01 rows=4,479 width=0) (actual time=0.823..0.823 rows=9,074 loops=1)

  • Index Cond: (station = '12bd4728-01b5-11ea-b1df-aec49259cebb'::uuid)
Planning time : 0.607 ms
Execution time : 109.941 ms