explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7aw0

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 762.559 ↑ 1.0 1 1

Finalize Aggregate (cost=288,183.57..288,183.58 rows=1 width=8) (actual time=762.559..762.559 rows=1 loops=1)

2. 3.642 764.316 ↓ 1.5 3 1

Gather (cost=288,183.36..288,183.57 rows=2 width=8) (actual time=762.443..764.316 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 4.720 760.674 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=287,183.36..287,183.37 rows=1 width=8) (actual time=760.674..760.674 rows=1 loops=3)

4. 350.836 755.954 ↑ 1.8 75,006 3 / 3

Hash Join (cost=25.95..286,842.52 rows=136,336 width=0) (actual time=0.193..755.954 rows=75,006 loops=3)

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

6. 0.004 0.011 ↑ 6.0 1 3 / 3

Hash (cost=25.88..25.88 rows=6 width=4) (actual time=0.011..0.011 rows=1 loops=3)

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

Seq Scan on rates (cost=0.00..25.88 rows=6 width=4) (actual time=0.007..0.007 rows=1 loops=3)

  • Filter: (description = 'JFK'::text)
  • Rows Removed by Filter: 5
Planning time : 0.237 ms
Execution time : 764.396 ms