explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Eihe

Settings
# exclusive inclusive rows x rows loops node
1. 0.117 0.753 ↑ 3.8 26 1

Group (cost=110.59..117.09 rows=100 width=926) (actual time=0.651..0.753 rows=26 loops=1)

  • Buffers: local hit=15
2.          

Initplan (forGroup)

3. 0.015 0.022 ↑ 1.0 1 1

Aggregate (cost=11.25..11.26 rows=1 width=32) (actual time=0.022..0.022 rows=1 loops=1)

  • Buffers: local hit=1
4. 0.007 0.007 ↑ 3.8 26 1

Seq Scan on raw_style_data raw_style_data (cost=0..11 rows=100 width=8) (actual time=0.002..0.007 rows=26 loops=1)

  • Buffers: local hit=1
5. 0.010 0.020 ↑ 1.0 1 1

Aggregate (cost=11.25..11.26 rows=1 width=8) (actual time=0.019..0.02 rows=1 loops=1)

  • Buffers: local hit=1
6. 0.010 0.010 ↑ 3.8 26 1

Seq Scan on raw_style_data raw_style_data_1 (cost=0..11 rows=100 width=0) (actual time=0.002..0.01 rows=26 loops=1)

  • Buffers: local hit=1
7. 0.014 0.021 ↑ 1.0 1 1

Aggregate (cost=11.25..11.26 rows=1 width=32) (actual time=0.02..0.021 rows=1 loops=1)

  • Buffers: local hit=1
8. 0.007 0.007 ↑ 3.8 26 1

Seq Scan on raw_style_data raw_style_data_2 (cost=0..11 rows=100 width=8) (actual time=0.002..0.007 rows=26 loops=1)

  • Buffers: local hit=1
9. 0.009 0.015 ↑ 1.0 1 1

Aggregate (cost=11.25..11.26 rows=1 width=8) (actual time=0.014..0.015 rows=1 loops=1)

  • Buffers: local hit=1
10. 0.006 0.006 ↑ 3.8 26 1

Seq Scan on raw_style_data raw_style_data_3 (cost=0..11 rows=100 width=0) (actual time=0.001..0.006 rows=26 loops=1)

  • Buffers: local hit=1
11. 0.022 0.029 ↑ 1.0 1 1

Aggregate (cost=11.25..11.26 rows=1 width=32) (actual time=0.028..0.029 rows=1 loops=1)

  • Buffers: local hit=1
12. 0.007 0.007 ↑ 3.8 26 1

Seq Scan on raw_style_data raw_style_data_4 (cost=0..11 rows=100 width=32) (actual time=0.001..0.007 rows=26 loops=1)

  • Buffers: local hit=1
13. 0.007 0.013 ↑ 1.0 1 1

Aggregate (cost=11.25..11.26 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=1)

  • Buffers: local hit=1
14. 0.006 0.006 ↑ 3.8 26 1

Seq Scan on raw_style_data raw_style_data_5 (cost=0..11 rows=100 width=0) (actual time=0.001..0.006 rows=26 loops=1)

  • Buffers: local hit=1
15. 0.050 0.516 ↑ 3.8 26 1

Sort (cost=43.02..43.27 rows=100 width=830) (actual time=0.508..0.516 rows=26 loops=1)

  • Sort Key: rsd."RPM" DESC, rsd.style, rsd."ATC %", rsd."Add to Cart", rsd."CR %", rsd."Impressions", rsd."Orders", rsd."# Waitlist Requests", rsd.category, bsc.broken_size_count, bc.broken_core
  • Sort Method: quicksort Memory: 31kB
  • Buffers: local hit=9
16. 0.029 0.466 ↑ 3.8 26 1

Hash Join (cost=25.4..39.7 rows=100 width=830) (actual time=0.28..0.466 rows=26 loops=1)

  • Buffers: local hit=9
17. 0.112 0.216 ↑ 3.8 26 1

Hash Join (cost=12.25..25.18 rows=100 width=798) (actual time=0.051..0.216 rows=26 loops=1)

  • Buffers: local hit=5
18. 0.077 0.077 ↓ 2.3 324 1

Seq Scan on broken_size_count bsc (cost=0..11.4 rows=140 width=548) (actual time=0.004..0.077 rows=324 loops=1)

  • Buffers: local hit=4
19. 0.016 0.027 ↑ 3.8 26 1

Hash (cost=11..11 rows=100 width=766) (actual time=0.027..0.027 rows=26 loops=1)

  • Buffers: local hit=1
20. 0.011 0.011 ↑ 3.8 26 1

Seq Scan on raw_style_data rsd (cost=0..11 rows=100 width=766) (actual time=0.006..0.011 rows=26 loops=1)

  • Buffers: local hit=1
21. 0.123 0.221 ↓ 2.2 311 1

Hash (cost=11.4..11.4 rows=140 width=548) (actual time=0.22..0.221 rows=311 loops=1)

  • Buffers: local hit=4
22. 0.098 0.098 ↓ 2.2 311 1

Seq Scan on broken_core bc (cost=0..11.4 rows=140 width=548) (actual time=0.005..0.098 rows=311 loops=1)

  • Buffers: local hit=4