explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tnSo

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 10,961.488 ↑ 1.0 1 1

Finalize Aggregate (cost=295,922.27..295,922.28 rows=1 width=8) (actual time=10,961.487..10,961.488 rows=1 loops=1)

2. 15.827 10,965.148 ↓ 1.5 3 1

Gather (cost=295,922.06..295,922.27 rows=2 width=8) (actual time=10,956.015..10,965.148 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 43.851 10,949.321 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=294,922.06..294,922.07 rows=1 width=8) (actual time=10,949.320..10,949.321 rows=1 loops=3)

4. 2,053.105 10,905.470 ↑ 10.1 75,006 3 / 3

Hash Join (cost=1.09..293,028.50 rows=757,421 width=0) (actual time=36.577..10,905.470 rows=75,006 loops=3)

  • Hash Cond: (rides.rate_code = rates.rate_code)
5. 8,851.159 8,851.159 ↑ 1.3 3,635,619 3 / 3

Parallel Seq Scan on rides (cost=0.00..268,411.24 rows=4,544,524 width=4) (actual time=2.590..8,851.159 rows=3,635,619 loops=3)

6. 1.166 1.206 ↑ 1.0 1 3 / 3

Hash (cost=1.07..1.07 rows=1 width=4) (actual time=1.206..1.206 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.040 0.040 ↑ 1.0 1 3 / 3

Seq Scan on rates (cost=0.00..1.07 rows=1 width=4) (actual time=0.037..0.040 rows=1 loops=3)

  • Filter: (description = 'JFK'::text)
  • Rows Removed by Filter: 5
Planning time : 0.166 ms
Execution time : 10,966.045 ms