explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZygY

Settings
# exclusive inclusive rows x rows loops node
1. 15.010 172.709 ↑ 334.4 225 1

Hash Join (cost=7,701.15..12,113.26 rows=75,247 width=83) (actual time=147.132..172.709 rows=225 loops=1)

  • Hash Cond: (device_data.id = "ANY_subquery".first_value)
2. 10.685 10.685 ↑ 1.0 150,494 1

Seq Scan on device_data (cost=0.00..3,179.94 rows=150,494 width=83) (actual time=0.005..10.685 rows=150,494 loops=1)

3. 0.049 147.014 ↓ 1.1 225 1

Hash (cost=7,698.65..7,698.65 rows=200 width=4) (actual time=147.014..147.014 rows=225 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
4. 24.276 146.965 ↓ 1.1 225 1

HashAggregate (cost=7,696.65..7,698.65 rows=200 width=4) (actual time=146.924..146.965 rows=225 loops=1)

  • Group Key: "ANY_subquery".first_value
5. 15.876 122.689 ↑ 1.0 150,494 1

Subquery Scan on ANY_subquery (cost=0.42..7,320.42 rows=150,494 width=4) (actual time=0.035..122.689 rows=150,494 loops=1)

6. 72.589 106.813 ↑ 1.0 150,494 1

WindowAgg (cost=0.42..5,815.48 rows=150,494 width=21) (actual time=0.034..106.813 rows=150,494 loops=1)

7. 34.224 34.224 ↑ 1.0 150,494 1

Index Only Scan using device_data_search_i on device_data device_data_1 (cost=0.42..3,181.83 rows=150,494 width=21) (actual time=0.031..34.224 rows=150,494 loops=1)

  • Heap Fetches: 714
Planning time : 0.228 ms
Execution time : 172.850 ms