explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wic4

Settings
# exclusive inclusive rows x rows loops node
1. 83.915 1,011.498 ↓ 139.2 16,148 1

Gather (cost=116,702.30..230,333.92 rows=116 width=12) (actual time=835.307..1,011.498 rows=16,148 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Functions: 42
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 7.062 ms, Inlining 0.000 ms, Optimization 1.553 ms, Emission 25.543 ms, Total 34.158 ms
2. 132.248 927.583 ↓ 112.1 5,383 3

Parallel Hash Join (cost=115,702.30..229,322.32 rows=48 width=12) (actual time=806.812..927.583 rows=5,383 loops=3)

  • Hash Cond: ((trip_data_25.pickup_datetime = trip_fare_25.pickup_datetime) AND ((trip_data_25.medallion)::text = (trip_fare_25.medallion)::text))
3. 185.623 185.623 ↑ 1.4 5,380 3

Parallel Seq Scan on trip_data_25 (cost=0.00..90,282.54 rows=7,514 width=41) (actual time=0.077..185.623 rows=5,380 loops=3)

  • Filter: (trip_time_in_secs <= 50)
  • Rows Removed by Filter: 1226004
4. 336.174 609.712 ↑ 1.2 1,231,385 3

Parallel Hash (cost=79,085.12..79,085.12 rows=1,539,212 width=45) (actual time=609.712..609.712 rows=1,231,385 loops=3)

  • Buckets: 65536 Batches: 128 Memory Usage: 2848kB
5. 273.538 273.538 ↑ 1.2 1,231,385 3

Parallel Seq Scan on trip_fare_25 (cost=0.00..79,085.12 rows=1,539,212 width=45) (actual time=9.252..273.538 rows=1,231,385 loops=3)

Planning time : 0.687 ms
Execution time : 1,017.410 ms