explain.depesz.com

A tool for finding a real cause for slow queries.

Result: fTn : slow

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.020 4119.206 ↑ 1.0 1 1

Result (cost=932078.920..932078.930 rows=1 width=0) (actual time=4119.205..4119.206 rows=1 loops=1)

2.          

Initplan (forResult)

3. 22.222 821.467 ↑ 1.0 1 1

Aggregate (cost=463041.020..463041.030 rows=1 width=0) (actual time=821.466..821.467 rows=1 loops=1)

4. 799.245 799.245 ↓ 1339.7 25455 1

Index Scan using golf on foxtrot (cost=0.010..463040.970 rows=19 width=0) (actual time=0.276..799.245 rows=25455 loops=1)

  • Index Cond: ((xray = false) AND (india >= (zulu() - 'seven'::interval)))
  • Filter: (NOT xray)
5. 801.290 3297.719 ↑ 1.0 1 1

Aggregate (cost=469037.880..469037.890 rows=1 width=0) (actual time=3297.718..3297.719 rows=1 loops=1)

6. 2496.429 2496.429 ↓ 529.8 931342 1

Index Scan using golf on foxtrot (cost=0.010..469033.490 rows=1758 width=0) (actual time=33.963..2496.429 rows=931342 loops=1)

  • Index Cond: ((xray = true) AND (india >= (zulu() - 'seven'::interval)))
  • Filter: xray