explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jexh

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

"QUERY PLAN" => "Limit (cost=53,921.73..53,921.98 rows=100 width=390) (actual rows= loops=)

  • ),
  • array(
  • "QUERY PLAN" => " InitPlan 1 (returns $0)
  • ),
  • array(
  • ),
  • array(
  • "QUERY PLAN" => " InitPlan 2 (returns $1)
  • ),
  • array(
  • ),
  • array(
  • ),
  • array(
  • "QUERY PLAN" => " Sort Key: analytics_event.created
  • ),
  • array(
  • ),
  • array(
  • "QUERY PLAN" => " Recheck Cond: ((payload ->> 'analyticsEvent'::text) = ANY ('{card-cancelled,card-dismissed,card-completed,card-snoozed,card-expired,card-displayed,card-voted-up,card-voted-down}'::text[]))
  • ),
  • array(
  • "QUERY PLAN" => " Filter: (($0 IS NULL) OR (created > $1))
  • ),
  • array(
  • ),
  • array(
  • "QUERY PLAN" => " Index Cond: ((payload ->> 'analyticsEvent'::text) = ANY ('{card-cancelled,card-dismissed,card-completed,card-snoozed,card-expired,card-displayed,card-voted-up,card-voted-down}'::text[]))
  • ));?>
2. 0.000 0.000 ↓ 0.0

"QUERY PLAN" => " -> Seq Scan on card_analytics_stream_state (cost=0.00..30.40 rows=2,040 width=8) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

"QUERY PLAN" => " -> Seq Scan on card_analytics_stream_state card_analytics_stream_state_1 (cost=0.00..30.40 rows=2,040 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

"QUERY PLAN" => " -> Sort (cost=53,860.93..53,894.59 rows=13,467 width=390) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

"QUERY PLAN" => " -> Bitmap Heap Scan on analytics_event (cost=934.77..53,346.23 rows=13,467 width=390) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

"QUERY PLAN" => " -> Bitmap Index Scan on analytics_event_payload_event (cost=0.00..931.40 rows=40,000 width=0) (actual rows= loops=)