explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZZRn

Settings
# exclusive inclusive rows x rows loops node
1. 1.514 4.563 ↑ 6.0 900 1

Hash Join (cost=45.75..1,174.27 rows=5,430 width=17) (actual time=2.355..4.563 rows=900 loops=1)

  • Output: m1.reg_yy, m1.reg_db, m1.reg_id
  • Hash Cond: ((tm1.ms_reg_yy = m1.reg_yy) AND (tm1.ms_reg_db = m1.reg_db) AND (tm1.ms_reg_id = m1.reg_id))
  • Buffers: shared hit=3 read=28
2. 0.253 1.006 ↑ 15.6 907 1

Append (cost=0.00..438.06 rows=14,137 width=37) (actual time=0.080..1.006 rows=907 loops=1)

  • Buffers: shared read=16
3. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_u2000 tm1 (cost=0.00..16.30 rows=630 width=38) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: tm1.ms_reg_yy, tm1.ms_reg_db, tm1.ms_reg_id
4. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2000 tm1_1 (cost=0.00..16.30 rows=630 width=38) (actual time=0.002..0.003 rows=0 loops=1)

  • Output: tm1_1.ms_reg_yy, tm1_1.ms_reg_db, tm1_1.ms_reg_id
5. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2001 tm1_2 (cost=0.00..16.30 rows=630 width=38) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: tm1_2.ms_reg_yy, tm1_2.ms_reg_db, tm1_2.ms_reg_id
6. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2002 tm1_3 (cost=0.00..16.30 rows=630 width=38) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: tm1_3.ms_reg_yy, tm1_3.ms_reg_db, tm1_3.ms_reg_id
7. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2003 tm1_4 (cost=0.00..16.30 rows=630 width=38) (actual time=0.001..0.002 rows=0 loops=1)

  • Output: tm1_4.ms_reg_yy, tm1_4.ms_reg_db, tm1_4.ms_reg_id
8. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2004 tm1_5 (cost=0.00..16.30 rows=630 width=38) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: tm1_5.ms_reg_yy, tm1_5.ms_reg_db, tm1_5.ms_reg_id
9. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2005 tm1_6 (cost=0.00..16.30 rows=630 width=38) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: tm1_6.ms_reg_yy, tm1_6.ms_reg_db, tm1_6.ms_reg_id
10. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2006 tm1_7 (cost=0.00..16.30 rows=630 width=38) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: tm1_7.ms_reg_yy, tm1_7.ms_reg_db, tm1_7.ms_reg_id
11. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2007 tm1_8 (cost=0.00..16.30 rows=630 width=38) (actual time=0.001..0.002 rows=0 loops=1)

  • Output: tm1_8.ms_reg_yy, tm1_8.ms_reg_db, tm1_8.ms_reg_id
12. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2008 tm1_9 (cost=0.00..16.30 rows=630 width=38) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: tm1_9.ms_reg_yy, tm1_9.ms_reg_db, tm1_9.ms_reg_id
13. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2009 tm1_10 (cost=0.00..16.30 rows=630 width=38) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: tm1_10.ms_reg_yy, tm1_10.ms_reg_db, tm1_10.ms_reg_id
14. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2010 tm1_11 (cost=0.00..16.30 rows=630 width=38) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: tm1_11.ms_reg_yy, tm1_11.ms_reg_db, tm1_11.ms_reg_id
15. 0.041 0.041 ↑ 1.0 1 1

Seq Scan on public.tanka_meisai1_p_tm1_2011 tm1_12 (cost=0.00..1.01 rows=1 width=17) (actual time=0.040..0.041 rows=1 loops=1)

  • Output: tm1_12.ms_reg_yy, tm1_12.ms_reg_db, tm1_12.ms_reg_id
  • Buffers: shared read=1
16. 0.027 0.027 ↑ 1.0 1 1

Seq Scan on public.tanka_meisai1_p_tm1_2012 tm1_13 (cost=0.00..1.01 rows=1 width=17) (actual time=0.026..0.027 rows=1 loops=1)

  • Output: tm1_13.ms_reg_yy, tm1_13.ms_reg_db, tm1_13.ms_reg_id
  • Buffers: shared read=1
17. 0.022 0.022 ↑ 1.0 1 1

Seq Scan on public.tanka_meisai1_p_tm1_2013 tm1_14 (cost=0.00..1.01 rows=1 width=17) (actual time=0.022..0.022 rows=1 loops=1)

  • Output: tm1_14.ms_reg_yy, tm1_14.ms_reg_db, tm1_14.ms_reg_id
  • Buffers: shared read=1
18. 0.019 0.019 ↑ 1.0 1 1

Seq Scan on public.tanka_meisai1_p_tm1_2014 tm1_15 (cost=0.00..1.01 rows=1 width=17) (actual time=0.019..0.019 rows=1 loops=1)

  • Output: tm1_15.ms_reg_yy, tm1_15.ms_reg_db, tm1_15.ms_reg_id
  • Buffers: shared read=1
19. 0.021 0.021 ↑ 1.0 1 1

Seq Scan on public.tanka_meisai1_p_tm1_2015 tm1_16 (cost=0.00..1.01 rows=1 width=17) (actual time=0.021..0.021 rows=1 loops=1)

  • Output: tm1_16.ms_reg_yy, tm1_16.ms_reg_db, tm1_16.ms_reg_id
  • Buffers: shared read=1
20. 0.024 0.024 ↑ 1.0 1 1

Seq Scan on public.tanka_meisai1_p_tm1_2016 tm1_17 (cost=0.00..1.01 rows=1 width=17) (actual time=0.023..0.024 rows=1 loops=1)

  • Output: tm1_17.ms_reg_yy, tm1_17.ms_reg_db, tm1_17.ms_reg_id
  • Buffers: shared read=1
