explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YX4m

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

Gather (cost=727,315.86..8,415,060.39 rows=94,724 width=250) (actual rows= loops=)

  • Output: lm.legacy_mappable_id, lm.remote_id, lm.metadata
  • Workers Planned: 4
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=726,315.86..8,404,587.99 rows=23,681 width=250) (actual rows= loops=)

  • Output: lm.legacy_mappable_id, lm.remote_id, lm.metadata
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=726,315.30..8,158,897.50 rows=412,427 width=8) (actual rows= loops=)

  • Output: upd.update_detail_id
  • Inner Unique: true
  • Hash Cond: (upd.update_stamp_id = ups.update_stamp_id)
4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on showtimes.update_detail upd (cost=0.00..6,968,499.63 rows=176,793,363 width=16) (actual rows= loops=)

  • Output: upd.update_detail_id, upd.update_type_id, upd.update_entity_id, upd.update_stamp_id, upd.comment, upd.automatic
5. 0.000 0.000 ↓ 0.0

Hash (cost=711,447.82..711,447.82 rows=1,189,398 width=8) (actual rows= loops=)

  • Output: ups.update_stamp_id
6. 0.000 0.000 ↓ 0.0

Index Scan using ix_dbo_update_stamp_6 on showtimes.update_stamp ups (cost=0.58..711,447.82 rows=1,189,398 width=8) (actual rows= loops=)

  • Output: ups.update_stamp_id
  • Index Cond: (ups.commit_dt >= (CURRENT_DATE - '1 day'::interval))
7. 0.000 0.000 ↓ 0.0

Index Scan using ix_dbo_legacy_mappable_9 on showtimes.legacy_mappable lm (cost=0.56..0.59 rows=1 width=258) (actual rows= loops=)

  • Output: lm.legacy_mappable_id, lm.first_update_detail_id, lm.last_update_detail_id, lm.mapping_scheme_id, lm.metadata, lm.remote_id, lm.verified, lm.automatic, lm.ignore, lm.requested, lm.type_prefix, lm.show_num, lm.epi_num, lm.automap_attempted, lm.start_dt, lm.end_dt, lm.version_mapping_id, lm.follow_up, lm.workbasket_id, lm.sla_met, lm.sla_reported, lm.sla_type_id, lm.xmap_status_id, lm.xmap_set, lm.xmap_ignore, lm.priority
  • Index Cond: (lm.last_update_detail_id = upd.update_detail_id)