explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xCsb : Optimization for: plan #v1iq

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.249 5.125 ↓ 1.0 1,661 1

Hash Left Join (cost=475.76..1,080.16 rows=1,649 width=532) (actual time=1.871..5.125 rows=1,661 loops=1)

  • Hash Cond: (e.direction_id = d.id)
2. 1.569 4.862 ↓ 1.0 1,661 1

Hash Right Join (cost=462.61..1,062.55 rows=1,649 width=16) (actual time=1.852..4.862 rows=1,661 loops=1)

  • Hash Cond: (da.id = e.id)
3. 1.451 1.451 ↑ 1.0 18,133 1

Seq Scan on data_data da (cost=0.00..552.33 rows=18,133 width=12) (actual time=0.005..1.451 rows=18,133 loops=1)

4. 0.178 1.842 ↓ 1.0 1,661 1

Hash (cost=442.00..442.00 rows=1,649 width=20) (actual time=1.842..1.842 rows=1,661 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 107kB
5. 1.664 1.664 ↓ 1.0 1,661 1

Seq Scan on data_datadate e (cost=0.00..442.00 rows=1,649 width=20) (actual time=0.010..1.664 rows=1,661 loops=1)

  • Filter: ((value >= '2020-06-25 07:00:00'::timestamp without time zone) AND (value <= '2020-06-25 10:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 16,472
6. 0.007 0.014 ↑ 3.6 39 1

Hash (cost=11.40..11.40 rows=140 width=524) (actual time=0.014..0.014 rows=39 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
7. 0.007 0.007 ↑ 3.6 39 1

Seq Scan on data_direction d (cost=0.00..11.40 rows=140 width=524) (actual time=0.004..0.007 rows=39 loops=1)

Planning time : 0.248 ms
Execution time : 5.194 ms