explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MUOx

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=15,235.25..15,250.81 rows=283 width=413) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=15,235.25..15,235.95 rows=283 width=413) (actual rows= loops=)

  • Sort Key: shukko.meisai_no, shukko.hinban_code, shukko.color_code, shohin_kihon.shohin_name, shohin_kihon.proper_from, shohin_kihon.proper_to, (max((mt_shohin_detail.image_file_1)::text)), color.color_name, color.color_palette, shohin_kihon.baika, (...)
3. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=13,877.00..15,223.72 rows=283 width=413) (actual rows= loops=)

  • Hash Cond: ((mt_shohin_detail.hinban_code)::text = (shukko.hinban_code)::text)
4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=13,584.36..14,150.21 rows=56,585 width=284) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on mt_shohin_detail (cost=0.00..12,015.24 rows=313,824 width=284) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=292.63..292.63 rows=1 width=381) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=232.19..292.63 rows=1 width=381) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=232.19..284.33 rows=1 width=342) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=232.19..234.33 rows=6 width=58) (actual rows= loops=)

  • Hash Cond: ((color.color_code)::text = (shukko.color_code)::text)
10. 0.000 0.000 ↓ 0.0

Seq Scan on mt_color color (cost=0.00..1.79 rows=79 width=20) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=232.11..232.11 rows=6 width=41) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Subquery Scan on shukko (cost=231.99..232.11 rows=6 width=41) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

HashAggregate (cost=231.99..232.05 rows=6 width=29) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Scan using pk_dt_pickup_delivery on dt_pickup_delivery (cost=0.00..231.12 rows=58 width=29) (actual rows= loops=)

  • Index Cond: ((pickup_delivery_no)::text = '0041244603'::text)
15. 0.000 0.000 ↓ 0.0

Index Scan using pk_mt_shohin_detail on mt_shohin_detail shohin_detail (cost=0.00..8.32 rows=1 width=287) (actual rows= loops=)

  • Index Cond: (((hinban_code)::text = (shukko.hinban_code)::text) AND ((color_code)::text = (shukko.color_code)::text))
16. 0.000 0.000 ↓ 0.0

Index Scan using pk_mt_shohin_kihon on mt_shohin_kihon shohin_kihon (cost=0.00..8.28 rows=1 width=59) (actual rows= loops=)

  • Index Cond: ((hinban_code)::text = (shukko.hinban_code)::text)