explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nuj4

Settings
# exclusive inclusive rows x rows loops node
1. 29.357 662.943 ↑ 1.0 1 1

Aggregate (cost=21,024.16..21,024.17 rows=1 width=8) (actual time=662.942..662.943 rows=1 loops=1)

2. 633.586 633.586 ↓ 5.4 117,952 1

Index Only Scan using traffic_sessions_end_index on traffic_sessions (cost=0.43..20,970.03 rows=21,652 width=0) (actual time=1.111..633.586 rows=117,952 loops=1)

  • Index Cond: (("end" >= '2019-09-26 06:00:00+00'::timestamp with time zone) AND ("end" <= '2019-09-28 05:59:59.999+00'::timestamp with time zone))
  • Heap Fetches: 117,952
Planning time : 5.951 ms
Execution time : 663.356 ms