explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CaI3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 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)

2. 1.006 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)

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)

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)

5. 2.043 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)

6. 1.216 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)

7. 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)

8. 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)

9. 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)