explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NN6V : movement select

Settings
# exclusive inclusive rows x rows loops node
1. 57.633 722.646 ↓ 1.2 3,578 1

Gather Merge (cost=9,902.78..11,793.06 rows=3,082 width=181) (actual time=64.598..722.646 rows=3,578 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 652.898 665.013 ↑ 1.1 1,193 3

Merge Join (cost=8,902.75..10,437.30 rows=1,284 width=181) (actual time=3.179..221.671 rows=1,193 loops=3)

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

Sort (cost=4,515.13..4,519.77 rows=1,857 width=47) (actual time=1.910..2.564 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. 1.621 3.306 ↑ 1.2 1,514 3

Parallel Bitmap Heap Scan on gps_data g2 (cost=70.95..4,414.30 rows=1,857 width=47) (actual time=0.606..1.102 rows=1,514 loops=3)

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

Bitmap Index Scan on gps_station_idx (cost=0.00..69.84 rows=4,456 width=0) (actual time=1.685..1.685 rows=4,541 loops=1)

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

Sort (cost=4,387.63..4,397.51 rows=3,952 width=48) (actual time=2.971..4.423 rows=3,710 loops=1)

  • Sort Key: g1.read_date
  • Sort Method: quicksort Memory: 618kB
7. 1.186 1.754 ↑ 1.1 3,710 1

Bitmap Heap Scan on gps_data g1 (cost=63.05..4,151.53 rows=3,952 width=48) (actual time=0.585..1.754 rows=3,710 loops=1)

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

Bitmap Index Scan on gps_station_idx (cost=0.00..62.06 rows=3,952 width=0) (actual time=0.567..0.568 rows=3,710 loops=1)

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