explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FTpU

Settings
# exclusive inclusive rows x rows loops node
1. 42.256 1,871.336 ↑ 87.0 26 1

Hash Right Join (cost=29,793.72..31,165.90 rows=2,263 width=171) (actual time=1,771.903..1,871.336 rows=26 loops=1)

  • Hash Cond: ((public.mt_shohin_detail.hinban_code)::text = (shukko.hinban_code)::text)
2. 508.800 685.301 ↓ 1.5 84,479 1

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

3. 176.501 176.501 ↑ 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.011..176.501 rows=313,824 loops=1)

4. 0.078 1,143.779 ↓ 3.2 26 1

Hash (cost=16,209.26..16,209.26 rows=8 width=139) (actual time=1,143.779..1,143.779 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
5. 129.532 1,143.701 ↓ 3.2 26 1

Hash Right Join (cost=14,653.09..16,209.26 rows=8 width=139) (actual time=834.295..1,143.701 rows=26 loops=1)

  • Hash Cond: (((public.mt_shohin_detail.hinban_code)::text = (shukko.hinban_code)::text) AND ((public.mt_shohin_detail.color_code)::text = (shukko.color_code)::text))
6. 802.628 1,012.834 ↓ 4.2 237,082 1

HashAggregate (cost=14,368.92..14,934.77 rows=56,585 width=287) (actual time=828.438..1,012.834 rows=237,082 loops=1)

7. 210.206 210.206 ↑ 1.0 313,824 1

Seq Scan on mt_shohin_detail (cost=0.00..12,015.24 rows=313,824 width=287) (actual time=0.029..210.206 rows=313,824 loops=1)

8. 0.063 1.335 ↓ 4.3 26 1

Hash (cost=284.08..284.08 rows=6 width=107) (actual time=1.335..1.335 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
9. 0.147 1.272 ↓ 4.3 26 1

Nested Loop (cost=232.19..284.08 rows=6 width=107) (actual time=0.509..1.272 rows=26 loops=1)

10. 0.131 0.605 ↓ 4.3 26 1

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

  • Hash Cond: ((color.color_code)::text = (shukko.color_code)::text)
11. 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.022..0.081 rows=79 loops=1)

12. 0.037 0.393 ↓ 4.3 26 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
13. 0.042 0.356 ↓ 4.3 26 1

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

14. 0.163 0.314 ↓ 4.3 26 1

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

15. 0.151 0.151 ↑ 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.106..0.151 rows=27 loops=1)

  • Index Cond: ((pickup_delivery_no)::text = '0041244603'::text)
16. 0.520 0.520 ↑ 1.0 1 26

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.019..0.020 rows=1 loops=26)

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