explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zs3k

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 2,140.464 ↑ 2.0 1 1

Unique (cost=365,196.75..365,196.77 rows=2 width=10) (actual time=2,140.428..2,140.464 rows=1 loops=1)

2. 0.000 2,140.438 ↓ 118.5 237 1

Sort (cost=365,196.75..365,196.76 rows=2 width=10) (actual time=2,140.427..2,140.438 rows=237 loops=1)

  • Sort Key: alias_pitch.entity_id, alias_pitch.to_vendor
  • Sort Method: quicksort Memory: 36kB
3. 3.880 2,141.675 ↓ 118.5 237 1

Gather (cost=1,004.46..365,196.74 rows=2 width=10) (actual time=0.364..2,141.675 rows=237 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 1,725.241 2,137.795 ↓ 79.0 79 3 / 3

Hash Join (cost=4.46..364,196.54 rows=1 width=10) (actual time=3.611..2,137.795 rows=79 loops=3)

  • Hash Cond: ((alias_pitch.to_vendor = ae.vendor) AND (CASE alias_pitch.to_vendor WHEN 'mlbam'::text THEN (alias_pitch.mlbam_game_pk)::text WHEN 'synergy'::text THEN alias_pitch.synergy_game_id WHEN 'bats'::text THEN alias_pitch.bats_game_id WHEN 'trackman_v3'::text THEN (alias_pitch.trackman_v3_game_uid)::text ELSE NULL::text END = ae.vendor_id))
5. 412.531 412.531 ↑ 1.2 4,320,863 3 / 3

Parallel Seq Scan on alias_pitch (cost=0.00..331,282.81 rows=5,265,481 width=88) (actual time=0.002..412.531 rows=4,320,863 loops=3)

6. 0.006 0.023 ↓ 3.0 3 3 / 3

Hash (cost=4.44..4.44 rows=1 width=20) (actual time=0.023..0.023 rows=3 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.017 0.017 ↓ 3.0 3 3 / 3

Index Scan using alias_entity_entity_id_vendor_idx on alias_entity ae (cost=0.42..4.44 rows=1 width=20) (actual time=0.014..0.017 rows=3 loops=3)

  • Index Cond: (entity_id = 2,801,499)
Planning time : 0.266 ms
Execution time : 2,141.802 ms