explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tALJ : With index, swapped order

Settings
# exclusive inclusive rows x rows loops node
1. 1.316 2.312 ↑ 1.0 100 1

Limit (cost=61.23..1,988.31 rows=100 width=390) (actual time=0.058..2.312 rows=100 loops=1)

2.          

Initplan (for Limit)

3. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on card_analytics_stream_state (cost=0.00..30.40 rows=2,040 width=8) (actual time=0.009..0.015 rows=0 loops=1)

4. 0.000 0.000 ↓ 0.0 0

Seq Scan on card_analytics_stream_state card_analytics_stream_state_1 (cost=0.00..30.40 rows=2,040 width=8) (never executed)

5. 0.981 0.981 ↑ 134.7 100 1

Index Scan using analytics_event_payload_event on analytics_event (cost=0.42..259,521.33 rows=13,467 width=390) (actual time=0.044..0.981 rows=100 loops=1)

  • Filter: ((($0 IS NULL) OR (created > $1)) AND ((payload ->> 'analyticsEvent'::text) = ANY ('{card-cancelled,card-dismissed,card-completed,card-snoozed,card-expired,card-displayed,card-voted-up,card-voted-down}'::text[])))
Planning time : 0.147 ms
Execution time : 3.192 ms