explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SgRs

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.085 ↓ 0.0 0 1

Append (cost=0.00..130.92 rows=17 width=272) (actual time=0.083..0.085 rows=0 loops=1)

2. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on slot_state slot_state_1 (cost=0.00..0.00 rows=1 width=272) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
3. 0.006 0.006 ↓ 0.0 0 1

Index Scan using slot_state_section_status_0_index on slot_state_0 slot_state_2 (cost=0.14..8.18 rows=1 width=272) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
4. 0.004 0.004 ↓ 0.0 0 1

Index Scan using slot_state_section_status_1_index on slot_state_1 slot_state_3 (cost=0.14..8.18 rows=1 width=272) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
5. 0.005 0.005 ↓ 0.0 0 1

Index Scan using slot_state_section_status_2_index on slot_state_2 slot_state_4 (cost=0.14..8.18 rows=1 width=272) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
6. 0.007 0.007 ↓ 0.0 0 1

Index Scan using slot_state_section_status_3_index on slot_state_3 slot_state_5 (cost=0.14..8.18 rows=1 width=272) (actual time=0.006..0.007 rows=0 loops=1)

  • Index Cond: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
7. 0.004 0.004 ↓ 0.0 0 1

Index Scan using slot_state_section_status_4_index on slot_state_4 slot_state_6 (cost=0.14..8.18 rows=1 width=272) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
8. 0.005 0.005 ↓ 0.0 0 1

Index Scan using slot_state_section_status_5_index on slot_state_5 slot_state_7 (cost=0.14..8.18 rows=1 width=272) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
9. 0.004 0.004 ↓ 0.0 0 1

Index Scan using slot_state_section_status_6_index on slot_state_6 slot_state_8 (cost=0.14..8.18 rows=1 width=272) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
10. 0.005 0.005 ↓ 0.0 0 1

Index Scan using slot_state_section_status_7_index on slot_state_7 slot_state_9 (cost=0.14..8.18 rows=1 width=272) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
11. 0.006 0.006 ↓ 0.0 0 1

Index Scan using slot_state_section_status_8_index on slot_state_8 slot_state_10 (cost=0.14..8.18 rows=1 width=272) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
12. 0.004 0.004 ↓ 0.0 0 1

Index Scan using slot_state_section_status_9_index on slot_state_9 slot_state_11 (cost=0.14..8.18 rows=1 width=272) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
13. 0.006 0.006 ↓ 0.0 0 1

Index Scan using slot_state_section_status_a_index on slot_state_a slot_state_12 (cost=0.14..8.18 rows=1 width=272) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
14. 0.006 0.006 ↓ 0.0 0 1

Index Scan using slot_state_section_status_b_index on slot_state_b slot_state_13 (cost=0.14..8.18 rows=1 width=272) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
15. 0.004 0.004 ↓ 0.0 0 1

Index Scan using slot_state_section_status_c_index on slot_state_c slot_state_14 (cost=0.14..8.18 rows=1 width=272) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
16. 0.005 0.005 ↓ 0.0 0 1

Index Scan using slot_state_section_status_d_index on slot_state_d slot_state_15 (cost=0.14..8.18 rows=1 width=272) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
17. 0.005 0.005 ↓ 0.0 0 1

Index Scan using slot_state_section_status_e_index on slot_state_e slot_state_16 (cost=0.14..8.18 rows=1 width=272) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
18. 0.004 0.004 ↓ 0.0 0 1

Index Scan using slot_state_section_status_f_index on slot_state_f slot_state_17 (cost=0.14..8.18 rows=1 width=272) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((slot_slot_type_section_layout_venue_slug = ''::text) AND (event_period_event_layout_venue_slug = ''::text) AND (slot_slot_type_section_layout_slug = ''::text) AND (event_period_event_layout_slug = ''::text) AND (slot_slot_type_section_slug = ''::text) AND (event_period_event_slug = ''::text) AND (event_period_slug = ''::text))
Planning time : 9.179 ms
Execution time : 0.300 ms