explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GFQd

Settings
# exclusive inclusive rows x rows loops node
1. 1,417.767 8,346.700 ↓ 0.0 1 1

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

2. 6,928.923 6,928.933 ↓ 0.0 3,137,631 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=6,553.152..6,928.933 rows=3,137,631 loops=1)

  • Task Count: 32
  • Tasks Shown: One of 32
  • -> Task
  • Node: host=localhost port=9,701 dbname=postgres
3. 0.001 0.010 ↓ 0.0 0 1

HashAggregate (cost=136.00..138.00 rows=200 width=32) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: s.md5_cookie_uid
4. 0.001 0.009 ↓ 0.0 0 1

Append (cost=0.00..134.00 rows=800 width=32) (actual time=0.009..0.009 rows=0 loops=1)

5. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on sessions_p2020_01_149410 s (cost=0.00..13.00 rows=80 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: "overlaps"(start_time, end_time, '2020-01-01 00:00:00'::timestamp without time zone, '2020-06-26 00:00:00'::timestamp without time zone)
6. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on sessions_p2020_02_149442 s_1 (cost=0.00..13.00 rows=80 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: "overlaps"(start_time, end_time, '2020-01-01 00:00:00'::timestamp without time zone, '2020-06-26 00:00:00'::timestamp without time zone)
7. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on sessions_p2020_03_149474 s_2 (cost=0.00..13.00 rows=80 width=32) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: "overlaps"(start_time, end_time, '2020-01-01 00:00:00'::timestamp without time zone, '2020-06-26 00:00:00'::timestamp without time zone)
8. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on sessions_p2020_04_149506 s_3 (cost=0.00..13.00 rows=80 width=32) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: "overlaps"(start_time, end_time, '2020-01-01 00:00:00'::timestamp without time zone, '2020-06-26 00:00:00'::timestamp without time zone)
9. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on sessions_p2020_05_149538 s_4 (cost=0.00..13.00 rows=80 width=32) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: "overlaps"(start_time, end_time, '2020-01-01 00:00:00'::timestamp without time zone, '2020-06-26 00:00:00'::timestamp without time zone)
10. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on sessions_p2020_06_149570 s_5 (cost=0.00..13.00 rows=80 width=32) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: "overlaps"(start_time, end_time, '2020-01-01 00:00:00'::timestamp without time zone, '2020-06-26 00:00:00'::timestamp without time zone)
11. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on sessions_p2020_07_149602 s_6 (cost=0.00..13.00 rows=80 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: "overlaps"(start_time, end_time, '2020-01-01 00:00:00'::timestamp without time zone, '2020-06-26 00:00:00'::timestamp without time zone)
12. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on sessions_p2020_08_149634 s_7 (cost=0.00..13.00 rows=80 width=32) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: "overlaps"(start_time, end_time, '2020-01-01 00:00:00'::timestamp without time zone, '2020-06-26 00:00:00'::timestamp without time zone)
13. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on sessions_p2020_09_149666 s_8 (cost=0.00..13.00 rows=80 width=32) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: "overlaps"(start_time, end_time, '2020-01-01 00:00:00'::timestamp without time zone, '2020-06-26 00:00:00'::timestamp without time zone)
14. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on sessions_default_149698 s_9 (cost=0.00..13.00 rows=80 width=32) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: "overlaps"(start_time, end_time, '2020-01-01 00:00:00'::timestamp without time zone, '2020-06-26 00:00:00'::timestamp without time zone)
Planning time : 0.620 ms
Execution time : 8,371.527 ms