explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BePI

Settings
# exclusive inclusive rows x rows loops node
1. 2.183 2,875.882 ↑ 1,237.4 296 1

Merge Full Join (cost=230,461.95..236,191.04 rows=366,259 width=216) (actual time=2,870.998..2,875.882 rows=296 loops=1)

  • Merge Cond: ((time_bucket('00:05:00'::interval, o.date)) = (time_bucket('00:05:00'::interval, i.date)))
2. 1.351 1,451.040 ↑ 28.9 294 1

Sort (cost=110,628.29..110,649.51 rows=8,491 width=103) (actual time=1,450.345..1,451.040 rows=294 loops=1)

  • Sort Key: (time_bucket('00:05:00'::interval, o.date))
  • Sort Method: quicksort Memory: 66kB
3. 249.962 1,449.689 ↑ 28.9 294 1

HashAggregate (cost=109,670.85..110,074.18 rows=8,491 width=103) (actual time=1,448.586..1,449.689 rows=294 loops=1)

  • Group Key: time_bucket('00:05:00'::interval, o.date), o.ip_src
4. 406.923 1,199.727 ↓ 1.0 88,135 1

Result (cost=0.00..107,972.61 rows=84,912 width=27) (actual time=20.640..1,199.727 rows=88,135 loops=1)

5. 396.309 792.804 ↓ 1.0 88,135 1

Append (cost=0.00..106,911.21 rows=84,912 width=27) (actual time=20.631..792.804 rows=88,135 loops=1)

6. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on netflow_out o (cost=0.00..0.00 rows=1 width=52) (actual time=0.012..0.014 rows=0 loops=1)

  • Filter: ((date > '05.02.2019 11:10:00'::timestamp without time zone) AND (date < '06.02.2019 11:40:00'::timestamp without time zone) AND (ip_src = '109.164.73.150'::inet))
7. 179.403 192.465 ↑ 1.0 41,963 1

Bitmap Heap Scan on _hyper_25_467_chunk o_1 (cost=1,117.85..46,282.46 rows=43,405 width=27) (actual time=20.605..192.465 rows=41,963 loops=1)

  • Recheck Cond: ((ip_src = '109.164.73.150'::inet) AND (date > '05.02.2019 11:10:00'::timestamp without time zone) AND (date < '06.02.2019 11:40:00'::timestamp without time zone))
  • Heap Blocks: exact=40813
8. 13.062 13.062 ↑ 1.0 41,963 1

Bitmap Index Scan on _hyper_25_467_chunk_netflow_out_ip_src_date_idx (cost=0.00..1,107.00 rows=43,405 width=0) (actual time=13.059..13.062 rows=41,963 loops=1)

  • Index Cond: ((ip_src = '109.164.73.150'::inet) AND (date > '05.02.2019 11:10:00'::timestamp without time zone) AND (date < '06.02.2019 11:40:00'::timestamp without time zone))
9. 195.224 204.016 ↓ 1.1 46,172 1

Bitmap Heap Scan on _hyper_25_458_chunk o_2 (cost=1,073.76..60,628.75 rows=41,506 width=27) (actual time=17.449..204.016 rows=46,172 loops=1)

  • Recheck Cond: ((ip_src = '109.164.73.150'::inet) AND (date > '05.02.2019 11:10:00'::timestamp without time zone) AND (date < '06.02.2019 11:40:00'::timestamp without time zone))
  • Heap Blocks: exact=45844
10. 8.792 8.792 ↓ 1.1 46,172 1

Bitmap Index Scan on _hyper_25_458_chunk_netflow_out_ip_src_date_idx (cost=0.00..1,063.39 rows=41,506 width=0) (actual time=8.790..8.792 rows=46,172 loops=1)

  • Index Cond: ((ip_src = '109.164.73.150'::inet) AND (date > '05.02.2019 11:10:00'::timestamp without time zone) AND (date < '06.02.2019 11:40:00'::timestamp without time zone))
11. 1.365 1,422.659 ↑ 29.5 292 1

Materialize (cost=119,833.66..119,963.07 rows=8,627 width=103) (actual time=1,420.636..1,422.659 rows=292 loops=1)

12. 1.437 1,421.294 ↑ 29.5 292 1

Sort (cost=119,833.66..119,855.23 rows=8,627 width=103) (actual time=1,420.629..1,421.294 rows=292 loops=1)

  • Sort Key: (time_bucket('00:05:00'::interval, i.date))
  • Sort Method: quicksort Memory: 66kB
13. 244.322 1,419.857 ↑ 29.5 292 1

HashAggregate (cost=118,859.91..119,269.69 rows=8,627 width=103) (actual time=1,418.591..1,419.857 rows=292 loops=1)

  • Group Key: time_bucket('00:05:00'::interval, i.date), i.ip_dst
14. 399.668 1,175.535 ↓ 1.0 87,595 1

Result (cost=0.00..117,134.51 rows=86,270 width=27) (actual time=14.972..1,175.535 rows=87,595 loops=1)

15. 390.912 775.867 ↓ 1.0 87,595 1

Append (cost=0.00..116,056.13 rows=86,270 width=27) (actual time=14.967..775.867 rows=87,595 loops=1)

16. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on netflow_in i (cost=0.00..0.00 rows=1 width=52) (actual time=0.008..0.010 rows=0 loops=1)

  • Filter: ((date > '05.02.2019 11:00:00'::timestamp without time zone) AND (date < '06.02.2019 11:20:00'::timestamp without time zone) AND (ip_dst = '109.164.73.150'::inet))
17. 171.550 179.137 ↑ 1.0 40,797 1

Bitmap Heap Scan on _hyper_24_471_chunk i_1 (cost=1,063.51..49,324.56 rows=41,486 width=27) (actual time=14.952..179.137 rows=40,797 loops=1)

  • Recheck Cond: ((ip_dst = '109.164.73.150'::inet) AND (date > '05.02.2019 11:00:00'::timestamp without time zone) AND (date < '06.02.2019 11:20:00'::timestamp without time zone))
  • Heap Blocks: exact=40466
18. 7.587 7.587 ↑ 1.0 40,797 1

Bitmap Index Scan on _hyper_24_471_chunk_netflow_in_ip_dst_date_idx (cost=0.00..1,053.13 rows=41,486 width=0) (actual time=7.585..7.587 rows=40,797 loops=1)

  • Index Cond: ((ip_dst = '109.164.73.150'::inet) AND (date > '05.02.2019 11:00:00'::timestamp without time zone) AND (date < '06.02.2019 11:20:00'::timestamp without time zone))
19. 194.537 205.808 ↓ 1.0 46,798 1

Bitmap Heap Scan on _hyper_24_457_chunk i_2 (cost=1,155.55..66,731.57 rows=44,783 width=27) (actual time=20.570..205.808 rows=46,798 loops=1)

  • Recheck Cond: ((ip_dst = '109.164.73.150'::inet) AND (date > '05.02.2019 11:00:00'::timestamp without time zone) AND (date < '06.02.2019 11:20:00'::timestamp without time zone))
  • Heap Blocks: exact=46515
20. 11.271 11.271 ↓ 1.0 46,798 1

Bitmap Index Scan on _hyper_24_457_chunk_netflow_in_ip_dst_date_idx (cost=0.00..1,144.35 rows=44,783 width=0) (actual time=11.269..11.271 rows=46,798 loops=1)

  • Index Cond: ((ip_dst = '109.164.73.150'::inet) AND (date > '05.02.2019 11:00:00'::timestamp without time zone) AND (date < '06.02.2019 11:20:00'::timestamp without time zone))