explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z2p1

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.146 ↓ 0.0 0 1

Append (cost=0.15..51.17 rows=20 width=40) (actual time=0.146..0.146 rows=0 loops=1)

2. 0.009 0.009 ↓ 0.0 0 1

Index Scan using message_y2016_id_idx on message_y2016 (cost=0.15..2.37 rows=1 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = 1)
3. 0.003 0.003 ↓ 0.0 0 1

Index Scan using message_y2017_id_idx on message_y2017 (cost=0.15..2.37 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (id = 1)
4. 0.002 0.002 ↓ 0.0 0 1

Index Scan using message_y2018_id_idx on message_y2018 (cost=0.15..2.37 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (id = 1)
5. 0.015 0.015 ↓ 0.0 0 1

Index Scan using message_y2019m1_id_idx on message_y2019m1 (cost=0.15..2.37 rows=1 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (id = 1)
6. 0.003 0.003 ↓ 0.0 0 1

Index Scan using message_y2019m2_id_idx on message_y2019m2 (cost=0.15..2.37 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (id = 1)
7. 0.002 0.002 ↓ 0.0 0 1

Index Scan using message_y2019m3_id_idx on message_y2019m3 (cost=0.15..2.37 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (id = 1)
8. 0.011 0.011 ↓ 0.0 0 1

Index Scan using message_y2019m4_id_idx on message_y2019m4 (cost=0.56..2.78 rows=1 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (id = 1)
9. 0.007 0.007 ↓ 0.0 0 1

Index Scan using message_y2019m5_id_idx on message_y2019m5 (cost=0.44..2.66 rows=1 width=40) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (id = 1)
10. 0.009 0.009 ↓ 0.0 0 1

Index Scan using message_y2019m6_id_idx on message_y2019m6 (cost=0.56..2.78 rows=1 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = 1)
11. 0.009 0.009 ↓ 0.0 0 1

Index Scan using message_y2019m9_id_idx on message_y2019m9 (cost=0.44..2.66 rows=1 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = 1)
12. 0.008 0.008 ↓ 0.0 0 1

Index Scan using message_y2019m10_id_idx on message_y2019m10 (cost=0.44..2.66 rows=1 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (id = 1)
13. 0.009 0.009 ↓ 0.0 0 1

Index Scan using message_y2019m11_id_idx on message_y2019m11 (cost=0.44..2.66 rows=1 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = 1)
14. 0.008 0.008 ↓ 0.0 0 1

Index Scan using message_y2019m12_id_idx on message_y2019m12 (cost=0.44..2.66 rows=1 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (id = 1)
15. 0.009 0.009 ↓ 0.0 0 1

Index Scan using message_y2020m1_id_idx on message_y2020m1 (cost=0.44..2.66 rows=1 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = 1)
16. 0.008 0.008 ↓ 0.0 0 1

Index Scan using message_y2020m2_id_idx on message_y2020m2 (cost=0.44..2.66 rows=1 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (id = 1)
17. 0.008 0.008 ↓ 0.0 0 1

Index Scan using message_y2020m3_id_idx on message_y2020m3 (cost=0.44..2.66 rows=1 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (id = 1)
18. 0.009 0.009 ↓ 0.0 0 1

Index Scan using message_y2020m4_id_idx on message_y2020m4 (cost=0.44..2.66 rows=1 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = 1)
19. 0.008 0.008 ↓ 0.0 0 1

Index Scan using message_y2020m5_id_idx on message_y2020m5 (cost=0.43..2.65 rows=1 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (id = 1)
20. 0.002 0.002 ↓ 0.0 0 1

Index Scan using message_y2020m6_id_idx on message_y2020m6 (cost=0.15..2.37 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (id = 1)
21. 0.003 0.003 ↓ 0.0 0 1

Index Scan using message_y2020m7_id_idx on message_y2020m7 (cost=0.15..2.37 rows=1 width=40) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (id = 1)
Planning time : 1.432 ms
Execution time : 0.358 ms