explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6R4T

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 1,023.646 ↓ 0.0 1 1

Aggregate (cost=0.00..0.00 rows=0 width=0) (actual time=1,023.646..1,023.646 rows=1 loops=1)

2. 1,023.616 1,023.631 ↓ 0.0 32 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=1,023.626..1,023.631 rows=32 loops=1)

  • Task Count: 32
  • Tasks Shown: One of 32
  • -> Task
  • Node: host=localhost port=9701 dbname=postgres
3. 0.002 0.015 ↑ 1.0 1 1

Aggregate (cost=63.38..63.38 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=1)

4. 0.000 0.013 ↓ 0.0 0 1

Append (cost=0.14..63.36 rows=6 width=0) (actual time=0.013..0.013 rows=0 loops=1)

5. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using sessions_p2020_01_pkey_103514 on sessions_p2020_01_103514 s (cost=0.14..10.55 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_time >= '2019-05-02 23:59:59'::timestamp without time zone) AND (start_time <= '2020-05-18 23:59:59'::timestamp without time zone))
  • Heap Fetches: 0
6. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using sessions_p2020_02_pkey_103546 on sessions_p2020_02_103546 s_1 (cost=0.14..10.55 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_time >= '2019-05-02 23:59:59'::timestamp without time zone) AND (start_time <= '2020-05-18 23:59:59'::timestamp without time zone))
  • Heap Fetches: 0
7. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using sessions_p2020_03_pkey_103578 on sessions_p2020_03_103578 s_2 (cost=0.14..10.55 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_time >= '2019-05-02 23:59:59'::timestamp without time zone) AND (start_time <= '2020-05-18 23:59:59'::timestamp without time zone))
  • Heap Fetches: 0
8. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using sessions_p2020_04_pkey_103610 on sessions_p2020_04_103610 s_3 (cost=0.14..10.55 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_time >= '2019-05-02 23:59:59'::timestamp without time zone) AND (start_time <= '2020-05-18 23:59:59'::timestamp without time zone))
  • Heap Fetches: 0
9. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using sessions_p2020_05_pkey_103642 on sessions_p2020_05_103642 s_4 (cost=0.14..10.55 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_time >= '2019-05-02 23:59:59'::timestamp without time zone) AND (start_time <= '2020-05-18 23:59:59'::timestamp without time zone))
  • Heap Fetches: 0
10. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using sessions_default_pkey_103802 on sessions_default_103802 s_5 (cost=0.14..10.55 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_time >= '2019-05-02 23:59:59'::timestamp without time zone) AND (start_time <= '2020-05-18 23:59:59'::timestamp without time zone))
  • Heap Fetches: 0
Planning time : 0.916 ms
Execution time : 1,023.680 ms