explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jKCC

Settings
# exclusive inclusive rows x rows loops node
1. 42.648 740.199 ↑ 65.3 26 1

Hash Right Join (cost=14,190.17..15,555.29 rows=1,698 width=171) (actual time=638.671..740.199 rows=26 loops=1)

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

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

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

4. 0.058 2.148 ↓ 4.3 26 1

Hash (cost=605.73..605.73 rows=6 width=139) (actual time=2.148..2.148 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
5. 0.120 2.090 ↓ 4.3 26 1

Nested Loop (cost=524.16..605.73 rows=6 width=139) (actual time=1.630..2.090 rows=26 loops=1)

6. 0.090 1.710 ↓ 4.3 26 1

Hash Right Join (cost=524.16..555.99 rows=6 width=90) (actual time=1.607..1.710 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))
7. 0.162 1.100 ↑ 44.5 26 1

HashAggregate (cost=289.74..301.31 rows=1,157 width=287) (actual time=1.069..1.100 rows=26 loops=1)

8. 0.323 0.938 ↑ 15.6 74 1

Nested Loop (cost=231.41..281.06 rows=1,157 width=287) (actual time=0.132..0.938 rows=74 loops=1)

9. 0.071 0.121 ↓ 4.3 26 1

HashAggregate (cost=231.41..231.47 rows=6 width=13) (actual time=0.097..0.121 rows=26 loops=1)

10. 0.050 0.050 ↑ 2.1 27 1

Index Scan using pk_dt_pickup_delivery on dt_pickup_delivery (cost=0.00..231.12 rows=58 width=13) (actual time=0.015..0.050 rows=27 loops=1)

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

Index Scan using pk_mt_shohin_detail on mt_shohin_detail (cost=0.00..8.25 rows=1 width=287) (actual time=0.016..0.019 rows=3 loops=26)

  • Index Cond: (((hinban_code)::text = (public.dt_pickup_delivery.hinban_code)::text) AND ((color_code)::text = (public.dt_pickup_delivery.color_code)::text))
12. 0.043 0.520 ↓ 4.3 26 1

Hash (cost=234.33..234.33 rows=6 width=58) (actual time=0.520..0.520 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
13. 0.124 0.477 ↓ 4.3 26 1

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

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

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

15. 0.038 0.286 ↓ 4.3 26 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
16. 0.039 0.248 ↓ 4.3 26 1

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

17. 0.152 0.209 ↓ 4.3 26 1

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

18. 0.057 0.057 ↑ 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.024..0.057 rows=27 loops=1)

  • Index Cond: ((pickup_delivery_no)::text = '0041244603'::text)
19. 0.260 0.260 ↑ 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.009..0.010 rows=1 loops=26)

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