explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hwb7

Settings
# exclusive inclusive rows x rows loops node
1. 115.106 185.744 ↑ 5.8 4,097 1

GroupAggregate (cost=10,625.18..11,395.53 rows=23,703 width=234) (actual time=68.398..185.744 rows=4,097 loops=1)

  • Group Key: ps.fld_product_id, v2.size_set_id, pss.customize_id, pss.sub_group
  • Buffers: shared hit=3,103
2. 11.004 70.638 ↓ 1.0 24,484 1

Sort (cost=10,625.18..10,684.44 rows=23,703 width=180) (actual time=68.368..70.638 rows=24,484 loops=1)

  • Sort Key: ps.fld_product_id, v2.size_set_id, pss.customize_id, pss.sub_group
  • Sort Method: quicksort Memory: 2,828kB
  • Buffers: shared hit=3,103
3. 8.106 59.634 ↓ 1.0 24,484 1

Hash Join (cost=4,404.52..6,795.83 rows=23,703 width=180) (actual time=29.401..59.634 rows=24,484 loops=1)

  • Buffers: shared hit=3,103
4. 9.971 50.853 ↓ 1.0 24,484 1

Hash Join (cost=4,346.53..6,411.92 rows=23,703 width=34) (actual time=28.718..50.853 rows=24,484 loops=1)

  • Buffers: shared hit=3,075
5. 8.124 33.047 ↓ 1.0 24,484 1

Hash Join (cost=3,457.2..4,209.97 rows=23,902 width=26) (actual time=20.855..33.047 rows=24,484 loops=1)

  • Buffers: shared hit=2,688
6. 4.129 4.129 ↓ 1.0 24,491 1

Seq Scan on utb_product_size_list ps (cost=0..424.09 rows=23,909 width=16) (actual time=0.005..4.129 rows=24,491 loops=1)

  • Buffers: shared hit=185
7. 8.816 20.794 ↓ 1.0 42,499 1

Hash (cost=2,927.09..2,927.09 rows=42,409 width=18) (actual time=20.794..20.794 rows=42,499 loops=1)

  • Buffers: shared hit=2,503
8. 11.978 11.978 ↓ 1.0 42,499 1

Seq Scan on product_size_spec_v2 v2 (cost=0..2,927.09 rows=42,409 width=18) (actual time=0.004..11.978 rows=42,499 loops=1)

  • Buffers: shared hit=2,503
9. 4.191 7.835 ↓ 1.0 20,315 1

Hash (cost=587.93..587.93 rows=20,093 width=10) (actual time=7.835..7.835 rows=20,315 loops=1)

  • Buffers: shared hit=387
10. 3.644 3.644 ↓ 1.0 20,315 1

Seq Scan on product_size_set_param pssp (cost=0..587.93 rows=20,093 width=10) (actual time=0.004..3.644 rows=20,315 loops=1)

  • Buffers: shared hit=387
11. 0.281 0.675 ↑ 1.0 1,333 1

Hash (cost=41.33..41.33 rows=1,333 width=162) (actual time=0.675..0.675 rows=1,333 loops=1)

  • Buffers: shared hit=28
12. 0.394 0.394 ↑ 1.0 1,333 1

Seq Scan on product_size_set pss (cost=0..41.33 rows=1,333 width=162) (actual time=0.007..0.394 rows=1,333 loops=1)

  • Buffers: shared hit=28
Planning time : 0.746 ms
Execution time : 186.149 ms