explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iHXB

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

Limit (cost=64,230.83..64,231.99 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

Gather Merge (cost=64,170.03..65,479.35 rows=11,222 width=390) (actual rows= loops=)

  • Workers Planned: 2
  • Params Evaluated: $0, $1
5. 0.000 0.000 ↓ 0.0

Sort (cost=63,170.00..63,184.03 rows=5,611 width=390) (actual rows= loops=)

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

Parallel Seq Scan on analytics_event (cost=0.00..63,048.75 rows=5,611 width=390) (actual rows= loops=)

  • Filter: ((($0 IS NULL) OR (created > $1)) AND ((payload ->> 'analyticsEvent'::te