explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GnSy

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

Limit (cost=53,858.05..53,858.07 rows=10 width=390) (actual rows= loops=)

  • -> Seq Scan on card_analytics_stream_state card_analytics_stream_state_1 (cost=0.00..30.40 row
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=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=53,797.25..53,830.91 rows=13,467 width=390) (actual rows= loops=)

  • Sort Key: analytics_event.created
5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on analytics_event (cost=1,094.77..53,506.23 rows=13,467 width=390) (actual rows= loops=)

  • Recheck Cond: ((payload ->> 'analyticsEvent'::text) = ANY ('{card-cancelled,card-dismi
  • Filter: (($0 IS NULL) OR (created > $1))
  • -> Bitmap Index Scan on analytics_event_payload_event (cost=0.00..1091.40 rows=40,000
  • Index Cond: ((payload ->> 'analyticsEvent'::text) = ANY ('{card-cancelled,card-d