explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3XqD : Location select with good data

Settings
# exclusive inclusive rows x rows loops node
1. 61.384 184.141 ↓ 1.2 3,431 1

Gather Merge (cost=9,815.29..11,576.61 rows=2,871 width=221) (actual time=68.837..184.141 rows=3,431 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 114.377 122.757 ↑ 1.0 1,144 3

Merge Join (cost=8,815.27..10,245.20 rows=1,196 width=221) (actual time=2.777..40.919 rows=1,144 loops=3)

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

Sort (cost=4,599.46..4,604.16 rows=1,879 width=47) (actual time=1.622..1.771 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.738 2.754 ↑ 1.2 1,514 3

Parallel Bitmap Heap Scan on gps_data g2 (cost=125.37..4,497.28 rows=1,879 width=47) (actual time=0.388..0.918 rows=1,514 loops=3)

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

Bitmap Index Scan on station_gps_date_idx (cost=0.00..124.24 rows=4,510 width=0) (actual time=1.016..1.016 rows=4,541 loops=1)

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

Sort (cost=4,215.81..4,224.92 rows=3,646 width=48) (actual time=2.730..3.067 rows=3,570 loops=1)

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

Bitmap Heap Scan on gps_data g1 (cost=100.68..4,000.11 rows=3,646 width=48) (actual time=0.318..1.604 rows=3,570 loops=1)

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

Bitmap Index Scan on station_gps_date_idx (cost=0.00..99.77 rows=3,646 width=0) (actual time=0.298..0.298 rows=3,570 loops=1)

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