explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2A5S

Settings
# exclusive inclusive rows x rows loops node
1. 60.265 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. 114.341 123.615 ↑ 1.0 1,144 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. 2.721 5.589 ↑ 1.4 1,338 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. 1.740 2.868 ↑ 1.2 1,514 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. 1.128 1.128 ↓ 1.0 4,541 1

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. 2.047 3.685 ↑ 1.0 3,570 1

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. 1.340 1.638 ↑ 1.0 3,570 1

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.298 0.298 ↑ 1.0 3,570 1

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