explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ycDH

Settings
# exclusive inclusive rows x rows loops node
1. 0.678 35.383 ↓ 9.5 953 1

Sort (cost=108.07..108.32 rows=100 width=72) (actual time=35.259..35.383 rows=953 loops=1)

  • Sort Key: (sum(((jb.value ->> 'usage'::text))::integer)) DESC
  • Sort Method: quicksort Memory: 136kB
2. 1.530 34.705 ↓ 9.5 953 1

Hash Join (cost=15.17..104.74 rows=100 width=72) (actual time=32.478..34.705 rows=953 loops=1)

  • Hash Cond: ((package_data.package_name)::text = ((jb.value ->> 'app'::text)))
3. 0.736 0.736 ↓ 1.0 2,118 1

Seq Scan on package_data (cost=0.00..84.04 rows=2,104 width=48) (actual time=0.021..0.736 rows=2,118 loops=1)

4. 0.427 32.439 ↓ 9.8 984 1

Hash (cost=13.92..13.92 rows=100 width=40) (actual time=32.439..32.439 rows=984 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 73kB
5. 14.764 32.012 ↓ 9.8 984 1

HashAggregate (cost=11.67..12.92 rows=100 width=40) (actual time=31.650..32.012 rows=984 loops=1)

  • Group Key: (jb.value ->> 'app'::text)
6. 7.453 17.248 ↓ 84.3 8,427 1

Nested Loop (cost=0.15..10.42 rows=100 width=64) (actual time=7.670..17.248 rows=8,427 loops=1)

7. 0.030 0.030 ↑ 1.0 1 1

Index Scan using idx_log_data_start_time_copy1 on log_data_daily ld (cost=0.15..8.17 rows=1 width=18) (actual time=0.021..0.030 rows=1 loops=1)

  • Index Cond: ((start_time >= 1569007800) AND (start_time <= 1569094199))
8. 9.765 9.765 ↓ 84.3 8,427 1

Function Scan on jsonb_array_elements jb (cost=0.00..1.00 rows=100 width=32) (actual time=7.634..9.765 rows=8,427 loops=1)

Planning time : 0.500 ms
Execution time : 36.247 ms