explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MOgX

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.524 ↓ 0.0 0 1

Append (cost=1.90..161.33 rows=100 width=40) (actual time=0.524..0.524 rows=0 loops=1)

2. 0.008 0.023 ↓ 0.0 0 1

Bitmap Heap Scan on message_y2016 (cost=1.90..6.13 rows=5 width=40) (actual time=0.023..0.023 rows=0 loops=1)

  • Recheck Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
3. 0.015 0.015 ↓ 0.0 0 1

Bitmap Index Scan on message_y2016_id_idx (cost=0.00..1.90 rows=5 width=0) (actual time=0.014..0.015 rows=0 loops=1)

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
4. 0.001 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on message_y2017 (cost=1.90..6.13 rows=5 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
5. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on message_y2017_id_idx (cost=0.00..1.90 rows=5 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
6. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on message_y2018 (cost=1.90..6.13 rows=5 width=40) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
7. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on message_y2018_id_idx (cost=0.00..1.90 rows=5 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
8. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on message_y2019m1 (cost=1.90..6.13 rows=5 width=40) (actual time=0.005..0.006 rows=0 loops=1)

  • Recheck Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
9. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on message_y2019m1_id_idx (cost=0.00..1.90 rows=5 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
10. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on message_y2019m2 (cost=1.90..6.13 rows=5 width=40) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
11. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on message_y2019m2_id_idx (cost=0.00..1.90 rows=5 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
12. 0.018 0.023 ↓ 0.0 0 1

Bitmap Heap Scan on message_y2019m3 (cost=1.90..6.13 rows=5 width=40) (actual time=0.023..0.023 rows=0 loops=1)

  • Recheck Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
13. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on message_y2019m3_id_idx (cost=0.00..1.90 rows=5 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
14. 0.039 0.039 ↓ 0.0 0 1

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

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
15. 0.031 0.031 ↓ 0.0 0 1

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

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
16. 0.036 0.036 ↓ 0.0 0 1

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

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
17. 0.032 0.032 ↓ 0.0 0 1

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

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
18. 0.023 0.023 ↓ 0.0 0 1

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

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
19. 0.027 0.027 ↓ 0.0 0 1

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

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
20. 0.046 0.046 ↓ 0.0 0 1

Index Scan using message_y2019m12_id_idx on message_y2019m12 (cost=0.44..8.90 rows=5 width=40) (actual time=0.045..0.046 rows=0 loops=1)

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
21. 0.044 0.044 ↓ 0.0 0 1

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

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
22. 0.033 0.033 ↓ 0.0 0 1

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

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
23. 0.042 0.042 ↓ 0.0 0 1

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

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
24. 0.051 0.051 ↓ 0.0 0 1

Index Scan using message_y2020m4_id_idx on message_y2020m4 (cost=0.44..8.91 rows=5 width=40) (actual time=0.050..0.051 rows=0 loops=1)

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
25. 0.028 0.028 ↓ 0.0 0 1

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

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
26. 0.002 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on message_y2020m6 (cost=1.90..6.13 rows=5 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
27. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on message_y2020m6_id_idx (cost=0.00..1.90 rows=5 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
28. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on message_y2020m7 (cost=1.90..6.13 rows=5 width=40) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
29. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on message_y2020m7_id_idx (cost=0.00..1.90 rows=5 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
Planning time : 2.409 ms
Execution time : 1.023 ms