explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FSoX

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

Update on api_payload_collection api (cost=0.00..1,097,755,993.36 rows=6,793 width=1,769) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on api_payload_collection api (cost=0.00..1,097,755,993.36 rows=6,793 width=1,769) (actual rows= loops=)

  • Filter: (user_name IS NOT NULL)
3.          

SubPlan (for Seq Scan)

4. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..161,600.57 rows=1 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on eqx_user u (cost=0.00..161,600.57 rows=1 width=8) (actual rows= loops=)

  • Filter: (((api.user_name)::text = (user_name)::text) AND ((status)::text = 'ACTIVE'::text))