explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2A5S

Settings
# exclusive inclusive rows x rows loops node
1. 142.675 183.880 ↓ 1.2 3,431 1

Gather Merge (cost=9,813.84..11,600.62 rows=2,869 width=88) (actual time=68.700..183.880 rows=3,431 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 38.114 41.205 ↑ 1.0 1,144 3 / 3

Merge Join (cost=8,813.81..10,269.44 rows=1,195 width=88) (actual time=3.083..41.205 rows=1,144 loops=3)

  • Merge Cond: (g2.read_date = g1.read_date)
3. 0.907 1.863 ↑ 1.4 1,338 3 / 3

Sort (cost=4,603.65..4,608.36 rows=1,882 width=47) (actual time=1.703..1.863 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. 0.580 0.956 ↑ 1.2 1,514 3 / 3

Parallel Bitmap Heap Scan on gps_data g2 (cost=125.43..4,501.29 rows=1,882 width=47) (actual time=0.422..0.956 rows=1,514 loops=3)

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

Bitmap Index Scan on station_gps_date_idx (cost=0.00..124.30 rows=4,517 width=0) (actual time=1.128..1.128 rows=4,541 loops=1)

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

Sort (cost=4,210.16..4,219.26 rows=3,638 width=48) (actual time=3.349..3.685 rows=3,570 loops=1)

  • Sort Key: g1.read_date
  • Sort Method: quicksort Memory: 598kB
7. 0.447 0.546 ↑ 1.0 3,570 1 / 3

Bitmap Heap Scan on gps_data g1 (cost=100.61..3,994.99 rows=3,638 width=48) (actual time=0.312..1.638 rows=3,570 loops=1)

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

Bitmap Index Scan on station_gps_date_idx (cost=0.00..99.70 rows=3,638 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.956 ms
Execution time : 184.240 ms