explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m9Ut

Settings
# exclusive inclusive rows x rows loops node
1. 1,605.846 17,700.516 ↓ 352.7 70,545 1

Sort (cost=1,801,454.53..1,801,455.03 rows=200 width=156) (actual time=17,164.209..17,700.516 rows=70,545 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: 20592kB
2. 601.568 16,094.670 ↓ 352.7 70,545 1

HashAggregate (cost=1,801,442.39..1,801,446.89 rows=200 width=156) (actual time=15,887.830..16,094.670 rows=70,545 loops=1)

  • Group Key: (t.data).method, (t.data).uri, (t.data).host, (t.data).status
3. 145.150 15,493.102 ↑ 243.8 180,564 1

Subquery Scan on t (cost=0.00..701,028.54 rows=44,016,554 width=132) (actual time=2.664..15,493.102 rows=180,564 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))
  • Rows Removed by Filter: 99
4. 14,866.052 15,347.952 ↑ 248.6 180,663 1

ProjectSet (cost=0.00..251,948.54 rows=44,908,000 width=64) (actual time=2.629..15,347.952 rows=180,663 loops=1)

5. 481.900 481.900 ↓ 1.5 67,101 1

Seq Scan on http100000 f (cost=0.00..15,957.00 rows=44,908 width=478) (actual time=1.859..481.900 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