explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 38fz

Settings
# exclusive inclusive rows x rows loops node
1. 60.373 172.939 ↓ 1.2 3,431 1

Gather Merge (cost=10,290.54..12,033.47 rows=2,895 width=88) (actual time=68.658..172.939 rows=3,431 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 103.283 112.566 ↑ 1.1 1,144 3

Merge Join (cost=9,290.52..10,699.29 rows=1,206 width=88) (actual time=3.071..37.522 rows=1,144 loops=3)

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

Sort (cost=4,827.38..4,832.04 rows=1,866 width=47) (actual time=1.705..1.849 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.958 2.847 ↑ 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.345..0.949 rows=1,514 loops=3)

  • Recheck Cond: (station = '12bd4728-01b5-11ea-b1df-aec49259cebb'::uuid)
  • Heap Blocks: exact=95
5. 0.889 0.889 ↓ 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=0.889..0.889 rows=4,541 loops=1)

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

Sort (cost=4,463.14..4,472.43 rows=3,715 width=80) (actual time=3.446..3.736 rows=3,570 loops=1)

  • Sort Key: g1.read_date
  • Sort Method: quicksort Memory: 599kB
7. 1.601 2.010 ↑ 1.0 3,570 1

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

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

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