explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sk14 : Movement Select2

Settings
# exclusive inclusive rows x rows loops node
1. 60.856 721.885 ↓ 1.2 3,578 1

Gather Merge (cost=9,896.75..11,704.97 rows=2,946 width=181) (actual time=68.933..721.885 rows=3,578 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 648.156 661.029 ↑ 1.0 1,193 3

Merge Join (cost=8,896.72..10,364.91 rows=1,228 width=181) (actual time=3.612..220.343 rows=1,193 loops=3)

  • Merge Cond: (g2.read_date = g1.read_date)
3. 5.136 8.490 ↑ 1.2 1,514 3

Sort (cost=4,572.17..4,576.84 rows=1,866 width=47) (actual time=2.145..2.830 rows=1,514 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. 2.150 3.354 ↑ 1.2 1,514 3

Parallel Bitmap Heap Scan on gps_data g2 (cost=115.13..4,470.80 rows=1,866 width=47) (actual time=0.444..1.118 rows=1,514 loops=3)

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

Bitmap Index Scan on gps_station_idx (cost=0.00..114.01 rows=4,479 width=0) (actual time=1.204..1.204 rows=4,541 loops=1)

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

Sort (cost=4,324.55..4,334.07 rows=3,807 width=48) (actual time=3.242..4.383 rows=3,710 loops=1)

  • Sort Key: g1.read_date
  • Sort Method: quicksort Memory: 618kB
7. 1.316 1.866 ↑ 1.0 3,710 1

Bitmap Heap Scan on gps_data g1 (cost=97.92..4,098.14 rows=3,807 width=48) (actual time=0.568..1.866 rows=3,710 loops=1)

  • Recheck Cond: (station = '41338e24-fbfb-11e9-94ce-aec49259cebb'::uuid)
  • Heap Blocks: exact=56
8. 0.550 0.550 ↑ 1.0 3,710 1

Bitmap Index Scan on gps_station_idx (cost=0.00..96.97 rows=3,807 width=0) (actual time=0.550..0.550 rows=3,710 loops=1)

  • Index Cond: (station = '41338e24-fbfb-11e9-94ce-aec49259cebb'::uuid)
Planning time : 1.192 ms
Execution time : 723.581 ms