explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DVXf

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

Finalize Aggregate (cost=288,187.37..288,187.38 rows=1 width=8) (actual time=3,366.968..3,366.968 rows=1 loops=1)

2. 54.895 3,384.558 ↓ 1.5 3 1

Gather (cost=288,187.16..288,187.37 rows=2 width=8) (actual time=3,366.356..3,384.558 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 15.115 3,329.663 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=287,187.16..287,187.17 rows=1 width=8) (actual time=3,329.663..3,329.663 rows=1 loops=3)

4. 1,260.312 3,314.548 ↑ 1.8 75,006 3 / 3

Hash Join (cost=25.95..286,846.30 rows=136,344 width=0) (actual time=0.862..3,314.548 rows=75,006 loops=3)

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

Parallel Seq Scan on rides a (cost=0.00..268,413.93 rows=4,544,793 width=4) (actual time=0.361..2,053.910 rows=3,635,619 loops=3)

6. 0.013 0.326 ↑ 6.0 1 3 / 3

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

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

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

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