explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GbK

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.497 ↓ 6.0 6 1

Unique (cost=17.00..17.02 rows=1 width=56) (actual time=0.490..0.497 rows=6 loops=1)

2. 0.018 0.488 ↓ 6.0 6 1

Sort (cost=17.00..17.00 rows=1 width=56) (actual time=0.488..0.488 rows=6 loops=1)

  • Sort Key: "EmailAddress".cust_num, (count("EmailAddress".email)), "Package".no_of_emails, "AlaCarte".mboxqty, (("Package".no_of_emails + "AlaCarte".mboxqty)), (round((((count("EmailAddress".email))::numeric / (GREATEST("Package".no_of_emails, ("Package".no_of_emails + "AlaCarte".mboxqty)))::numeric) * '100'::numeric), 1))
  • Sort Method: quicksort Memory: 25kB
3. 0.031 0.470 ↓ 6.0 6 1

GroupAggregate (cost=16.94..16.99 rows=1 width=56) (actual time=0.452..0.470 rows=6 loops=1)

  • Group Key: "EmailAddress".cust_num, "Package".no_of_emails, "AlaCarte".mboxqty
4. 0.032 0.439 ↓ 13.0 13 1

Sort (cost=16.94..16.94 rows=1 width=528) (actual time=0.437..0.439 rows=13 loops=1)

  • Sort Key: "EmailAddress".cust_num, "Package".no_of_emails, "AlaCarte".mboxqty
  • Sort Method: quicksort Memory: 26kB
5. 0.095 0.407 ↓ 13.0 13 1

Nested Loop Left Join (cost=0.15..16.93 rows=1 width=528) (actual time=0.103..0.407 rows=13 loops=1)

  • Join Filter: ("Customer".cust_num = "AlaCarte".cust_num)
  • Rows Removed by Join Filter: 27
6. 0.015 0.286 ↓ 13.0 13 1

Nested Loop (cost=0.15..15.86 rows=1 width=528) (actual time=0.090..0.286 rows=13 loops=1)

7. 0.097 0.180 ↓ 13.0 13 1

Nested Loop (cost=0.00..11.68 rows=1 width=942) (actual time=0.049..0.180 rows=13 loops=1)

  • Join Filter: ("Customer".cust_num = "EmailAddress".cust_num)
  • Rows Removed by Join Filter: 59
8. 0.044 0.044 ↓ 13.0 13 1

Seq Scan on "EmailAddress" (cost=0.00..10.50 rows=1 width=520) (actual time=0.034..0.044 rows=13 loops=1)

  • Filter: (status = 'Active'::bpchar)
  • Rows Removed by Filter: 4
9. 0.039 0.039 ↑ 1.3 6 13

Seq Scan on "Customer" (cost=0.00..1.08 rows=8 width=422) (actual time=0.002..0.003 rows=6 loops=13)

10. 0.091 0.091 ↑ 1.0 1 13

Index Scan using "Package_pkey" on "Package" (cost=0.15..4.17 rows=1 width=36) (actual time=0.007..0.007 rows=1 loops=13)

  • Index Cond: (pkg_id = ("Customer".package)::text)
11. 0.026 0.026 ↑ 1.0 3 13

Seq Scan on "AlaCarte" (cost=0.00..1.03 rows=3 width=8) (actual time=0.001..0.002 rows=3 loops=13)