explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Vaw : Without index

Settings
# exclusive inclusive rows x rows loops node
1. 1.152 7,711.293 ↑ 1.0 100 1

Limit (cost=64,325.04..64,336.71 rows=100 width=390) (actual time=7,709.011..7,711.293 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.011 0.011 ↓ 0.0 0 1

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

5. 12.683 7,710.115 ↑ 112.2 100 1

Gather Merge (cost=64,264.24..65,573.57 rows=11,222 width=390) (actual time=7,708.912..7,710.115 rows=100 loops=1)

  • Workers Planned: 2
  • Params Evaluated: $0, $1
  • Workers Launched: 2
6. 3,658.639 7,697.432 ↑ 76.9 73 3 / 3

Sort (cost=63,264.22..63,278.25 rows=5,611 width=390) (actual time=7,696.922..7,697.432 rows=73 loops=3)

  • Sort Key: analytics_event.created
  • Sort Method: top-N heapsort Memory: 128kB
  • Worker 0: Sort Method: top-N heapsort Memory: 128kB
  • Worker 1: Sort Method: top-N heapsort Memory: 128kB
7. 4,038.793 4,038.793 ↓ 59.4 333,337 3 / 3

Parallel Seq Scan on analytics_event (cost=0.00..63,049.77 rows=5,611 width=390) (actual time=0.029..4,038.793 rows=333,337 loops=3)

  • 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.170 ms
Execution time : 7,712.387 ms