explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7rt0

Settings
# exclusive inclusive rows x rows loops node
1. 184.546 160,704.043 ↑ 120.0 1 1

GroupAggregate (cost=958,036.47..958,493.34 rows=120 width=93) (actual time=160,704.042..160,704.043 rows=1 loops=1)

  • Group Key: accountid, errorcode, accounttype, dataflowrunid, synctype, paidrunid
2. 30.373 160,519.497 ↓ 1.1 20,000 1

Sort (cost=958,036.47..958,082.03 rows=18,227 width=123) (actual time=160,513.031..160,519.497 rows=20,000 loops=1)

  • Sort Key: accountid, errorcode, accounttype, dataflowrunid, synctype, paidrunid
  • Sort Method: quicksort Memory: 3581kB
3. 160,489.124 160,489.124 ↓ 1.1 20,000 1

Index Scan using mkt_paidmedia_master_idx2 on mkt_paidmedia_master "PC0" (cost=0.57..956,746.56 rows=18,227 width=123) (actual time=1.212..160,489.124 rows=20,000 loops=1)

  • Index Cond: ((status)::text = 'FAILED'::text)
  • Filter: (decisiontime >= '2019-08-08 00:00:00'::timestamp without time zone)
Planning time : 7.930 ms
Execution time : 160,705.722 ms