explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I82E

Settings
# exclusive inclusive rows x rows loops node
1. 5.907 35,733.429 ↓ 24.4 3,783 1

Sort (cost=542,110.73..542,111.11 rows=155 width=26) (actual time=35,733.128..35,733.429 rows=3,783 loops=1)

  • Sort Key: (count(DISTINCT host_name)), asn_organisation
  • Sort Method: quicksort Memory: 402kB
  • Total runtime: 35747.261 ms
2. 10,826.203 35,727.522 ↓ 24.4 3,783 1

GroupAggregate (cost=528,649.84..542,105.09 rows=155 width=26) (actual time=20,566.264..35,727.522 rows=3,783 loops=1)

3. 23,456.319 24,901.319 ↑ 1.0 1,786,806 1

Sort (cost=528,649.84..533,134.40 rows=1,793,827 width=26) (actual time=20,566.213..24,901.319 rows=1,786,806 loops=1)

  • Sort Key: asn_organisation
  • Sort Method: external merge Disk: 77592kB
4. 1,445.000 1,445.000 ↑ 1.0 1,786,806 1

Seq Scan on ip_address_lookup (cost=0.00..213,558.06 rows=1,793,827 width=26) (actual time=0.101..1,445.000 rows=1,786,806 loops=1)

  • Filter: (((host_name)::text ~~ 'www.%'::text) AND (asn <> 0))
  • Rows Removed by Filter: 4885877