explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vfs

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.436 ↑ 23.0 1 1

Append (cost=0.14..43.19 rows=23 width=4) (actual time=0.415..0.436 rows=1 loops=1)

2. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using agent_event_2018_03_01_7ba0b567 on agent_event_2018_03_01 (cost=0.14..2.36 rows=1 width=4) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
3. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using agent_event_2018_04_01_f516e4ca on agent_event_2018_04_01 (cost=0.14..2.36 rows=1 width=4) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
4. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on agent_event_2018_05_01 (cost=0.00..1.23 rows=1 width=4) (actual time=0.019..0.019 rows=0 loops=1)

  • Filter: (id = 1944642956)
  • Rows Removed by Filter: 18
5. 0.014 0.014 ↓ 0.0 0 1

Index Only Scan using agent_event_2018_06_01_75ab2ceb on agent_event_2018_06_01 (cost=0.14..1.26 rows=1 width=4) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
6. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using agent_event_2018_07_01_3b687718 on agent_event_2018_07_01 (cost=0.14..1.26 rows=1 width=4) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
7. 0.007 0.007 ↓ 0.0 0 1

Index Only Scan using agent_event_2018_08_01_594c1cef on agent_event_2018_08_01 (cost=0.14..2.36 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
8. 0.006 0.006 ↓ 0.0 0 1

Index Only Scan using agent_event_2018_09_01_c85b68f4 on agent_event_2018_09_01 (cost=0.14..2.36 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
9. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on agent_event_2018_10_01 (cost=0.00..1.05 rows=1 width=4) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (id = 1944642956)
  • Rows Removed by Filter: 4
10. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan using agent_event_2018_11_01_b1faba8e on agent_event_2018_11_01 (cost=0.28..1.40 rows=1 width=4) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
11. 0.013 0.013 ↓ 0.0 0 1

Index Only Scan using agent_event_2018_12_01_606cfb84 on agent_event_2018_12_01 (cost=0.28..1.40 rows=1 width=4) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
12. 0.028 0.028 ↓ 0.0 0 1

Index Only Scan using agent_event_2019_01_01_ac3eac13 on agent_event_2019_01_01 (cost=0.28..1.40 rows=1 width=4) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
13. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using agent_event_2019_02_01_37d6c88d on agent_event_2019_02_01 (cost=0.29..2.50 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
14. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan using agent_event_2019_03_01_c55bf703 on agent_event_2019_03_01 (cost=0.44..1.56 rows=1 width=4) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
15. 0.023 0.023 ↓ 0.0 0 1

Index Only Scan using agent_event_2019_04_01_e7d23fce on agent_event_2019_04_01 (cost=0.57..1.69 rows=1 width=4) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
16. 0.035 0.035 ↓ 0.0 0 1

Index Only Scan using agent_event_2019_05_01_fd5fee9a on agent_event_2019_05_01 (cost=0.57..1.69 rows=1 width=4) (actual time=0.035..0.035 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
17. 0.018 0.018 ↓ 0.0 0 1

Index Only Scan using agent_event_2019_06_01_a1209046 on agent_event_2019_06_01 (cost=0.57..1.69 rows=1 width=4) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
18. 0.032 0.032 ↓ 0.0 0 1

Index Only Scan using agent_event_2019_07_01_4b283618 on agent_event_2019_07_01 (cost=0.57..1.69 rows=1 width=4) (actual time=0.032..0.032 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
19. 0.036 0.036 ↓ 0.0 0 1

Index Only Scan using agent_event_2019_08_01_8d8d7186 on agent_event_2019_08_01 (cost=0.57..1.69 rows=1 width=4) (actual time=0.036..0.036 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
20. 0.023 0.023 ↓ 0.0 0 1

Index Only Scan using agent_event_2019_09_01_dc7013d5 on agent_event_2019_09_01 (cost=0.57..2.79 rows=1 width=4) (actual time=0.023..0.023 rows=0 loops=1)

  • Heap Fetches: 0
21. 0.019 0.019 ↓ 0.0 0 1

Index Only Scan using agent_event_2019_10_01_53e6aefd on agent_event_2019_10_01 (cost=0.57..2.79 rows=1 width=4) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
22. 0.069 0.069 ↑ 1.0 1 1

Index Only Scan using agent_event_2019_11_01_939b3e7c on agent_event_2019_11_01 (cost=0.57..2.79 rows=1 width=4) (actual time=0.068..0.069 rows=1 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 1
23. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using agent_event_2019_12_01_1ecaadf1 on agent_event_2019_12_01 (cost=0.14..2.36 rows=1 width=4) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0
24. 0.012 0.012 ↓ 0.0 0 1

Index Only Scan using agent_event_default_a189e9b6 on agent_event_default (cost=0.29..1.41 rows=1 width=4) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (id = 1944642956)
  • Heap Fetches: 0