explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J3qI

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 29.488 ↑ 1.2 4 1

Nested Loop (cost=0.29..347.01 rows=5 width=1,118) (actual time=14.880..29.488 rows=4 loops=1)

2. 28.207 28.207 ↑ 1.2 4 1

Seq Scan on customer_ticket_detail ctd (cost=0.00..305.45 rows=5 width=16) (actual time=14.131..28.207 rows=4 loops=1)

  • Filter: ((ticket_action_id = 1) AND ((creation_date)::date >= '2018-11-06'::date) AND ((creation_date)::date <= '2018-11-11'::date))
  • Rows Removed by Filter: 8112
3. 1.268 1.268 ↑ 1.0 1 4

Index Scan using customer_ticket_pkey on customer_ticket ct (cost=0.29..8.30 rows=1 width=1,110) (actual time=0.317..0.317 rows=1 loops=4)

  • Index Cond: (ticket_id = ctd.ticket_id)