explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L1RD

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

Finalize Aggregate (cost=53,386.55..53,386.56 rows=1 width=8) (actual time=777.910..777.910 rows=1 loops=1)

2. 9.846 778.375 ↓ 1.5 3 1

Gather (cost=53,386.33..53,386.54 rows=2 width=8) (actual time=777.896..778.375 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 10.951 768.529 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=52,386.33..52,386.34 rows=1 width=8) (actual time=768.529..768.529 rows=1 loops=3)

4. 346.719 757.578 ↑ 8.5 16,126 3 / 3

Hash Semi Join (cost=1.09..52,044.56 rows=136,708 width=0) (actual time=0.450..757.578 rows=16,126 loops=3)

  • Hash Cond: (rides_week_one.rate_code = rates.rate_code)
5. 410.823 410.823 ↑ 1.2 656,230 3 / 3

Parallel Seq Scan on rides_week_one (cost=0.00..48,369.45 rows=820,245 width=4) (actual time=0.058..410.823 rows=656,230 loops=3)

6. 0.006 0.036 ↑ 1.0 1 3 / 3

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

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

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

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