explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cTvX

Settings
# exclusive inclusive rows x rows loops node
1. 1,496.132 46,052.861 ↓ 352.9 70,589 1

Sort (cost=1,095,638.65..1,095,639.15 rows=200 width=184) (actual time=45,477.747..46,052.861 rows=70,589 loops=1)

  • Sort Key: (CASE WHEN (((t.data).uri) ~ '^(?:http[s]?://.*)$'::text) THEN ((t.data).uri) ELSE concat(((t.data).host), ((t.data).uri)) END) DESC
  • Sort Method: external merge Disk: 20504kB
2. 562.727 44,556.729 ↓ 352.9 70,589 1

HashAggregate (cost=1,095,627.51..1,095,631.01 rows=200 width=184) (actual time=44,410.735..44,556.729 rows=70,589 loops=1)

  • Group Key: (t.data).method, (t.data).uri, (t.data).host, (t.data).status
3. 265.624 43,994.002 ↑ 52.6 278,877 1

Subquery Scan on t (cost=0.00..802,183.81 rows=14,672,185 width=160) (actual time=0.993..43,994.002 rows=278,877 loops=1)

  • Filter: (((t.data).method IS NOT NULL) AND ((t.data).uri IS NOT NULL) AND ((t.data).host IS NOT NULL) AND ((t.data).status IS NOT NULL) AND ((t.data).metric >= '0'::double precision))
  • Rows Removed by Filter: 100633
4. 43,486.723 43,728.378 ↑ 118.3 379,510 1

ProjectSet (cost=0.00..240,833.81 rows=44,908,000 width=32) (actual time=0.965..43,728.378 rows=379,510 loops=1)

5. 241.655 241.655 ↓ 1.5 67,101 1

Seq Scan on http100000 f (cost=0.00..15,957.00 rows=44,908 width=478) (actual time=0.900..241.655 rows=67,101 loops=1)

  • Filter: ((src_app IS NOT NULL) AND (dst_app IS NOT NULL) AND ((service)::text = ANY ('{HTTP,HTTPS}'::text[])))
  • Rows Removed by Filter: 32899