explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q9G1 : 123

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.57..14,914,126,263.04 rows=298,276,263,188 width=7) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on tst_base_iplocation_kam1 (cost=0.00..5,657.14 rows=346,814 width=18) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using tst_base_iplocation_kam_start_ip_end_ip_idx on tst_base_iplocation_kam t1 (cost=0.57..34,402.76 rows=860,047 width=19) (actual rows= loops=)

  • Index Cond: (((tst_base_iplocation_kam1.common_met_ips)::inet >= start_ip) AND ((tst_base_iplocation_kam1.common_met_ips)::inet <= end_ip))