explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FeQQ : explain

Settings
# exclusive inclusive rows x rows loops node
1. 255.967 4,462.417 ↓ 0.0 1 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=4,462.416..4,462.417 rows=1 loops=1)

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

Aggregate (cost=30,158,863.89..30,158,863.90 rows=1 width=8) (actual time=4,206.449..4,206.450 rows=1 loops=1)

  • JIT:
  • Functions: 101
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 15.977 ms, Inlining 10.957 ms, Optimization 1243.969 ms, Emission 703.083 ms, Total 1973.985 ms
3. 153.292 3,938.507 ↑ 2,022.1 737,157 1

Merge Left Join (cost=341,222.62..26,432,312.20 rows=1,490,620,674 width=18) (actual time=3,652.259..3,938.507 rows=737,157 loops=1)

  • Merge Cond: (s.cookie = ser.cookie)
  • Join Filter: (s.tenant_id = ser.tenant_id)
4. 753.932 3,465.211 ↑ 1.5 714,128 1

Sort (cost=291,563.04..294,176.93 rows=1,045,558 width=34) (actual time=3,326.005..3,465.211 rows=714,128 loops=1)

  • Sort Key: s.cookie
  • Sort Method: external merge Disk: 30760kB
5. 73.058 2,711.279 ↑ 1.5 714,128 1

Append (cost=0.00..158,437.47 rows=1,045,558 width=34) (actual time=2,428.170..2,711.279 rows=714,128 loops=1)

6. 1,962.667 1,962.667 ↓ 0.0 0 1

Seq Scan on sessions_p2020_01_103539 s (cost=0.00..1,379.93 rows=9,604 width=34) (actual time=1,962.667..1,962.667 rows=0 loops=1)

  • 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) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid) AND (uid = 'a7f8ff43-b37c-11e9-ad2e-06908fe445c6'::text))
  • Rows Removed by Filter: 28853
7. 96.945 96.945 ↓ 0.0 0 1

Seq Scan on sessions_p2020_02_103571 s_1 (cost=0.00..26,480.19 rows=182,488 width=34) (actual time=96.945..96.945 rows=0 loops=1)

  • 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) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid) AND (uid = 'a7f8ff43-b37c-11e9-ad2e-06908fe445c6'::text))
  • Rows Removed by Filter: 547554
8. 105.379 105.379 ↓ 0.0 0 1

Seq Scan on sessions_p2020_03_103603 s_2 (cost=0.00..27,646.61 rows=189,307 width=34) (actual time=105.379..105.379 rows=0 loops=1)

  • 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) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid) AND (uid = 'a7f8ff43-b37c-11e9-ad2e-06908fe445c6'::text))
  • Rows Removed by Filter: 568149
9. 263.119 263.119 ↓ 0.0 0 1

Seq Scan on sessions_p2020_04_103635 s_3 (cost=0.00..56,965.26 rows=387,629 width=34) (actual time=263.119..263.119 rows=0 loops=1)

  • 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) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid) AND (uid = 'a7f8ff43-b37c-11e9-ad2e-06908fe445c6'::text))
  • Rows Removed by Filter: 1163183
10. 210.088 210.088 ↓ 2.6 714,128 1

Seq Scan on sessions_p2020_05_103667 s_4 (cost=0.00..40,684.90 rows=276,525 width=34) (actual time=0.053..210.088 rows=714,128 loops=1)

  • 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) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid) AND (uid = 'a7f8ff43-b37c-11e9-ad2e-06908fe445c6'::text))
  • Rows Removed by Filter: 115695
11. 0.012 0.012 ↓ 0.0 0 1

Index Scan using sessions_p2020_06_pkey_103699 on sessions_p2020_06_103699 s_5 (cost=0.14..10.56 rows=1 width=48) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((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. 0.003 0.003 ↓ 0.0 0 1

Index Scan using sessions_p2020_07_pkey_103731 on sessions_p2020_07_103731 s_6 (cost=0.14..10.56 rows=1 width=48) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((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. 0.003 0.003 ↓ 0.0 0 1

Index Scan using sessions_p2020_08_pkey_103763 on sessions_p2020_08_103763 s_7 (cost=0.14..10.56 rows=1 width=48) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((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. 0.002 0.002 ↓ 0.0 0 1

Index Scan using sessions_p2020_09_pkey_103795 on sessions_p2020_09_103795 s_8 (cost=0.14..10.56 rows=1 width=48) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((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. 0.003 0.003 ↓ 0.0 0 1

Index Scan using sessions_default_pkey_103827 on sessions_default_103827 s_9 (cost=0.14..10.56 rows=1 width=48) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((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)
16. 182.759 320.004 ↑ 1.0 285,130 1

Sort (cost=49,659.58..50,372.42 rows=285,134 width=34) (actual time=291.960..320.004 rows=285,130 loops=1)

  • Sort Key: ser.cookie
  • Sort Method: quicksort Memory: 29838kB
17. 29.565 137.245 ↑ 1.0 285,130 1

Append (cost=0.00..23,824.62 rows=285,134 width=34) (actual time=0.020..137.245 rows=285,130 loops=1)

18. 1.963 1.963 ↑ 1.0 4,979 1

Seq Scan on searches_p2020_01_103891 ser (cost=0.00..385.24 rows=4,979 width=34) (actual time=0.019..1.963 rows=4,979 loops=1)

  • Filter: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
19. 29.600 29.600 ↑ 1.0 77,751 1

Seq Scan on searches_p2020_02_103923 ser_1 (cost=0.00..6,066.89 rows=77,751 width=34) (actual time=0.079..29.600 rows=77,751 loops=1)

  • Filter: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
20. 28.733 28.733 ↑ 1.0 76,810 1

Seq Scan on searches_p2020_03_103955 ser_2 (cost=0.00..6,041.12 rows=76,810 width=34) (actual time=0.043..28.733 rows=76,810 loops=1)

  • Filter: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
21. 29.207 29.207 ↑ 1.0 79,689 1

Seq Scan on searches_p2020_04_103987 ser_3 (cost=0.00..6,275.11 rows=79,689 width=34) (actual time=0.029..29.207 rows=79,689 loops=1)

  • Filter: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
22. 17.850 17.850 ↑ 1.0 45,119 1

Seq Scan on searches_p2020_05_104019 ser_4 (cost=0.00..3,548.99 rows=45,119 width=34) (actual time=0.023..17.850 rows=45,119 loops=1)

  • Filter: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
23. 0.010 0.010 ↓ 0.0 0 1

Index Scan using searches_p2020_06_pkey_104051 on searches_p2020_06_104051 ser_5 (cost=0.14..9.21 rows=1 width=48) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
24. 0.004 0.004 ↓ 0.0 0 1

Index Scan using searches_p2020_07_pkey_104083 on searches_p2020_07_104083 ser_6 (cost=0.14..9.21 rows=1 width=48) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
25. 0.003 0.003 ↓ 0.0 0 1

Index Scan using searches_p2020_08_pkey_104115 on searches_p2020_08_104115 ser_7 (cost=0.14..9.21 rows=1 width=48) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
26. 0.003 0.003 ↓ 0.0 0 1

Index Scan using searches_p2020_09_pkey_104147 on searches_p2020_09_104147 ser_8 (cost=0.14..9.21 rows=1 width=48) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
27. 0.307 0.307 ↑ 1.0 782 1

Seq Scan on searches_default_104179 ser_9 (cost=0.00..44.77 rows=782 width=34) (actual time=0.021..0.307 rows=782 loops=1)

  • Filter: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
Planning time : 0.284 ms
Execution time : 4,462.438 ms