explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fgTP

Settings
# exclusive inclusive rows x rows loops node
1. 6.501 8.445 ↑ 1.0 3,715 1

Hash Left Join (cost=17,934.97..18,154.87 rows=3,715 width=261) (actual time=1.500..8.445 rows=3,715 loops=1)

  • Hash Cond: ((t1.project_id = t3.project_id) AND (t1.month = t3.month))
2. 0.480 0.480 ↑ 1.0 3,715 1

Seq Scan on app_projectoverview t1 (cost=0.00..99.15 rows=3,715 width=53) (actual time=0.014..0.480 rows=3,715 loops=1)

3. 0.002 1.464 ↓ 0.0 0 1

Hash (cost=17,934.93..17,934.93 rows=3 width=216) (actual time=1.464..1.464 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
4. 0.000 1.462 ↓ 0.0 0 1

Subquery Scan on t3 (cost=17,934.83..17,934.93 rows=3 width=216) (actual time=1.462..1.462 rows=0 loops=1)

5. 0.000 1.462 ↓ 0.0 0 1

HashAggregate (cost=17,934.83..17,934.90 rows=3 width=39) (actual time=1.462..1.462 rows=0 loops=1)

  • Group Key: t4.project_id, t4.month, t4.currency_code
6. 1.342 1.462 ↓ 0.0 0 1

Nested Loop (cost=0.56..17,934.68 rows=3 width=39) (actual time=1.462..1.462 rows=0 loops=1)

7. 0.120 0.120 ↑ 1.0 1,249 1

Seq Scan on app_testplayer t5 (cost=0.00..24.49 rows=1,249 width=25) (actual time=0.001..0.120 rows=1,249 loops=1)

8. 0.000 0.000 ↓ 0.0 0 1,249

Index Scan using app_playerdailystat_project_id_day_currency__9b0effbe_uniq on app_playerdailystat t4 (cost=0.56..14.33 rows=1 width=53) (actual time=0.000..0.000 rows=0 loops=1,249)

  • Index Cond: ((project_id = t5.project_id) AND (project_id = ANY ('{1,2}'::integer[])) AND ((currency_code)::text = 'EUR'::text) AND ((player_id)::text = (t5.player_id)::text))
  • Filter: (month >= '2018-09-01 00:00:00'::timestamp without time zone)