explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 28do

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=61.23..1,334.72 rows=100 width=390) (actual rows= loops=)

  • -> Seq Scan on card_analytics_stream_state card_analytics_stream_state_1 (cost=0.00..30.40 row
  • -> Index Scan using analytics_event_payload_event on analytics_event (cost=0.42..171501.64 rows=
  • Filter: ((($0 IS NULL) OR (created > $1)) AND ((payload ->> 'analyticsEvent'::text) = ANY ('
2.          

Initplan (for Limit)

3. 0.000 0.000 ↓ 0.0

Seq Scan on card_analytics_stream_state (cost=0.00..30.40 rows=2,040 width=8) (actual rows= loops=)