explain.depesz.com

A tool for finding a real cause for slow queries.

Result: fLg

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 459.557 5542.642 ↓ 2.6 265494 1

Hash Join (cost=11251.650..208369.900 rows=101599 width=4) (actual time=136.613..5542.642 rows=265494 loops=1)

  • Hash Cond: (seven.four = papa.quebec)
2. 4774.107 4946.780 ↓ 2.9 297500 1

Nested Loop Semi Join (cost=0.000..194959.270 rows=101599 width=4) (actual time=0.147..4946.780 rows=297500 loops=1)

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

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

  • Index Cond: (golf.echo = seven.echo)
  • Filter: (golf.lima >= 500)
4. 67.195 136.305 ↑ 1.0 218251 1

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

5. 69.110 69.110 ↑ 1.0 218251 1

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