explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jHA : select * from customer_summary_dynamic WHERE customer_id

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.216 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.00..31.56 rows=1 width=116) (actual time=0.213..0.216 rows=1 loops=1)

  • Join Filter: (public.customer.id = customer_journal.customer_id)
2. 0.002 0.158 ↑ 1.0 1 1

Nested Loop (cost=0.00..11.33 rows=1 width=52) (actual time=0.156..0.158 rows=1 loops=1)

3. 0.010 0.096 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.00..10.34 rows=1 width=20) (actual time=0.094..0.096 rows=1 loops=1)

  • Join Filter: (public.customer.id = booking.customer_id)
4. 0.027 0.027 ↑ 1.0 1 1

Index Scan using customer_pkey on customer (cost=0.00..0.47 rows=1 width=4) (actual time=0.026..0.027 rows=1 loops=1)

  • Index Cond: (id = 99936)
5. 0.034 0.059 ↑ 1.0 1 1

GroupAggregate (cost=0.00..9.85 rows=1 width=17) (actual time=0.059..0.059 rows=1 loops=1)

6. 0.025 0.025 ↑ 7.5 13 1

Index Scan using booking_customer_id on booking (cost=0.00..8.63 rows=97 width=17) (actual time=0.016..0.025 rows=13 loops=1)

  • Index Cond: (customer_id = 99936)
7. 0.040 0.060 ↑ 1.0 1 1

GroupAggregate (cost=0.00..0.97 rows=1 width=633) (actual time=0.060..0.060 rows=1 loops=1)

8. 0.005 0.020 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.00..0.95 rows=1 width=633) (actual time=0.017..0.020 rows=1 loops=1)

  • Join Filter: (public.customer.id = contact.customer_id)
9. 0.005 0.005 ↑ 1.0 1 1

Index Scan using customer_pkey on customer (cost=0.00..0.47 rows=1 width=31) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (id = 99936)
10. 0.010 0.010 ↑ 1.0 1 1

Index Scan using contact_customer_id_idx on contact (cost=0.00..0.47 rows=1 width=606) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (customer_id = 99936)
11. 0.033 0.052 ↑ 1.0 1 1

GroupAggregate (cost=0.00..20.21 rows=1 width=18) (actual time=0.051..0.052 rows=1 loops=1)

12. 0.019 0.019 ↑ 23.9 8 1

Index Scan using customer_journal_customer_id_idx on customer_journal (cost=0.00..18.76 rows=191 width=18) (actual time=0.012..0.019 rows=8 loops=1)

  • Index Cond: (customer_id = 99936)
Total runtime : 0.546 ms