explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uyGl

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 11,561.406 ↑ 1.0 1 1

Finalize Aggregate (cost=343,307.29..343,307.30 rows=1 width=8) (actual time=11,561.405..11,561.406 rows=1 loops=1)

2. 12.873 11,562.440 ↓ 1.5 3 1

Gather (cost=343,307.08..343,307.29 rows=2 width=8) (actual time=11,556.530..11,562.440 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 58.896 11,549.567 ↑ 1.0 1 3

Partial Aggregate (cost=342,307.08..342,307.09 rows=1 width=8) (actual time=11,549.567..11,549.567 rows=1 loops=3)

4. 2,419.278 11,490.671 ↑ 60.6 75,006 3

Hash Semi Join (cost=25.95..330,943.73 rows=4,545,338 width=0) (actual time=4.422..11,490.671 rows=75,006 loops=3)

  • Hash Cond: (rides.rate_code = rates.rate_code)
5. 9,071.346 9,071.346 ↑ 1.3 3,635,619 3

Parallel Seq Scan on rides (cost=0.00..268,419.38 rows=4,545,338 width=4) (actual time=0.256..9,071.346 rows=3,635,619 loops=3)

6. 0.008 0.047 ↑ 6.0 1 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.039 0.039 ↑ 6.0 1 3

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

  • Filter: (description = 'JFK'::text)
  • Rows Removed by Filter: 5