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 5,542.642 ↓ 2.6 265,494 1

Hash Join (cost=11,251.650..208,369.900 rows=101,599 width=4) (actual time=136.613..5,542.642 rows=265,494 loops=1)

  • Hash Cond: (seven.four = papa.quebec)
2. 4,774.107 4,946.780 ↓ 2.9 297,500 1

Nested Loop Semi Join (cost=0.000..194,959.270 rows=101,599 width=4) (actual time=0.147..4,946.780 rows=297,500 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 1,050,000 1

Seq Scan on bravo seven (cost=0.000..20,314.230 rows=1,050,023 width=8) (actual time=0.008..172.673 rows=1,050,000 loops=1)

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

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

5. 69.110 69.110 ↑ 1.0 218,251 1

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