explain.depesz.com

A tool for finding a real cause for slow queries.

Result: hQDB

options
# exclusive inclusive rows x rows loops node
1. 432.621 5813.166 ↓ 2.6 265494 1
→

Hash Join (cost=11251.650..222009.130 rows=101599 width=4) (actual time=116.086..5813.166 rows=265494 loops=1)

  • Hash Cond: (seven.four = papa.quebec)
2. 5098.237 5264.819 ↓ 2.9 297500 1
→

Nested Loop Semi Join (cost=0.000..208598.510 rows=101599 width=4) (actual time=0.159..5264.819 rows=297500 loops=1)

  • -> Index Scan using tracking_history_vid_index on tracking_history (cost=0.00..1.81 rows=11 width=4) (actual time=0.004..0.004 rows=0 loops=105
3. 166.582 166.582 ↑ 1.0 1050000 1
→

Seq Scan on bravo seven (cost=0.000..20314.230 rows=1050023 width=8) (actual time=0.008..166.582 rows=1050000 loops=1)

  • Index Cond: (golf.echo = seven.echo)
  • Filter: ((golf.alpha >= 'foxtrot'::timestamp with time zone) AND (golf.lima >= 500))
4. 58.868 115.726 ↑ 1.0 218251 1
→

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

5. 56.858 56.858 ↑ 1.0 218251 1
→

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