explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MQIj

Settings
# exclusive inclusive rows x rows loops node
1. 6,636.466 77,910.002 ↑ 1.0 99,370 1

Gather (cost=97,930.30..170,257.40 rows=104,100 width=385) (actual time=47,038.513..77,910.002 rows=99,370 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 2,674.769 71,273.536 ↑ 1.3 33,123 3 / 3

Hash Left Join (cost=96,930.30..157,936.53 rows=43,375 width=385) (actual time=46,940.732..71,273.536 rows=33,123 loops=3)

  • Hash Cond: ((bs.player_id = hs.player_id) AND (bs.date = hs.date))
3. 3,743.582 63,547.511 ↑ 1.3 33,123 3 / 3

Hash Left Join (cost=86,467.25..140,858.14 rows=43,375 width=355) (actual time=41,851.502..63,547.511 rows=33,123 loops=3)

  • Hash Cond: ((bs.player_id = tr.player_id) AND (bs.date = tr.date))
4. 3,122.375 55,518.066 ↑ 1.3 33,123 3 / 3

Hash Left Join (cost=73,950.20..122,891.37 rows=43,375 width=323) (actual time=37,556.323..55,518.066 rows=33,123 loops=3)

  • Hash Cond: ((bs.player_id = tsd.player_id) AND (bs.date = tsd.date))
5. 2,859.118 48,027.307 ↑ 1.3 33,123 3 / 3

Hash Left Join (cost=65,232.15..109,223.60 rows=43,375 width=307) (actual time=33,180.237..48,027.307 rows=33,123 loops=3)

  • Hash Cond: ((bs.player_id = tpt.player_id) AND (bs.date = tpt.date))
6. 2,482.813 39,400.617 ↑ 1.3 33,123 3 / 3

Hash Left Join (cost=53,684.55..92,416.28 rows=43,375 width=243) (actual time=27,408.166..39,400.617 rows=33,123 loops=3)

  • Hash Cond: ((bs.player_id = td.player_id) AND (bs.date = td.date))
7. 1,982.875 31,584.023 ↑ 1.3 33,123 3 / 3

Hash Left Join (cost=42,408.28..76,634.29 rows=43,375 width=187) (actual time=22,064.592..31,584.023 rows=33,123 loops=3)

  • Hash Cond: ((bs.player_id = tp.player_id) AND (bs.date = tp.date))
8. 2,000.381 25,128.800 ↑ 1.3 33,123 3 / 3

Hash Left Join (cost=32,723.00..63,199.29 rows=43,375 width=147) (actual time=17,565.412..25,128.800 rows=33,123 loops=3)

  • Hash Cond: ((bs.player_id = tpu.player_id) AND (bs.date = tpu.date))
9. 1,641.447 18,985.766 ↑ 1.3 33,123 3 / 3

Hash Left Join (cost=23,636.68..50,849.25 rows=43,375 width=115) (actual time=13,408.972..18,985.766 rows=33,123 loops=3)

  • Hash Cond: ((bs.player_id = tpos.player_id) AND (bs.date = tpos.date))
10. 1,411.101 9,609.719 ↑ 1.3 33,123 3 / 3

Hash Left Join (cost=13,546.62..37,849.48 rows=43,375 width=83) (actual time=5,664.227..9,609.719 rows=33,123 loops=3)

  • Hash Cond: ((bs.player_id = tcs.player_id) AND (bs.date = tcs.date))
11. 869.617 3,976.589 ↑ 1.3 33,123 3 / 3

Hash Left Join (cost=4,894.95..26,699.09 rows=43,375 width=51) (actual time=1,430.481..3,976.589 rows=33,123 loops=3)

  • Hash Cond: ((bs.player_id = ds.close_def_person_id) AND (bs.date = ds.date))
12. 1,695.037 1,695.037 ↑ 1.3 33,123 3 / 3

Parallel Seq Scan on box_scores_v2 bs (cost=0.00..20,219.42 rows=43,375 width=38) (actual time=0.995..1,695.037 rows=33,123 loops=3)

  • Filter: ((date >= '2016-11-01'::date) AND (minutes > '0'::numeric) AND (date <= CURRENT_DATE))
  • Rows Removed by Filter: 141497
13. 138.030 1,411.935 ↑ 1.0 115,838 3 / 3

Hash (cost=2,478.38..2,478.38 rows=115,838 width=21) (actual time=1,411.935..1,411.935 rows=115,838 loops=3)

  • Buckets: 65536 Batches: 2 Memory Usage: 3678kB
14. 1,273.905 1,273.905 ↑ 1.0 115,838 3 / 3

Seq Scan on defensive_shooting ds (cost=0.00..2,478.38 rows=115,838 width=21) (actual time=0.023..1,273.905 rows=115,838 loops=3)

15. 162.367 4,222.029 ↑ 1.0 161,867 3 / 3

Hash (cost=4,800.67..4,800.67 rows=161,867 width=44) (actual time=4,222.029..4,222.029 rows=161,867 loops=3)

  • Buckets: 65536 Batches: 4 Memory Usage: 3508kB
16. 4,059.662 4,059.662 ↑ 1.0 161,867 3 / 3

Seq Scan on tracking_catchshoot tcs (cost=0.00..4,800.67 rows=161,867 width=44) (actual time=5.205..4,059.662 rows=161,867 loops=3)

17. 196.656 7,734.600 ↑ 1.0 169,922 3 / 3

Hash (cost=6,047.22..6,047.22 rows=169,922 width=44) (actual time=7,733.276..7,734.600 rows=169,922 loops=3)

  • Buckets: 65536 Batches: 4 Memory Usage: 3662kB
18. 7,537.944 7,537.944 ↑ 1.0 169,922 3 / 3

Seq Scan on tracking_possessions tpos (cost=0.00..6,047.22 rows=169,922 width=44) (actual time=6.964..7,537.944 rows=169,922 loops=3)

19. 249.054 4,142.653 ↑ 1.0 171,693 3 / 3

Hash (cost=5,000.93..5,000.93 rows=171,693 width=44) (actual time=4,142.652..4,142.653 rows=171,693 loops=3)

  • Buckets: 65536 Batches: 4 Memory Usage: 3491kB
20. 3,893.599 3,893.599 ↑ 1.0 171,693 3 / 3

Seq Scan on tracking_pullupshot tpu (cost=0.00..5,000.93 rows=171,693 width=44) (actual time=6.936..3,893.599 rows=171,693 loops=3)

21. 193.895 4,472.348 ↑ 1.0 169,731 3 / 3

Hash (cost=5,481.31..5,481.31 rows=169,731 width=52) (actual time=4,472.348..4,472.348 rows=169,731 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 2248kB
22. 4,278.453 4,278.453 ↑ 1.0 169,731 3 / 3

Seq Scan on tracking_passing tp (cost=0.00..5,481.31 rows=169,731 width=52) (actual time=5.726..4,278.453 rows=169,731 loops=3)

23. 194.360 5,333.781 ↑ 1.0 169,731 3 / 3

Hash (cost=6,740.31..6,740.31 rows=169,731 width=68) (actual time=5,333.781..5,333.781 rows=169,731 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 2580kB
24. 5,139.421 5,139.421 ↑ 1.0 169,731 3 / 3

Seq Scan on tracking_drives td (cost=0.00..6,740.31 rows=169,731 width=68) (actual time=1.968..5,139.421 rows=169,731 loops=3)

25. 221.154 5,767.572 ↑ 1.0 169,304 3 / 3

Hash (cost=6,858.04..6,858.04 rows=169,304 width=76) (actual time=5,767.572..5,767.572 rows=169,304 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 2739kB
26. 5,546.418 5,546.418 ↑ 1.0 169,304 3 / 3

Seq Scan on tracking_painttouch tpt (cost=0.00..6,858.04 rows=169,304 width=76) (actual time=0.027..5,546.418 rows=169,304 loops=3)

27. 242.099 4,368.384 ↑ 1.0 169,922 3 / 3

Hash (cost=5,007.22..5,007.22 rows=169,922 width=28) (actual time=4,368.384..4,368.384 rows=169,922 loops=3)

  • Buckets: 65536 Batches: 4 Memory Usage: 2998kB
28. 4,126.285 4,126.285 ↑ 1.0 169,922 3 / 3

Seq Scan on tracking_speeddistance tsd (cost=0.00..5,007.22 rows=169,922 width=28) (actual time=4.765..4,126.285 rows=169,922 loops=3)

29. 198.242 4,285.863 ↑ 1.0 169,922 3 / 3

Hash (cost=8,474.22..8,474.22 rows=169,922 width=44) (actual time=4,285.863..4,285.863 rows=169,922 loops=3)

  • Buckets: 65536 Batches: 4 Memory Usage: 3662kB
30. 4,087.621 4,087.621 ↑ 1.0 169,922 3 / 3

Seq Scan on tracking_rebounding tr (cost=0.00..8,474.22 rows=169,922 width=44) (actual time=4.243..4,087.621 rows=169,922 loops=3)

31. 184.785 5,051.256 ↑ 1.0 170,842 3 / 3

Hash (cost=6,231.42..6,231.42 rows=170,842 width=52) (actual time=5,051.256..5,051.256 rows=170,842 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 2261kB
32. 4,866.471 4,866.471 ↑ 1.0 170,842 3 / 3

Seq Scan on hustle_stats hs (cost=0.00..6,231.42 rows=170,842 width=52) (actual time=3.137..4,866.471 rows=170,842 loops=3)

Planning time : 520.316 ms
Execution time : 78,599.613 ms