explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6YKm

Settings
# exclusive inclusive rows x rows loops node
1. 467.503 993.249 ↓ 0.0 1 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=993.248..993.249 rows=1 loops=1)

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

Aggregate (cost=510,019.87..510,019.88 rows=1 width=8) (actual time=525.745..525.746 rows=1 loops=1)

  • JIT:
  • Functions: 10
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 2.656 ms, Inlining 11.402 ms, Optimization 147.919 ms, Emission 76.267 ms, Total 238.243 ms
3. 14.929 502.460 ↑ 3,628.1 37,894 1

Nested Loop (cost=0.42..166,312.23 rows=137,483,055 width=18) (actual time=235.965..502.460 rows=37,894 loops=1)

4. 256.609 256.609 ↑ 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=235.929..256.609 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. 230.922 230.922 ↑ 1.0 1 38,487

Index Only Scan using sessions_p2020_05_pkey_103667 on sessions_p2020_05_103667 s (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) 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: 37894
Planning time : 0.282 ms
Execution time : 993.296 ms