21. 0.167 0.167 ↑ 1.0 300 1

Seq Scan on public.tanka_meisai1_p_tm1_2017 tm1_18 (cost=0.00..6.00 rows=300 width=17) (actual time=0.024..0.167 rows=300 loops=1)

  • Output: tm1_18.ms_reg_yy, tm1_18.ms_reg_db, tm1_18.ms_reg_id
  • Buffers: shared read=3
22. 0.165 0.165 ↑ 1.0 300 1

Seq Scan on public.tanka_meisai1_p_tm1_2018 tm1_19 (cost=0.00..6.00 rows=300 width=17) (actual time=0.021..0.165 rows=300 loops=1)

  • Output: tm1_19.ms_reg_yy, tm1_19.ms_reg_db, tm1_19.ms_reg_id
  • Buffers: shared read=3
23. 0.163 0.163 ↑ 1.0 300 1

Seq Scan on public.tanka_meisai1_p_tm1_2019 tm1_20 (cost=0.00..6.00 rows=300 width=17) (actual time=0.023..0.163 rows=300 loops=1)

  • Output: tm1_20.ms_reg_yy, tm1_20.ms_reg_db, tm1_20.ms_reg_id
  • Buffers: shared read=3
24. 0.029 0.029 ↑ 1.0 1 1

Seq Scan on public.tanka_meisai1_p_tm1_2020 tm1_21 (cost=0.00..1.01 rows=1 width=17) (actual time=0.028..0.029 rows=1 loops=1)

  • Output: tm1_21.ms_reg_yy, tm1_21.ms_reg_db, tm1_21.ms_reg_id
  • Buffers: shared read=1
25. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2021 tm1_22 (cost=0.00..16.30 rows=630 width=38) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: tm1_22.ms_reg_yy, tm1_22.ms_reg_db, tm1_22.ms_reg_id
26. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2022 tm1_23 (cost=0.00..16.30 rows=630 width=38) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: tm1_23.ms_reg_yy, tm1_23.ms_reg_db, tm1_23.ms_reg_id
27. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2023 tm1_24 (cost=0.00..16.30 rows=630 width=38) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: tm1_24.ms_reg_yy, tm1_24.ms_reg_db, tm1_24.ms_reg_id
28. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2024 tm1_25 (cost=0.00..16.30 rows=630 width=38) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: tm1_25.ms_reg_yy, tm1_25.ms_reg_db, tm1_25.ms_reg_id
29. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2025 tm1_26 (cost=0.00..16.30 rows=630 width=38) (actual time=0.007..0.008 rows=0 loops=1)

  • Output: tm1_26.ms_reg_yy, tm1_26.ms_reg_db, tm1_26.ms_reg_id
30. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2026 tm1_27 (cost=0.00..16.30 rows=630 width=38) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: tm1_27.ms_reg_yy, tm1_27.ms_reg_db, tm1_27.ms_reg_id
31. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2027 tm1_28 (cost=0.00..16.30 rows=630 width=38) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: tm1_28.ms_reg_yy, tm1_28.ms_reg_db, tm1_28.ms_reg_id
32. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2028 tm1_29 (cost=0.00..16.30 rows=630 width=38) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: tm1_29.ms_reg_yy, tm1_29.ms_reg_db, tm1_29.ms_reg_id
33. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on public.tanka_meisai1_p_tm1_2029 tm1_30 (cost=0.00..16.30 rows=630 width=38) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: tm1_30.ms_reg_yy, tm1_30.ms_reg_db, tm1_30.ms_reg_id
34. 0.827 2.043 ↑ 1.0 900 1

Hash (cost=30.00..30.00 rows=900 width=17) (actual time=2.040..2.043 rows=900 loops=1)

  • Output: m1.reg_yy, m1.reg_db, m1.reg_id
  • Buckets: 1024 Batches: 1 Memory Usage: 52kB
  • Buffers: shared read=12
35. 0.259 1.216 ↑ 1.0 900 1

Append (cost=0.00..30.00 rows=900 width=17) (actual time=0.029..1.216 rows=900 loops=1)

  • Buffers: shared read=12
36. 0.325 0.325 ↑ 1.0 300 1

Seq Scan on public.meisai1_p_m1_2017 m1 (cost=0.00..8.50 rows=300 width=17) (actual time=0.028..0.325 rows=300 loops=1)

  • Output: m1.reg_yy, m1.reg_db, m1.reg_id
  • Filter: ((m1.reg_yy >= '2017'::numeric) AND (m1.reg_yy <= '2019'::numeric))
  • Buffers: shared read=4
37. 0.324 0.324 ↑ 1.0 300 1

Seq Scan on public.meisai1_p_m1_2018 m1_1 (cost=0.00..8.50 rows=300 width=17) (actual time=0.024..0.324 rows=300 loops=1)

  • Output: m1_1.reg_yy, m1_1.reg_db, m1_1.reg_id
  • Filter: ((m1_1.reg_yy >= '2017'::numeric) AND (m1_1.reg_yy <= '2019'::numeric))
  • Buffers: shared read=4
38. 0.308 0.308 ↑ 1.0 300 1

Seq Scan on public.meisai1_p_m1_2019 m1_2 (cost=0.00..8.50 rows=300 width=17) (actual time=0.025..0.308 rows=300 loops=1)

  • Output: m1_2.reg_yy, m1_2.reg_db, m1_2.reg_id
  • Filter: ((m1_2.reg_yy >= '2017'::numeric) AND (m1_2.reg_yy <= '2019'::numeric))
  • Buffers: shared read=4