explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KcbK

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 354.078 ↓ 0.0 1,231,385 3

h=82) (cost=0..0 rows=0 width=0) (actual time=0.032..118.026 rows=1,231,385 loops=3)

  • -> Hash (cost=129366.43..129366.43 rows=45623 width=12) (actual time=1616.8
  • Buckets: 65536 Batches: 1 Memory Usage: 513kB
  • -> HashAggregate (cost=128339.91..128910.20 rows=45623 width=12) (act
  • Group Key: date_trunc('month'::text, trip_fare_25_1.pickup_dateti
  • -> Seq Scan on trip_fare_25 trip_fare_25_1 (cost=0.00..109869.36 rows=3694109 width=12) (actual ti
  • JIT:
  • Functions: 96
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 9.248 ms, Inlining 0.000 ms, Optimization 2.665 ms, Emission 52.497 ms, Total 64.410 ms
2. 2,355.180 2,355.180 ↑ 1.2 1,231,385 3

Parallel Hash (cost=86,434.31..86,434.31 rows=1,539,231 width=86) (actual time=785.060..785.060 rows=1,231,385 loops=3)

  • Buckets: 32768 Batches: 128 Memory Usage: 3744kB
  • -> Parallel Seq Scan on trip_data_25 (cost=0.00..86434.31 rows=1539231 width=86) (actual time=18.710..292.385
Planning time : 1.427 ms
Execution time : 3,192.817 ms