explain.depesz.com

PostgreSQL's explain analyze made readable

Result: APPt

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 0.958 ↑ 1.0 100 1

Limit (cost=36,100.05..45,124.85 rows=100 width=22) (actual time=0.860..0.958 rows=100 loops=1)

2. 0.147 0.924 ↑ 1,441.6 500 1

Nested Loop (cost=0.85..65,050,301.86 rows=720,795 width=22) (actual time=0.489..0.924 rows=500 loops=1)

3. 0.233 0.233 ↑ 58,843.1 16 1

Index Scan using herald_acti_timesta_30b16c_idx on herald_activity (cost=0.42..49,432.96 rows=941,490 width=12) (actual time=0.104..0.233 rows=16 loops=1)

4. 0.544 0.544 ↑ 80.5 31 16

Index Scan using herald_notification_activity_id_fac2d24d on herald_notification (cost=0.42..44.10 rows=2,494 width=14) (actual time=0.015..0.034 rows=31 loops=16)

  • Index Cond: (activity_id = herald_activity.id)
Planning time : 1.480 ms
Execution time : 1.051 ms