explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b4Kv

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.032 ↓ 0.0 0 1

GroupAggregate (cost=1.90..1.94 rows=1 width=664) (actual time=0.032..0.032 rows=0 loops=1)

  • Group Key: accountid, errorcode, accounttype, dataflowrunid, synctype, paidrunid
2. 0.023 0.031 ↓ 0.0 0 1

Sort (cost=1.90..1.90 rows=1 width=683) (actual time=0.030..0.031 rows=0 loops=1)

  • Sort Key: accountid, errorcode, accounttype, dataflowrunid, synctype, paidrunid
  • Sort Method: quicksort Memory: 25kB
3. 0.008 0.008 ↓ 0.0 0 1

Index Scan using mkt_paidmedia_master_idx2 on mkt_paidmedia_master "PC0" (cost=0.14..1.89 rows=1 width=683) (actual time=0.007..0.008 rows=0 loops=1)

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