explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zr4O

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.027 ↓ 0.0 0 1

GroupAggregate (cost=0.44..24.60 rows=1 width=160) (actual time=0.024..0.027 rows=0 loops=1)

  • Group Key: td.event_layout_venue_slug, td.event_layout_slug, td.event_slug, td.slug
2. 0.002 0.023 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.44..24.57 rows=1 width=312) (actual time=0.021..0.023 rows=0 loops=1)

3. 0.002 0.021 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..16.37 rows=1 width=256) (actual time=0.019..0.021 rows=0 loops=1)

  • Join Filter: ((td.event_layout_venue_slug = tdep.ticket_definition_event_layout_venue_slug) AND (td.event_layout_slug = tdep.ticket_definition_event_layout_slug) AND (td.event_slug = tdep.ticket_definition_event_slug) AND (td.slug = tdep.ticket_definition_slug))
4. 0.019 0.019 ↓ 0.0 0 1

Index Only Scan using ticket_definition_idx on ticket_definition td (cost=0.15..8.17 rows=1 width=128) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((event_layout_venue_slug = ''::text) AND (event_layout_slug = ''::text) AND (event_slug = ''::text) AND (slug = ''::text))
  • Heap Fetches: 0
5. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ticket_definition_event_period_idx on ticket_definition_event_period tdep (cost=0.15..8.17 rows=1 width=256) (never executed)

  • Index Cond: ((ticket_definition_event_layout_venue_slug = ''::text) AND (ticket_definition_event_layout_slug = ''::text) AND (ticket_definition_event_slug = ''::text) AND (ticket_definition_slug = ''::text))
  • Heap Fetches: 0
6. 0.000 0.000 ↓ 0.0 0

Index Scan using event_period_idx on event_period ep (cost=0.15..8.17 rows=1 width=312) (never executed)

  • Index Cond: ((event_layout_venue_slug = tdep.event_period_event_layout_venue_slug) AND (event_layout_slug = tdep.event_period_event_layout_slug) AND (event_slug = tdep.event_period_event_slug) AND (slug = tdep.event_period_slug))
Planning time : 2.954 ms
Execution time : 14.951 ms