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 4,119.206 ↑ 1.0 1 1

Result (cost=932,078.920..932,078.930 rows=1 width=0) (actual time=4,119.205..4,119.206 rows=1 loops=1)

2.          

Initplan (forResult)

3. 22.222 821.467 ↑ 1.0 1 1

Aggregate (cost=463,041.020..463,041.030 rows=1 width=0) (actual time=821.466..821.467 rows=1 loops=1)

4. 799.245 799.245 ↓ 1,339.7 25,455 1

Index Scan using golf on foxtrot (cost=0.010..463,040.970 rows=19 width=0) (actual time=0.276..799.245 rows=25,455 loops=1)

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

Aggregate (cost=469,037.880..469,037.890 rows=1 width=0) (actual time=3,297.718..3,297.719 rows=1 loops=1)

6. 2,496.429 2,496.429 ↓ 529.8 931,342 1

Index Scan using golf on foxtrot (cost=0.010..469,033.490 rows=1,758 width=0) (actual time=33.963..2,496.429 rows=931,342 loops=1)

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