explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MKIG

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

Aggregate (cost=85.12..85.14 rows=1 width=8) (actual time=3.976..3.977 rows=1 loops=1)

2. 3.810 3.810 ↑ 1.0 900 1

Append (cost=11.25..82.88 rows=900 width=0) (actual time=0.423..3.810 rows=900 loops=1)

3. 1.216 1.216 ↑ 1.0 300 1

Hash Join (cost=11.25..26.12 rows=300 width=0) (actual time=0.422..1.216 rows=300 loops=1)

4. 0.320 0.320 ↑ 1.0 300 1

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

5. 0.380 0.380 ↑ 1.0 300 1

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

6. 0.120 0.120 ↑ 1.0 300 1

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

7. 1.180 1.180 ↑ 1.0 300 1

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

8. 0.298 0.298 ↑ 1.0 300 1

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

9. 0.382 0.382 ↑ 1.0 300 1

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

10. 0.117 0.117 ↑ 1.0 300 1

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

11. 1.188 1.188 ↑ 1.0 300 1

Hash Join (cost=11.25..26.12 rows=300 width=0) (actual time=0.418..1.188 rows=300 loops=1)

12. 0.296 0.296 ↑ 1.0 300 1

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

13. 0.390 0.390 ↑ 1.0 300 1

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

14. 0.125 0.125 ↑ 1.0 300 1

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

Planning time : 12.087 ms
Execution time : 4.167 ms