explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9tr2

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,907.403 ↓ 0.0 1 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=1,907.402..1,907.403 rows=1 loops=1)

  • Task Count: 1
  • Tasks Shown: All
  • -> Task
  • Node: host=localhost port=9701 dbname=postgres
2. 26.649 1,936.693 ↑ 1.0 1 1

Aggregate (cost=1,172,142.32..1,172,142.33 rows=1 width=8) (actual time=1,936.693..1,936.693 rows=1 loops=1)

  • JIT:
  • Functions: 77
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 11.167 ms, Inlining 10.966 ms, Optimization 555.903 ms, Emission 343.688 ms, Total 921.724 ms
3. 50.122 1,910.044 ↑ 5,310.5 37,916 1

Nested Loop (cost=0.41..668,758.42 rows=201,353,560 width=18) (actual time=911.699..1,910.044 rows=37,916 loops=1)

4. 936.234 936.234 ↑ 1.0 38,487 1

Seq Scan on searches_p2020_05_104019 ser (cost=0.00..3,774.58 rows=38,516 width=34) (actual time=911.585..936.234 rows=38,487 loops=1)

  • Filter: ((ts >= '2020-05-02 00:00:00'::timestamp without time zone) AND (ts <= '2020-05-18 00:00:00'::timestamp without time zone) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Rows Removed by Filter: 6632
5. 192.435 923.688 ↑ 10.0 1 38,487

Append (cost=0.41..17.17 rows=10 width=34) (actual time=0.018..0.024 rows=1 loops=38,487)

6. 76.974 76.974 ↓ 0.0 0 38,487

Index Scan using sessions_p2020_01_pkey_103539 on sessions_p2020_01_103539 s (cost=0.41..0.58 rows=1 width=34) (actual time=0.002..0.002 rows=0 loops=38,487)

  • Index Cond: ((cookie = ser.cookie) AND (uid = 'a7f8ff43-b37c-11e9-ad2e-06908fe445c6'::text) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Filter: "overlaps"(start_time, end_time, '2020-05-02 00:00:00'::timestamp without time zone, '2020-05-18 00:00:00'::timestamp without time zone)
7. 76.974 76.974 ↓ 0.0 0 38,487

Index Scan using sessions_p2020_02_pkey_103571 on sessions_p2020_02_103571 s_1 (cost=0.42..3.13 rows=1 width=34) (actual time=0.002..0.002 rows=0 loops=38,487)

  • Index Cond: ((cookie = ser.cookie) AND (uid = 'a7f8ff43-b37c-11e9-ad2e-06908fe445c6'::text) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Filter: "overlaps"(start_time, end_time, '2020-05-02 00:00:00'::timestamp without time zone, '2020-05-18 00:00:00'::timestamp without time zone)
8. 76.974 76.974 ↓ 0.0 0 38,487

Index Scan using sessions_p2020_03_pkey_103603 on sessions_p2020_03_103603 s_2 (cost=0.42..3.26 rows=1 width=34) (actual time=0.002..0.002 rows=0 loops=38,487)

  • Index Cond: ((cookie = ser.cookie) AND (uid = 'a7f8ff43-b37c-11e9-ad2e-06908fe445c6'::text) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Filter: "overlaps"(start_time, end_time, '2020-05-02 00:00:00'::timestamp without time zone, '2020-05-18 00:00:00'::timestamp without time zone)
9. 76.974 76.974 ↓ 0.0 0 38,487

Index Scan using sessions_p2020_04_pkey_103635 on sessions_p2020_04_103635 s_3 (cost=0.43..5.08 rows=1 width=34) (actual time=0.002..0.002 rows=0 loops=38,487)

  • Index Cond: ((cookie = ser.cookie) AND (uid = 'a7f8ff43-b37c-11e9-ad2e-06908fe445c6'::text) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Filter: "overlaps"(start_time, end_time, '2020-05-02 00:00:00'::timestamp without time zone, '2020-05-18 00:00:00'::timestamp without time zone)
10. 230.922 230.922 ↑ 1.0 1 38,487

Index Scan using sessions_p2020_05_pkey_103667 on sessions_p2020_05_103667 s_4 (cost=0.42..4.21 rows=1 width=34) (actual time=0.006..0.006 rows=1 loops=38,487)

  • Index Cond: ((cookie = ser.cookie) AND (uid = 'a7f8ff43-b37c-11e9-ad2e-06908fe445c6'::text) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Filter: "overlaps"(start_time, end_time, '2020-05-02 00:00:00'::timestamp without time zone, '2020-05-18 00:00:00'::timestamp without time zone)
11. 38.487 38.487 ↓ 0.0 0 38,487

Index Scan using sessions_p2020_06_pkey_103699 on sessions_p2020_06_103699 s_5 (cost=0.14..0.17 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=38,487)

  • Index Cond: ((cookie = ser.cookie) AND (uid = 'a7f8ff43-b37c-11e9-ad2e-06908fe445c6'::text) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Filter: "overlaps"(start_time, end_time, '2020-05-02 00:00:00'::timestamp without time zone, '2020-05-18 00:00:00'::timestamp without time zone)
12. 38.487 38.487 ↓ 0.0 0 38,487

Index Scan using sessions_p2020_07_pkey_103731 on sessions_p2020_07_103731 s_6 (cost=0.14..0.17 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=38,487)

  • Index Cond: ((cookie = ser.cookie) AND (uid = 'a7f8ff43-b37c-11e9-ad2e-06908fe445c6'::text) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Filter: "overlaps"(start_time, end_time, '2020-05-02 00:00:00'::timestamp without time zone, '2020-05-18 00:00:00'::timestamp without time zone)
13. 38.487 38.487 ↓ 0.0 0 38,487

Index Scan using sessions_p2020_08_pkey_103763 on sessions_p2020_08_103763 s_7 (cost=0.14..0.17 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=38,487)

  • Index Cond: ((cookie = ser.cookie) AND (uid = 'a7f8ff43-b37c-11e9-ad2e-06908fe445c6'::text) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Filter: "overlaps"(start_time, end_time, '2020-05-02 00:00:00'::timestamp without time zone, '2020-05-18 00:00:00'::timestamp without time zone)
14. 38.487 38.487 ↓ 0.0 0 38,487

Index Scan using sessions_p2020_09_pkey_103795 on sessions_p2020_09_103795 s_8 (cost=0.14..0.17 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=38,487)

  • Index Cond: ((cookie = ser.cookie) AND (uid = 'a7f8ff43-b37c-11e9-ad2e-06908fe445c6'::text) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Filter: "overlaps"(start_time, end_time, '2020-05-02 00:00:00'::timestamp without time zone, '2020-05-18 00:00:00'::timestamp without time zone)
15. 38.487 38.487 ↓ 0.0 0 38,487

Index Scan using sessions_default_pkey_103827 on sessions_default_103827 s_9 (cost=0.14..0.17 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=38,487)

  • Index Cond: ((cookie = ser.cookie) AND (uid = 'a7f8ff43-b37c-11e9-ad2e-06908fe445c6'::text) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Filter: "overlaps"(start_time, end_time, '2020-05-02 00:00:00'::timestamp without time zone, '2020-05-18 00:00:00'::timestamp without time zone)
Planning time : 0.270 ms
Execution time : 1,907.423 ms