explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jNOh

Settings
# exclusive inclusive rows x rows loops node
1. 5.656 7,259.294 ↑ 10.4 116 1

GroupAggregate (cost=1,486,802.29..1,486,901.62 rows=1,204 width=60) (actual time=7,253.361..7,259.294 rows=116 loops=1)

  • Group Key: t1.project_id, t1.month, t1.currency_type, t1.currency_code
2. 3.288 7,253.638 ↓ 2.6 3,091 1

Sort (cost=1,486,802.29..1,486,805.30 rows=1,204 width=60) (actual time=7,253.317..7,253.638 rows=3,091 loops=1)

  • Sort Key: t1.project_id, t1.month, t1.currency_type, t1.currency_code
  • Sort Method: quicksort Memory: 531kB
3. 708.587 7,250.350 ↓ 2.6 3,091 1

Hash Join (cost=126,173.09..1,486,740.68 rows=1,204 width=60) (actual time=887.305..7,250.350 rows=3,091 loops=1)

  • Hash Cond: ((t1.project_id = t2.project_id) AND ((t1.player_id)::text = (t2.player_id)::text))
4. 5,676.283 6,541.267 ↓ 1.6 4,123,881 1

Bitmap Heap Scan on app_playerdailystat t1 (cost=126,129.86..1,454,494.14 rows=2,575,302 width=60) (actual time=867.476..6,541.267 rows=4,123,881 loops=1)

  • Recheck Cond: ((project_id = ANY ('{306,526,545,55,390,585,563,583,29,116,196,354,569,101,622,104,200,458,649,318,367,31,213,313,112,338,230,13,9,15,283,222,449,474,432,525,292,309,385,231,477,492,235,375,296,629,448,388,371,370,232,377,415,465,476,346,475,403,520,584,595,466,645,393,258,625,639,522,198,195,457,647,456,651,382,343,392,643,39,335,661,582,98,331,531,353,536,567,121,214,552,463,295,105,159,223,473,376,586,558,452,627,544,455,59,239,304,197,451,30,182,553,360,149,673,273,111,484,236,614,512,478,115,314,345,43,255,633,429,290,418,436,359,496,417,600,601,628,83,636,397,297,560,172,224,537,528,489,621,615,161,554,504,194,327,384,391,387,399,262,264,617,266,289,253,285,206,408,268,249,250,252,619,320,592,407,401,204,251,238,366,461,40,336,662,613,302,373,379,325,79,588,256,564,680,487,568,344,667,150,539,655,657,561,490,77,459,604,605,606,607,608,609,610,611,35,282,308,499,637,372,310,381,524,510,679,394,305,438,624,378,470,351,587,227,541,589,623,488,177,447,498,147,422,538,181,109,157,383,508,506,491,533,326,226,416,590,509,542,681,280,233,107,380,210,44,631,596,543,300,523,599,559,259,48,462,74,240,299,669,145,414,301,602,234,411,281,62,269,386,518,511,515,603,597,322,495,352,676,100,556,221,562,500,479,69,323,431,53,464,514,497,272,340,342,298,632,123,555,81,71,57,28,136,594,659,630,425,97,521,598,163,106,505,389,374,626,334,519,428,612,316,641,540,17,486,653,368,566}'::integer[])) AND (month >= '2018-09-01 00:00:00'::timestamp without time zone) AND ((currency_type)::text = 'real'::text) AND ((currency_code)::text = 'EUR'::text))
  • Rows Removed by Index Recheck: 59665
  • Heap Blocks: exact=12624 lossy=59512
5. 864.984 864.984 ↓ 1.6 4,124,073 1

Bitmap Index Scan on app_playerdailystat_1 (cost=0.00..125,486.04 rows=2,575,302 width=0) (actual time=864.984..864.984 rows=4,124,073 loops=1)

  • Index Cond: ((project_id = ANY ('{306,526,545,55,390,585,563,583,29,116,196,354,569,101,622,104,200,458,649,318,367,31,213,313,112,338,230,13,9,15,283,222,449,474,432,525,292,309,385,231,477,492,235,375,296,629,448,388,371,370,232,377,415,465,476,346,475,403,520,584,595,466,645,393,258,625,639,522,198,195,457,647,456,651,382,343,392,643,39,335,661,582,98,331,531,353,536,567,121,214,552,463,295,105,159,223,473,376,586,558,452,627,544,455,59,239,304,197,451,30,182,553,360,149,673,273,111,484,236,614,512,478,115,314,345,43,255,633,429,290,418,436,359,496,417,600,601,628,83,636,397,297,560,172,224,537,528,489,621,615,161,554,504,194,327,384,391,387,399,262,264,617,266,289,253,285,206,408,268,249,250,252,619,320,592,407,401,204,251,238,366,461,40,336,662,613,302,373,379,325,79,588,256,564,680,487,568,344,667,150,539,655,657,561,490,77,459,604,605,606,607,608,609,610,611,35,282,308,499,637,372,310,381,524,510,679,394,305,438,624,378,470,351,587,227,541,589,623,488,177,447,498,147,422,538,181,109,157,383,508,506,491,533,326,226,416,590,509,542,681,280,233,107,380,210,44,631,596,543,300,523,599,559,259,48,462,74,240,299,669,145,414,301,602,234,411,281,62,269,386,518,511,515,603,597,322,495,352,676,100,556,221,562,500,479,69,323,431,53,464,514,497,272,340,342,298,632,123,555,81,71,57,28,136,594,659,630,425,97,521,598,163,106,505,389,374,626,334,519,428,612,316,641,540,17,486,653,368,566}'::integer[])) AND (month >= '2018-09-01 00:00:00'::timestamp without time zone) AND ((currency_type)::text = 'real'::text) AND ((currency_code)::text = 'EUR'::text))
6. 0.251 0.496 ↑ 1.0 1,249 1

Hash (cost=24.49..24.49 rows=1,249 width=25) (actual time=0.496..0.496 rows=1,249 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 87kB
7. 0.245 0.245 ↑ 1.0 1,249 1

Seq Scan on app_testplayer t2 (cost=0.00..24.49 rows=1,249 width=25) (actual time=0.005..0.245 rows=1,249 loops=1)