explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dqKH

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3,192.550 ↑ 1.0 1 1

Finalize Aggregate (cost=334,067.78..334,067.79 rows=1 width=8) (actual time=3,192.550..3,192.550 rows=1 loops=1)

2. 400.662 3,221.785 ↓ 1.5 3 1

Gather (cost=334,067.57..334,067.78 rows=2 width=8) (actual time=3,191.932..3,221.785 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 13.626 2,821.123 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=333,067.57..333,067.58 rows=1 width=8) (actual time=2,821.122..2,821.123 rows=1 loops=3)

4. 934.509 2,807.497 ↑ 10.1 75,006 3 / 3

Hash Join (cost=1.09..331,174.01 rows=757,421 width=0) (actual time=1.213..2,807.497 rows=75,006 loops=3)

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

Parallel Seq Scan on rides (cost=0.00..310,817.24 rows=4,544,524 width=4) (actual time=0.496..1,872.496 rows=3,635,619 loops=3)

6. 0.015 0.492 ↑ 1.0 1 3 / 3

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

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

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

  • Filter: (description = 'JFK'::text)
  • Rows Removed by Filter: 5
Planning time : 0.196 ms
Execution time : 3,221.868 ms