explain.depesz.com

A tool for finding a real cause for slow queries.

Result: rIDH

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 128.948 19,394.175 ↑ 1.3 80,000 1

Hash Join (cost=252,781.180..256,899.960 rows=101,599 width=4) (actual time=17,284.386..19,394.175 rows=80,000 loops=1)

  • Hash Cond: (seven.four = papa.quebec)
2. 1,936.843 19,138.515 ↑ 1.2 85,000 1

Nested Loop (cost=241,529.540..243,489.330 rows=101,599 width=4) (actual time=17,157.519..19,138.515 rows=85,000 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. 17,201.672 17,201.672 ↓ 15.8 85,000 1

HashAggregate (cost=241,529.540..241,583.250 rows=5,371 width=4) (actual time=17,157.455..17,201.672 rows=85,000 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 218,251 1

Hash (cost=8,523.510..8,523.510 rows=218,251 width=4) (actual time=126.712..126.712 rows=218,251 loops=1)

5. 58.876 58.876 ↑ 1.0 218,251 1

Seq Scan on romeo papa (cost=0.000..8,523.510 rows=218,251 width=4) (actual time=0.009..58.876 rows=218,251 loops=1)