explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MrtF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 10,176.362 ↑ 107.4 68 1

Gather Merge (cost=29,072.57..29,924.29 rows=7,300 width=1,312) (actual time=10,094.641..10,176.362 rows=68 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.414 29,259.714 ↑ 158.7 23 3

Sort (cost=28,072.54..28,081.67 rows=3,650 width=1,312) (actual time=9,753.232..9,753.238 rows=23 loops=3)

  • Sort Key: es.created_at
  • Sort Method: quicksort Memory: 50kB
  • Worker 0: Sort Method: quicksort Memory: 79kB
  • Worker 1: Sort Method: quicksort Memory: 33kB
3. 2,690.922 29,259.300 ↑ 158.7 23 3

Parallel Hash Anti Join (cost=3,851.61..25,770.58 rows=3,650 width=1,312) (actual time=5,768.953..9,753.100 rows=23 loops=3)

  • Hash Cond: (es.id = esp.event_stream_id)
4. 21,212.979 21,212.979 ↓ 1.2 36,914 3

Parallel Seq Scan on event_stream es (cost=0.00..21,771.89 rows=30,583 width=1,312) (actual time=0.306..7,070.993 rows=36,914 loops=3)

  • Filter: (((platform IS NULL) AND (sdk_version IS NULL)) OR (((platform)::text = 'android'::text) AND ((sdk_version)::text = ANY ('{1.4.3,1.4.4}'::text[]))))
  • Rows Removed by Filter: 4627
5. 2,274.159 5,355.399 ↑ 1.8 37,198 3

Parallel Hash (cost=3,027.94..3,027.94 rows=65,894 width=16) (actual time=1,785.132..1,785.133 rows=37,198 loops=3)

  • Buckets: 131072 Batches: 1 Memory Usage: 6304kB
6. 3,081.240 3,081.240 ↑ 1.8 37,198 3

Parallel Seq Scan on event_stream_processing esp (cost=0.00..3,027.94 rows=65,894 width=16) (actual time=0.013..1,027.080 rows=37,198 loops=3)

Planning time : 0.392 ms
Execution time : 10,176.437 ms