explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qtVa

Settings
# exclusive inclusive rows x rows loops node
1. 18.434 465.788 ↑ 15.6 866 1

Unique (cost=6,442.69..7,693.66 rows=13,524 width=711) (actual time=404.336..465.788 rows=866 loops=1)

2. 429.138 447.354 ↑ 1.0 13,524 1

Sort (cost=6,442.69..6,476.50 rows=13,524 width=711) (actual time=404.326..447.354 rows=13,524 loops=1)

  • Sort Key: show0_.show_guid, show0_.created_date, show0_.deleted_at, show0_.updated_date, show0_.alpha_sort_key, show0_.connect_info_email, show0_.connect_info_facebook, show0_.connect_info_phone, show0_.connect_info_twitter, show0_.curated_banners, show0_.disable_all_banners, show0_.disable_auto_banners, show0_.disable_recommendations, show0_.future_air_channel_id, show0_.future_air_duration, show0_.future_air_timestamp, show0_.hide_from_channel_list, show0_.human_entity_list, show0_.human_keyword_list, show0_.human_topic_list, show0_.is_placeholder_show, show0_.is_podcast, show0_.is_serializable, show0_.legacy_short_ids, show0_.live_video_eligible, show0_.long_description, show0_.long_title, show0_.machine_entity_list, show0_.machine_keyword_list, show0_.machine_topic_list, show0_.medium_title, show0_.program_type, show0_.short_description, show0_.show_pandora_id, show0_.show_type, show0_.valuable
  • Sort Method: external merge Disk: 6,952kB
3. 12.780 18.216 ↑ 1.0 13,524 1

Hash Join (cost=93.53..1,258.73 rows=13,524 width=711) (actual time=2.087..18.216 rows=13,524 loops=1)

  • Hash Cond: (aodepisode1_.show_guid = show0_.show_guid)
4. 3.390 3.390 ↑ 1.0 13,524 1

Seq Scan on aod_episode aodepisode1_ (cost=0.00..979.24 rows=13,524 width=37) (actual time=0.009..3.390 rows=13,524 loops=1)

  • Filter: (deleted_at IS NULL)
5. 1.278 2.046 ↑ 1.0 957 1

Hash (cost=81.57..81.57 rows=957 width=711) (actual time=2.046..2.046 rows=957 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 570kB
6. 0.768 0.768 ↑ 1.0 957 1

Seq Scan on show show0_ (cost=0.00..81.57 rows=957 width=711) (actual time=0.004..0.768 rows=957 loops=1)

  • Filter: ((deleted_at IS NULL) AND (deleted_at IS NULL))
Planning time : 2.204 ms
Execution time : 499.767 ms