explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0lGX

Settings
# exclusive inclusive rows x rows loops node
1. 23.663 83.610 ↑ 1.0 80,000 1

Merge Left Join (cost=9,162.65..10,166.16 rows=80,000 width=151) (actual time=53.539..83.610 rows=80,000 loops=1)

  • Merge Cond: ((s.slot_type_section_layout_venue_slug = st.section_layout_venue_slug) AND (s.slot_type_section_layout_slug = st.section_layout_slug) AND (s.slot_type_section_slug = st.section_slug) AND (s.slot_type_slug = st.slug))
2. 41.336 57.054 ↑ 1.0 80,000 1

Sort (cost=9,093.08..9,293.08 rows=80,000 width=151) (actual time=53.437..57.054 rows=80,000 loops=1)

  • Sort Key: s.slot_type_section_layout_venue_slug, s.slot_type_section_layout_slug, s.slot_type_section_slug, s.slot_type_slug
  • Sort Method: quicksort Memory: 24,323kB
3. 15.718 15.718 ↑ 1.0 80,000 1

Seq Scan on slot s (cost=0.00..2,578.00 rows=80,000 width=151) (actual time=0.008..15.718 rows=80,000 loops=1)

4. 2.806 2.893 ↑ 280.0 1 1

Sort (cost=69.56..70.26 rows=280 width=128) (actual time=0.095..2.893 rows=1 loops=1)

  • Sort Key: st.section_layout_venue_slug, st.section_layout_slug, st.section_slug, st.slug
  • Sort Method: quicksort Memory: 25kB
5. 0.038 0.087 ↑ 280.0 1 1

Hash Join (cost=39.50..58.18 rows=280 width=128) (actual time=0.084..0.087 rows=1 loops=1)

  • Hash Cond: ((tdst.slot_type_section_layout_venue_slug = st.section_layout_venue_slug) AND (tdst.slot_type_section_layout_slug = st.section_layout_slug) AND (tdst.slot_type_section_slug = st.section_slug) AND (tdst.slot_type_slug = st.slug))
6. 0.020 0.036 ↑ 280.0 1 1

Hash Join (cost=18.40..34.14 rows=280 width=128) (actual time=0.035..0.036 rows=1 loops=1)

  • Hash Cond: ((tdst.ticket_definition_event_layout_venue_slug = td.event_layout_venue_slug) AND (tdst.ticket_definition_event_layout_slug = td.event_layout_slug) AND (tdst.ticket_definition_event_slug = td.event_slug) AND (tdst.ticket_definition_slug = td.slug))
7. 0.003 0.003 ↑ 280.0 1 1

Seq Scan on ticket_definition_slot_type tdst (cost=0.00..12.80 rows=280 width=256) (actual time=0.002..0.003 rows=1 loops=1)

8. 0.010 0.013 ↑ 280.0 1 1

Hash (cost=12.80..12.80 rows=280 width=128) (actual time=0.013..0.013 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
9. 0.003 0.003 ↑ 280.0 1 1

Seq Scan on ticket_definition td (cost=0.00..12.80 rows=280 width=128) (actual time=0.003..0.003 rows=1 loops=1)

10. 0.004 0.013 ↑ 370.0 1 1

Hash (cost=13.70..13.70 rows=370 width=128) (actual time=0.013..0.013 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
11. 0.009 0.009 ↑ 370.0 1 1

Seq Scan on slot_type st (cost=0.00..13.70 rows=370 width=128) (actual time=0.009..0.009 rows=1 loops=1)

Planning time : 2.052 ms
Execution time : 86.937 ms