explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Nf9 : Distances Select

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 64.586 189.410 ↓ 1.2 3,431 1

Gather Merge (cost=10,290.54..12,093.77 rows=2,895 width=88) (actual time=73.548..189.410 rows=3,431 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 114.914 124.824 ↑ 1.1 1,144 3

Merge Join (cost=9,290.52..10,759.59 rows=1,206 width=88) (actual time=3.275..41.608 rows=1,144 loops=3)

  • Merge Cond: (g2.read_date = g1.read_date)
3. 2.775 5.826 ↑ 1.4 1,338 3

Sort (cost=4,827.38..4,832.04 rows=1,866 width=47) (actual time=1.793..1.942 rows=1,338 loops=3)

  • Sort Key: g2.read_date
  • Sort Method: quicksort Memory: 828kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
4. 1.988 3.051 ↑ 1.2 1,514 3

Parallel Bitmap Heap Scan on gps_data g2 (cost=125.13..4,726.00 rows=1,866 width=47) (actual time=0.396..1.017 rows=1,514 loops=3)

  • Recheck Cond: (station = '12bd4728-01b5-11ea-b1df-aec49259cebb'::uuid)
  • Heap Blocks: exact=95
5. 1.063 1.063 ↓ 1.0 4,541 1

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

  • Index Cond: (station = '12bd4728-01b5-11ea-b1df-aec49259cebb'::uuid)
6. 1.903 4.084 ↑ 1.0 3,570 1

Sort (cost=4,463.14..4,472.43 rows=3,715 width=48) (actual time=3.768..4.084 rows=3,570 loops=1)

  • Sort Key: g1.read_date
  • Sort Method: quicksort Memory: 598kB
7. 1.752 2.181 ↑ 1.0 3,570 1

Bitmap Heap Scan on gps_data g1 (cost=103.21..4,242.86 rows=3,715 width=48) (actual time=0.454..2.181 rows=3,570 loops=1)

  • Recheck Cond: (station = '12bd1d70-01b5-11ea-b1df-aec49259cebb'::uuid)
  • Heap Blocks: exact=156
8. 0.429 0.429 ↑ 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.429..0.429 rows=3,570 loops=1)

  • Index Cond: (station = '12bd1d70-01b5-11ea-b1df-aec49259cebb'::uuid)
Planning time : 0.840 ms
Execution time : 189.789 ms