explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N1ofC

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

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

2. 93.530 3,320.740 ↓ 1.5 3 1

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 15.155 3,227.210 ↑ 1.0 1 3 / 3

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

4. 1,236.952 3,212.055 ↑ 1.8 75,006 3 / 3

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

  • Hash Cond: (a.rate_code = b.rate_code)
5. 1,974.569 1,974.569 ↑ 1.3 3,635,619 3 / 3

Parallel Seq Scan on rides a (cost=0.00..268,411.24 rows=4,544,524 width=4) (actual time=0.523..1,974.569 rows=3,635,619 loops=3)

6. 0.018 0.534 ↑ 6.0 1 3 / 3

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

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

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

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