explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d2uq

Settings
# exclusive inclusive rows x rows loops node
1. 49.027 721.463 ↑ 401.6 3,186 1

Unique (cost=1,128,006.35..1,172,786.61 rows=1,279,436 width=280) (actual time=656.731..721.463 rows=3,186 loops=1)

  • (actual time=0.073..82.813 rows=59,377 loops=1)
2. 383.714 672.436 ↑ 21.5 59,377 1

Sort (cost=1,128,006.35..1,131,204.94 rows=1,279,436 width=280) (actual time=656.717..672.436 rows=59,377 loops=1)

  • Sort Key: "PC0".day, "PC0".pyissue, "PC0".pygroup, "PC0".pyname, "PC0".pytreatment, "PC0".testdesign_treatment_ctl, "PC0".testdesignid, "PC0".treatment_cellcode, "PC0".uri, "PC0".placement, (CASE WHEN ((sum("Day".totaldecisionedcount)) IS NULL) THEN '0'::numeric ELSE (sum("Day".totaldecisionedcount)) END), (CASE WHEN ((sum("Day".totalviewcount)) IS NULL) THEN '0'::numeric ELSE (sum("Day".totalviewcount)) END), (CASE WHEN ((sum("Day".totalclickcount)) IS NULL) THEN '0'::numeric ELSE (sum("Day".totalclickcount)) END)
  • Sort Method: quicksort Memory: 14,896kB
3. 51.004 288.722 ↑ 21.5 59,377 1

Nested Loop (cost=1.15..903,266.27 rows=1,279,436 width=280) (actual time=0.194..288.722 rows=59,377 loops=1)

4. 140.254 140.254 ↑ 36.4 3,144 1

GroupAggregate (cost=0.59..68,955.87 rows=114,543 width=139) (actual time=0.171..140.254 rows=3,144 loops=1)

  • Group Key: "Day".day, "Day".aggregatekey
5. 0.000 0.000 ↓ 0.0

Index Scan using pr_jpmc_mkt_data_aggregates_i1 on pr_jpmc_mkt_data_aggregates "Day" (cost=0.59..65,496.59 rows=116,382 width=57) (actual rows= loops=)

  • Index Cond: (((day)::text >= to_char(((('now'::cstring)::date - 1))::timestamp with time zone, 'YYYYMMDD'::text)) AND ((day)::text < to_char(((('now'::cstring)::date - 0))::timestamp with time zone, 'YYYYMMDD'::text)))
  • Filter: ((pxobjclass)::text = 'JPMC-MKT-Data-Aggregates'::text)
6. 97.464 97.464 ↓ 1.7 19 3,144

Index Scan using pr_jpmc_mkt_data_aggregates_i1 on pr_jpmc_mkt_data_aggregates "PC0" (cost=0.56..7.16 rows=11 width=218) (actual time=0.019..0.031 rows=19 loops=3,144)

  • Index Cond: (((day)::text = ("Day".day)::text) AND ((aggregatekey)::text = ("Day".aggregatekey)::text))
  • Filter: ((pxobjclass)::text = 'JPMC-MKT-Data-Aggregates'::text)
Planning time : 1.352 ms
Execution time : 723.132 ms