explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l2eD : Optimization for: original get; plan #Bvxc

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 10,322.520 35,995.041 ↓ 1.1 320,265 1

Sort (cost=1,139,080.72..1,139,800.19 rows=287,788 width=527) (actual time=34,902.854..35,995.041 rows=320,265 loops=1)

  • Sort Key: (edf_date(c.min_start_time)), (edf_time(c.min_start_time)), c.call_id, l.leg_number
  • Sort Method: external merge Disk: 155576kB
2. 21,931.045 25,672.521 ↓ 1.1 320,265 1

Hash Join (cost=40,729.69..909,370.05 rows=287,788 width=527) (actual time=548.208..25,672.521 rows=320,265 loops=1)

  • Hash Cond: (l.ths_call_id = c.ths_call_id)
3. 3,279.964 3,279.964 ↑ 1.0 3,439,961 1

Seq Scan on ths_call_leg l (cost=0.00..188,824.15 rows=3,440,115 width=318) (actual time=0.075..3,279.964 rows=3,439,961 loops=1)

4. 62.391 461.512 ↑ 1.1 54,868 1

Hash (cost=38,233.12..38,233.12 rows=58,365 width=217) (actual time=461.512..461.512 rows=54,868 loops=1)

  • Buckets: 1024 Batches: 16 Memory Usage: 858kB
5. 399.121 399.121 ↑ 1.1 54,868 1

Seq Scan on ths_call c (cost=0.00..38,233.12 rows=58,365 width=217) (actual time=3.155..399.121 rows=54,868 loops=1)

  • Filter: ((min_start_time >= '2020-04-01 00:00:00+00'::timestamp with time zone) AND (min_start_time <= '2020-04-30 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 642807