explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LI0Q

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 148.218 6,750.954 ↑ 2.6 132,414 1

Sort (cost=1,378,327.75..1,379,174.13 rows=338,555 width=446) (actual time=6,729.018..6,750.954 rows=132,414 loops=1)

  • Sort Key: (sum(calls)) DESC
  • Sort Method: quicksort  Memory: 121,598kB
2. 1,877.612 6,602.736 ↑ 2.6 132,414 1

GroupAggregate (cost=1,263,536.98..1,278,958.61 rows=338,555 width=446) (actual time=4,005.332..6,602.736 rows=132,414 loops=1)

  • Group Key: queryid, query
3. 3,813.132 4,725.124 ↓ 1.0 606,134 1

Sort (cost=1,263,536.98..1,265,041.49 rows=601,804 width=453) (actual time=4,005.307..4,725.124 rows=606,134 loops=1)

  • Sort Key: queryid, query
  • Sort Method: external merge  Disk: 293,832kB
4. 911.992 911.992 ↓ 1.0 606,134 1

Index Scan using ccs_data_dbstats_idx4 on ccs_data_dbstats "PC0" (cost=0.56..1,082,350.00 rows=601,804 width=453) (actual time=0.063..911.992 rows=606,134 loops=1)

  • Index Cond: (((pztenantid)::text = 'shared'::text) AND (snapshottime >= '2020-07-27 00:00:00'::timestampwithout time zone) AND (snapshottime <= '2020-07-27 23:59:59.999'::timestamp without time zone) AND ((isoncloud)::text = 'true'::text))
  • Filter: ((pxobjclass)::text = 'CCS-Data-PDC-FleetWise-QueryStats'::text)
Planning time : 1.050 ms
Execution time : 6,811.987 ms