explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sk14 : Movement Select2

Settings
# exclusive inclusive rows x rows loops node
1. 501.542 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. 216.052 220.343 ↑ 1.0 1,193 3 / 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. 1.712 2.830 ↑ 1.2 1,514 3 / 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. 0.717 1.118 ↑ 1.2 1,514 3 / 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. 0.401 0.401 ↓ 1.0 4,541 1 / 3

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. 0.839 1.461 ↑ 1.0 3,710 1 / 3

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. 0.439 0.622 ↑ 1.0 3,710 1 / 3

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.183 0.183 ↑ 1.0 3,710 1 / 3

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