explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U6Tn

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 6,954.088 ↑ 1.0 1 1

Finalize Aggregate (cost=295,922.27..295,922.28 rows=1 width=8) (actual time=6,954.087..6,954.088 rows=1 loops=1)

2. 127.051 6,958.392 ↓ 1.5 3 1

Gather (cost=295,922.06..295,922.27 rows=2 width=8) (actual time=6,953.201..6,958.392 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 2.286 6,831.341 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=294,922.06..294,922.07 rows=1 width=8) (actual time=6,831.341..6,831.341 rows=1 loops=3)

4. 757.557 6,829.055 ↑ 135.1 5,607 3 / 3

Hash Join (cost=1.09..293,028.50 rows=757,421 width=0) (actual time=44.536..6,829.055 rows=5,607 loops=3)

  • Hash Cond: (rides.rate_code = rates.rate_code)
5. 6,071.410 6,071.410 ↑ 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=7.349..6,071.410 rows=3,635,619 loops=3)

6. 0.004 0.088 ↑ 1.0 1 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.084 0.084 ↑ 1.0 1 3 / 3

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

  • Filter: (description = 'Newark'::text)
  • Rows Removed by Filter: 5
Planning time : 0.082 ms
Execution time : 6,958.438 ms