explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eILZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,538.179 ↑ 1.0 1 1

Finalize Aggregate (cost=62,725.70..62,725.71 rows=1 width=8) (actual time=2,538.178..2,538.179 rows=1 loops=1)

2. 156.622 2,540.141 ↓ 1.5 3 1

Gather (cost=62,725.48..62,725.69 rows=2 width=8) (actual time=2,530.451..2,540.141 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 8.772 2,383.519 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=61,725.48..61,725.49 rows=1 width=8) (actual time=2,383.519..2,383.519 rows=1 loops=3)

4. 377.185 2,374.747 ↑ 50.9 16,126 3 / 3

Hash Semi Join (cost=25.95..59,674.77 rows=820,287 width=0) (actual time=36.185..2,374.747 rows=16,126 loops=3)

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

Parallel Seq Scan on rides_week_one (cost=0.00..48,369.87 rows=820,287 width=4) (actual time=14.283..1,997.517 rows=656,230 loops=3)

6. 0.006 0.045 ↑ 6.0 1 3 / 3

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

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

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

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