explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I1Iu : Optimization for: plan #cCvm

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.957 25.577 ↓ 2.8 4,199 1

Sort (cost=5,513.06..5,516.85 rows=1,516 width=77) (actual time=25.211..25.577 rows=4,199 loops=1)

  • Sort Key: e.id
  • Sort Method: quicksort Memory: 783kB
2. 0.596 23.620 ↓ 2.8 4,199 1

Result (cost=0.00..5,432.97 rows=1,516 width=77) (actual time=0.060..23.620 rows=4,199 loops=1)

3. 0.257 23.024 ↓ 2.8 4,199 1

Append (cost=0.00..5,417.81 rows=1,516 width=76) (actual time=0.059..23.024 rows=4,199 loops=1)

4. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on event e (cost=0.00..0.00 rows=1 width=76) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((NOT acknowledged) AND (event_time_utc > '2019-01-31 02:25:18.758383'::timestamp without time zone) AND (create_time_utc > '2019-03-11 02:25:18.758383'::timestamp without time zone) AND (confirmation_state = 'pending'::enum_confirmation_state))
5. 0.179 0.179 ↑ 1.6 74 1

Index Scan using i_event_2019m02_create_time on event_2019m02 e_1 (cost=0.42..1,130.37 rows=121 width=76) (actual time=0.057..0.179 rows=74 loops=1)

  • Index Cond: (create_time_utc > '2019-03-11 02:25:18.758383'::timestamp without time zone)
  • Filter: ((NOT acknowledged) AND (event_time_utc > '2019-01-31 02:25:18.758383'::timestamp without time zone) AND (confirmation_state = 'pending'::enum_confirmation_state))
  • Rows Removed by Filter: 32
6. 0.015 0.015 ↓ 0.0 0 1

Index Scan using i_event_2019m01_create_time on event_2019m01 e_2 (cost=0.42..102.53 rows=1 width=76) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (create_time_utc > '2019-03-11 02:25:18.758383'::timestamp without time zone)
  • Filter: ((NOT acknowledged) AND (event_time_utc > '2019-01-31 02:25:18.758383'::timestamp without time zone) AND (confirmation_state = 'pending'::enum_confirmation_state))
  • Rows Removed by Filter: 7
7. 22.572 22.572 ↓ 3.0 4,125 1

Index Scan using i_event_2019m03_unread on event_2019m03 e_3 (cost=0.29..4,184.90 rows=1,393 width=76) (actual time=15.245..22.572 rows=4,125 loops=1)

  • Filter: ((event_time_utc > '2019-01-31 02:25:18.758383'::timestamp without time zone) AND (create_time_utc > '2019-03-11 02:25:18.758383'::timestamp without time zone))
  • Rows Removed by Filter: 12781