explain.depesz.com

A tool for finding a real cause for slow queries.

Result: L73

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 454.235 20315.857 ↑ 1.6 905 1

HashAggregate (cost=1242.69..1316.29 rows=1472 width=8) (actual time=20314.659..20315.857 rows=905 loops=1)

2. 2782.738 19861.622 ↓ 17.1 251028 1

Result (cost=0.00..1058.80 rows=14711 width=8) (actual time=94.471..19861.622 rows=251028 loops=1)

3. 466.885 17078.884 ↓ 17.1 251028 1

Append (cost=0.00..507.14 rows=14711 width=8) (actual time=94.432..17078.884 rows=251028 loops=1)

4. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on accesses (cost=0.00..22.12 rows=323 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (unixtime >= 1335439860)
5. 16611.997 16611.997 ↓ 17.4 251028 1

Index Scan using y12041_unixtime_idx on y12041_accesses accesses (cost=0.00..485.01 rows=14388 width=8) (actual time=94.427..16611.997 rows=251028 loops=1)

  • Index Cond: (unixtime >= 1335439860)