explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kBQb2

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.288 ↓ 0.0 0 1

Limit (cost=0.00..8.68 rows=1 width=36) (actual time=0.288..0.288 rows=0 loops=1)

2. 0.284 0.284 ↓ 0.0 0 1

Seq Scan on user_journeys (cost=0.00..8.68 rows=1 width=36) (actual time=0.284..0.284 rows=0 loops=1)

  • Filter: ((created_at > '2020-03-26 14:49:26.295639+07'::timestamp with time zone) AND (created_at < '2020-03-29 14:49:26.295639+07'::timestamp with time zone) AND (user_id = 9551811) AND (journey_type = 'noti_group_promotion_active'::enum_user_journey_type))
  • Rows Removed by Filter: 284
Planning time : 1.786 ms
Execution time : 58.663 ms