explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RJ7z

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3.809 ↑ 1.0 900 1

Append (cost=11.25..82.88 rows=900 width=17) (actual time=0.458..3.809 rows=900 loops=1)

2. 1.259 1.259 ↑ 1.0 300 1

Hash Join (cost=11.25..26.12 rows=300 width=17) (actual time=0.457..1.259 rows=300 loops=1)

3. 0.348 0.348 ↑ 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.025..0.348 rows=300 loops=1)

4. 0.391 0.391 ↑ 1.0 300 1

Hash (cost=6.00..6.00 rows=300 width=17) (actual time=0.390..0.391 rows=300 loops=1)

5. 0.127 0.127 ↑ 1.0 300 1

Seq Scan on public.tanka_meisai1_p_tm1_2017 tm1 (cost=0.00..6.00 rows=300 width=17) (actual time=0.008..0.127 rows=300 loops=1)

6. 1.151 1.151 ↑ 1.0 300 1

Hash Join (cost=11.25..26.12 rows=300 width=17) (actual time=0.403..1.151 rows=300 loops=1)

7. 0.283 0.283 ↑ 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.008..0.283 rows=300 loops=1)

8. 0.371 0.371 ↑ 1.0 300 1

Hash (cost=6.00..6.00 rows=300 width=17) (actual time=0.370..0.371 rows=300 loops=1)

9. 0.120 0.120 ↑ 1.0 300 1

Seq Scan on public.tanka_meisai1_p_tm1_2018 tm1_1 (cost=0.00..6.00 rows=300 width=17) (actual time=0.006..0.120 rows=300 loops=1)

10. 1.158 1.158 ↑ 1.0 300 1

Hash Join (cost=11.25..26.12 rows=300 width=17) (actual time=0.411..1.158 rows=300 loops=1)

11. 0.280 0.280 ↑ 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.007..0.280 rows=300 loops=1)

12. 0.376 0.376 ↑ 1.0 300 1

Hash (cost=6.00..6.00 rows=300 width=17) (actual time=0.376..0.376 rows=300 loops=1)

13. 0.121 0.121 ↑ 1.0 300 1

Seq Scan on public.tanka_meisai1_p_tm1_2019 tm1_2 (cost=0.00..6.00 rows=300 width=17) (actual time=0.006..0.121 rows=300 loops=1)