explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BqKB

Settings
# exclusive inclusive rows x rows loops node
1. 9,740.299 44,299.961 ↑ 6.7 30 1

GroupAggregate (cost=169,369,399.47..172,684,768.97 rows=200 width=16) (actual time=34,468.994..44,299.961 rows=30 loops=1)

  • Group Key: (generate_series(date_trunc('day'::text, date_trunc('day'::text, (now() - '29 days'::interval))), now(), ('1 day'::cstring)::interval))
2. 2,565.031 34,559.662 ↑ 148.8 2,970,051 1

Sort (cost=169,369,399.47..170,474,521.97 rows=442,049,000 width=45) (actual time=33,735.401..34,559.662 rows=2,970,051 loops=1)

  • Sort Key: (generate_series(date_trunc('day'::text, date_trunc('day'::text, (now() - '29 days'::interval))), now(), ('1 day'::cstring)::interval))
  • Sort Method: external sort Disk: 159688kB
3. 1,315.393 31,994.631 ↑ 148.8 2,970,051 1

Nested Loop Left Join (cost=0.45..51,499,220.52 rows=442,049,000 width=45) (actual time=0.106..31,994.631 rows=2,970,051 loops=1)

4. 0.128 0.128 ↑ 33.3 30 1

Result (cost=0.00..5.03 rows=1,000 width=8) (actual time=0.011..0.128 rows=30 loops=1)

5. 30,679.110 30,679.110 ↑ 4.5 99,002 30

Index Scan using idx_javascript_pages_timestamp_los_angeles on pages (cost=0.45..47,078.72 rows=442,049 width=45) (actual time=0.064..1,022.637 rows=99,002 loops=30)

  • Index Cond: (lower(tsrange(timezone('America/Los_Angeles'::text, (generate_series(date_trunc('day'::text, date_trunc('day'::text, (now() - '29 days'::interval))), now(), ('1 day'::cstring)::interval))), (timezone('America/Los_Angeles'::text, (generate_series(date_trunc('day'::text, date_trunc('day'::text, (now() - '29 days'::interval))), now(), ('1 day'::cstring)::interval))) + ('1 day'::cstring)::interval))) < timezone('America/Los_Angeles'::text, "timestamp"))
  • Filter: ((path ~~* '/book/%'::text) OR (path ~~* '/booking/%'::text) OR (path ~~* '/wedding/%'::text) OR (path ~~* '/picturepeople/%'::text))
  • Rows Removed by Filter: 157354