explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sFX6

Settings
# exclusive inclusive rows x rows loops node
1. 4,763.245 6,617.233 ↓ 1.0 30,859,158 1

Nested Loop (cost=0.00..386,969.00 rows=30,839,880 width=332) (actual time=0.032..6,617.233 rows=30,859,158 loops=1)

2. 20.662 20.662 ↑ 1.0 10,978 1

Seq Scan on profile_states a (cost=0.00..1,312.00 rows=11,030 width=332) (actual time=0.018..20.662 rows=10,978 loops=1)

  • Filter: (profile_uuid = 'deadbeef-af6f-4a77-bdd6-97f939e7cf07'::uuid)
  • Rows Removed by Filter: 9744
3. 1,832.379 1,833.326 ↓ 1.0 2,811 10,978

Materialize (cost=0.00..165.49 rows=2,796 width=16) (actual time=0.000..0.167 rows=2,811 loops=10,978)

4. 0.947 0.947 ↓ 1.0 2,811 1

Seq Scan on profiles b (cost=0.00..151.51 rows=2,796 width=16) (actual time=0.009..0.947 rows=2,811 loops=1)

  • Filter: (uuid = 'deadbeef-af6f-4a77-bdd6-97f939e7cf07'::uuid)
  • Rows Removed by Filter: 3528
Planning time : 0.235 ms
Execution time : 8,049.316 ms