explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5d0

Settings
# exclusive inclusive rows x rows loops node
1. 0.154 762.250 ↑ 10.9 26 1

GroupAggregate (cost=15,235.25..15,250.81 rows=283 width=413) (actual time=762.092..762.250 rows=26 loops=1)

2. 0.468 762.096 ↑ 3.8 74 1

Sort (cost=15,235.25..15,235.95 rows=283 width=413) (actual time=762.068..762.096 rows=74 loops=1)

  • 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, (...)
  • Sort Method: quicksort Memory: 26kB
3. 42.557 761.628 ↑ 3.8 74 1

Hash Right Join (cost=13,877.00..15,223.72 rows=283 width=413) (actual time=662.131..761.628 rows=74 loops=1)

  • Hash Cond: ((mt_shohin_detail.hinban_code)::text = (shukko.hinban_code)::text)
4. 511.361 715.993 ↓ 1.5 84,479 1

HashAggregate (cost=13,584.36..14,150.21 rows=56,585 width=284) (actual time=658.211..715.993 rows=84,479 loops=1)

5. 204.632 204.632 ↑ 1.0 313,824 1

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

6. 0.161 3.078 ↓ 74.0 74 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.358 2.917 ↓ 74.0 74 1

Nested Loop (cost=232.19..292.63 rows=1 width=381) (actual time=0.516..2.917 rows=74 loops=1)

8. 0.266 1.671 ↓ 74.0 74 1

Nested Loop (cost=232.19..284.33 rows=1 width=342) (actual time=0.474..1.671 rows=74 loops=1)

9. 0.139 0.599 ↓ 4.3 26 1

Hash Right Join (cost=232.19..234.33 rows=6 width=58) (actual time=0.423..0.599 rows=26 loops=1)

  • Hash Cond: ((color.color_code)::text = (shukko.color_code)::text)
10. 0.081 0.081 ↑ 1.0 79 1

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

11. 0.035 0.379 ↓ 4.3 26 1

Hash (cost=232.11..232.11 rows=6 width=41) (actual time=0.379..0.379 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
12. 0.046 0.344 ↓ 4.3 26 1

Subquery Scan on shukko (cost=231.99..232.11 rows=6 width=41) (actual time=0.267..0.344 rows=26 loops=1)

13. 0.159 0.298 ↓ 4.3 26 1

HashAggregate (cost=231.99..232.05 rows=6 width=29) (actual time=0.265..0.298 rows=26 loops=1)

14. 0.139 0.139 ↑ 2.1 27 1

Index Scan using pk_dt_pickup_delivery on dt_pickup_delivery (cost=0.00..231.12 rows=58 width=29) (actual time=0.096..0.139 rows=27 loops=1)

  • Index Cond: ((pickup_delivery_no)::text = '0041244603'::text)
15. 0.806 0.806 ↓ 3.0 3 26

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

  • Index Cond: (((hinban_code)::text = (shukko.hinban_code)::text) AND ((color_code)::text = (shukko.color_code)::text))
16. 0.888 0.888 ↑ 1.0 1 74

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

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