explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kq9y

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 6,472.760 ↑ 1.0 1 1

Aggregate (cost=2,063,387.30..2,063,387.31 rows=1 width=8) (actual time=6,472.759..6,472.760 rows=1 loops=1)

2. 0.002 6,472.754 ↓ 0.0 0 1

Append (cost=0.56..2,063,387.30 rows=2 width=18) (actual time=6,472.754..6,472.754 rows=0 loops=1)

3. 6,472.730 6,472.730 ↓ 0.0 0 1

Index Scan using mkt_paidmedia_master_idx1 on mkt_paidmedia_master mas (cost=0.56..2,063,385.24 rows=1 width=18) (actual time=6,472.729..6,472.730 rows=0 loops=1)

  • Index Cond: (((accounttype)::text = 'Web'::text) AND ((accountid)::text = 'webdevacc'::text))
  • Filter: (((audiencename)::text = 'Pmtestdev'::text) AND ((status)::text = 'SUCCESS'::text))
  • Rows Removed by Filter: 3028551
4. 0.022 0.022 ↓ 0.0 0 1

Index Scan using mkt_paidmedia_master_idx2 on mkt_paidmedia_master mas_1 (cost=0.56..2.03 rows=1 width=18) (actual time=0.021..0.022 rows=0 loops=1)

  • Index Cond: ((action)::text = 'REMOVE'::text)
  • Filter: (((accountid)::text = 'webdevacc'::text) AND ((accounttype)::text = 'Web'::text) AND ((audiencename)::text = 'Pmtestdev'::text))
Planning time : 7.183 ms
Execution time : 6,473.210 ms