explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Piqo

Settings
# exclusive inclusive rows x rows loops node
1. 680.082 3,703.158 ↓ 0.0 1 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=3,703.157..3,703.158 rows=1 loops=1)

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

Aggregate (cost=20,586,272.01..20,586,272.02 rows=1 width=8) (actual time=3,023.076..3,023.076 rows=1 loops=1)

  • JIT:
  • Functions: 50
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 9.812 ms, Inlining 11.569 ms, Optimization 907.334 ms, Emission 493.667 ms, Total 1422.382 ms
3. 184.692 2,716.036 ↑ 1,380.9 737,049 1

Merge Left Join (cost=49,660.01..18,041,803.92 rows=1,017,787,239 width=18) (actual time=1,775.857..2,716.036 rows=737,049 loops=1)

  • Merge Cond: (s.cookie = ser.cookie)
  • Join Filter: (s.tenant_id = ser.tenant_id)
4. 2,176.319 2,176.319 ↓ 1.0 714,059 1

Index Only Scan using sessions_p2020_05_pkey_103667 on sessions_p2020_05_103667 s (cost=0.42..179,082.90 rows=713,901 width=34) (actual time=1,414.447..2,176.319 rows=714,059 loops=1)

  • Index Cond: ((uid = 'a7f8ff43-b37c-11e9-ad2e-06908fe445c6'::text) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid) AND (start_time >= '2020-05-02 00:00:00'::timestamp without time zone) AND (start_time <= '2020-05-18 00:00:00'::timestamp without time zone))
  • Heap Fetches: 714059
5. 197.213 355.025 ↑ 1.0 285,130 1

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

  • Sort Key: ser.cookie
  • Sort Method: quicksort Memory: 29838kB
6. 32.403 157.812 ↑ 1.0 285,130 1

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

7. 2.678 2.678 ↑ 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.058..2.678 rows=4,979 loops=1)

  • Filter: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
8. 33.826 33.826 ↑ 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.027..33.826 rows=77,751 loops=1)

  • Filter: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
9. 32.040 32.040 ↑ 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.031..32.040 rows=76,810 loops=1)

  • Filter: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
10. 34.519 34.519 ↑ 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.028..34.519 rows=79,689 loops=1)

  • Filter: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
11. 22.013 22.013 ↑ 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.026..22.013 rows=45,119 loops=1)

  • Filter: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
12. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
13. 0.003 0.003 ↓ 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.003 rows=0 loops=1)

  • Index Cond: (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid)
14. 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)
15. 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)
16. 0.312 0.312 ↑ 1.0 782 1

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

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