explain.depesz.com

A tool for finding a real cause for slow queries.

Result: rIDH

options
# exclusive inclusive rows x rows loops node
1. 128.948 19394.175 ↑ 1.3 80000 1
→

Hash Join (cost=252781.180..256899.960 rows=101599 width=4) (actual time=17284.386..19394.175 rows=80000 loops=1)

  • Hash Cond: (seven.four = papa.quebec)
2. 1936.843 19138.515 ↑ 1.2 85000 1
→

Nested Loop (cost=241529.540..243489.330 rows=101599 width=4) (actual time=17157.519..19138.515 rows=85000 loops=1)

  • -> Index Scan using tracking_visitor_vid_index on tracking_visitor tv (cost=0.00..0.34 rows=1 width=8) (actual time=0.022..0.022 rows=1 loops=8
3. 17201.672 17201.672 ↓ 15.8 85000 1
→

HashAggregate (cost=241529.540..241583.250 rows=5371 width=4) (actual time=17157.455..17201.672 rows=85000 loops=1)

  • -> Index Scan using tracking_history_duration_index on tracking_history (cost=0.00..240823.90 rows=282253 width=4) (actual time=0.072..16
  • Index Cond: (lima >= 500)
  • Filter: (alpha_two >= 'alpha_whiskey'::timestamp with time zone)
  • Index Cond: (seven.echo = golf.echo)
4. 67.836 126.712 ↑ 1.0 218251 1
→

Hash (cost=8523.510..8523.510 rows=218251 width=4) (actual time=126.712..126.712 rows=218251 loops=1)

5. 58.876 58.876 ↑ 1.0 218251 1
→

Seq Scan on romeo papa (cost=0.000..8523.510 rows=218251 width=4) (actual time=0.009..58.876 rows=218251 loops=1)