explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1wtX

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.183 ↑ 1.0 2 1

Limit (cost=1.43..27.64 rows=2 width=292) (actual time=0.165..0.183 rows=2 loops=1)

2. 0.010 0.179 ↑ 131.5 2 1

Nested Loop (cost=1.43..3,447.84 rows=263 width=292) (actual time=0.164..0.179 rows=2 loops=1)

3. 0.007 0.147 ↑ 131.5 2 1

Nested Loop (cost=1.14..3,366.13 rows=263 width=189) (actual time=0.137..0.147 rows=2 loops=1)

4. 0.007 0.094 ↑ 131.5 2 1

Nested Loop (cost=0.85..3,354.54 rows=263 width=86) (actual time=0.088..0.094 rows=2 loops=1)

5. 0.045 0.045 ↑ 137.5 2 1

Index Scan using herald_notification_user_id_dccf7862 on herald_notification (cost=0.43..1,096.85 rows=275 width=14) (actual time=0.044..0.045 rows=2 loops=1)

  • Index Cond: (user_id = 8008)
6. 0.042 0.042 ↑ 1.0 1 2

Index Scan using herald_activity_pkey on herald_activity (cost=0.42..8.21 rows=1 width=72) (actual time=0.021..0.021 rows=1 loops=2)

  • Index Cond: (id = herald_notification.activity_id)
  • Filter: active
7. 0.012 0.046 ↑ 1.0 1 2

Materialize (cost=0.29..8.31 rows=1 width=103) (actual time=0.022..0.023 rows=1 loops=2)

8. 0.034 0.034 ↑ 1.0 1 1

Index Scan using herald_user_pkey on herald_user (cost=0.29..8.31 rows=1 width=103) (actual time=0.033..0.034 rows=1 loops=1)

  • Index Cond: (id = 8008)
9. 0.022 0.022 ↑ 1.0 1 2

Index Scan using herald_user_pkey on herald_user t4 (cost=0.29..0.31 rows=1 width=103) (actual time=0.011..0.011 rows=1 loops=2)

  • Index Cond: (id = herald_activity.actor_id)
Planning time : 2.904 ms
Execution time : 0.392 ms