#	exclusive	inclusive	rows x	loops	node
1.	0.001	0.032	↓ 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	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	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

QUERY PLAN                                                                                                                                                         
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
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                                                                                 
  ->  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                                                                                                                       
        ->  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

Per node type stats

node type	count	sum of times	% of query
GroupAggregate	1	0.001 ms	3.1 %
Index Scan	1	0.008 ms	25.0 %
Sort	1	0.023 ms	71.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
mkt_paidmedia_master	1	0.008 ms	25.0 %
Index Scan	1	0.008 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b4Kv

Color mode:

Visible columns:

Per node type stats

Per table stats