explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OqxR

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

Nested Loop (cost=0.28..43,638,804.33 rows=1 width=111) (actual rows= loops=)

  • Join Filter: (ip_risk.ip_risk_list_id = ip_risk_list.id)
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..43,638,803.12 rows=1 width=96) (actual rows= loops=)

  • Join Filter: (ip_risk.ip <<= bad_login.client_ip)
3. 0.000 0.000 ↓ 0.0

Index Scan using ix_client_ip on bad_login (cost=0.28..77.02 rows=2,037 width=94) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..30,531.80 rows=1,427,320 width=9) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on ip_risk (cost=0.00..23,395.20 rows=1,427,320 width=9) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on ip_risk_list (cost=0.00..1.09 rows=9 width=19) (actual rows= loops=)