explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cv2u

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.061 ↓ 0.0 0 1

HashAggregate (cost=45.34..45.72 rows=38 width=527) (actual time=0.061..0.061 rows=0 loops=1)

  • Group Key: mktsegpmtestdev.pysubjectid, mktsegpmtestdev.partitionkey, ('ADD'::text), ('DKaeeacd9c'::text)
2. 0.003 0.061 ↓ 0.0 0 1

Append (cost=2.31..44.96 rows=38 width=527) (actual time=0.061..0.061 rows=0 loops=1)

3. 0.000 0.012 ↓ 0.0 0 1

Nested Loop (cost=2.31..4.36 rows=1 width=528) (actual time=0.012..0.012 rows=0 loops=1)

4. 0.002 0.012 ↓ 0.0 0 1

HashAggregate (cost=2.17..2.18 rows=1 width=516) (actual time=0.012..0.012 rows=0 loops=1)

  • Group Key: (mkt_paidmedia_master.customerid)::text
5. 0.010 0.010 ↓ 0.0 0 1

Index Scan using mkt_paidmedia_master_idx2 on mkt_paidmedia_master (cost=0.14..2.17 rows=1 width=516) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (((action)::text = 'ADD'::text) AND ((status)::text = 'FAILED'::text))
  • Filter: (((accounttype)::text = 'Web'::text) AND ((accountid)::text = 'webdevacc'::text) AND (upper((identifier)::text) = 'PMTESTDEV'::text) AND (upper((forceresync)::text) = 'FALSE'::text))
6. 0.000 0.000 ↓ 0.0 0

Index Scan using mktsegpmtestdev_pkey on mktsegpmtestdev (cost=0.14..2.16 rows=1 width=528) (never executed)

  • Index Cond: ((pysubjectid)::text = (mkt_paidmedia_master.customerid)::text)
7. 0.001 0.002 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=11.01..13.06 rows=1 width=516) (actual time=0.002..0.002 rows=0 loops=1)

8. 0.001 0.001 ↓ 0.0 0 1

Index Scan using mkt_paidmedia_master_idx2 on mkt_paidmedia_master mkt_paidmedia_master_1 (cost=11.01..13.05 rows=1 width=516) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (((action)::text = 'REMOVE'::text) AND ((status)::text = 'FAILED'::text))
  • Filter: ((NOT (hashed SubPlan 3)) AND ((accounttype)::text = 'Web'::text) AND ((accountid)::text = 'webdevacc'::text) AND (upper((classification)::text) = 'SEGMENT'::text) AND (upper((identifier)::text) = 'PMTESTDEV'::text))
9.          

SubPlan (forIndex Scan)

10. 0.000 0.000 ↓ 0.0 0

Seq Scan on mktsegpmtestdev mktsegpmtestdev_3 (cost=0.00..10.70 rows=70 width=516) (never executed)

11. 0.014 0.025 ↓ 0.0 0 1

Seq Scan on mktsegpmtestdev mktsegpmtestdev_1 (cost=3.26..14.13 rows=35 width=528) (actual time=0.025..0.025 rows=0 loops=1)

  • Filter: (NOT (hashed SubPlan 2))
  • Rows Removed by Filter: 2
12.          

SubPlan (forSeq Scan)

13. 0.011 0.011 ↓ 2.0 2 1

Index Scan using mkt_paidmedia_master_idx1 on mkt_paidmedia_master mkt_paidmedia_master_3 (cost=0.14..3.25 rows=1 width=516) (actual time=0.009..0.011 rows=2 loops=1)

  • Index Cond: (((accounttype)::text = 'Web'::text) AND ((accountid)::text = 'webdevacc'::text))
  • Filter: ((upper((identifier)::text) = 'PMTESTDEV'::text) AND (upper((forceresync)::text) = 'FALSE'::text))
14. 0.000 0.019 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4 (cost=11.01..13.06 rows=1 width=516) (actual time=0.019..0.019 rows=0 loops=1)

15. 0.017 0.019 ↓ 0.0 0 1

Index Scan using mkt_paidmedia_master_idx2 on mkt_paidmedia_master mkt_paidmedia_master_2 (cost=11.01..13.05 rows=1 width=516) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (((action)::text = 'ADD'::text) AND ((status)::text = 'SUCCESS'::text))
  • Filter: ((NOT (hashed SubPlan 1)) AND ((accounttype)::text = 'Web'::text) AND ((accountid)::text = 'webdevacc'::text) AND (upper((classification)::text) = 'SEGMENT'::text) AND (upper((identifier)::text) = 'PMTESTDEV'::text))
  • Rows Removed by Filter: 4
16.          

SubPlan (forIndex Scan)

17. 0.002 0.002 ↑ 35.0 2 1

Seq Scan on mktsegpmtestdev mktsegpmtestdev_2 (cost=0.00..10.70 rows=70 width=516) (actual time=0.000..0.002 rows=2 loops=1)

Planning time : 0.399 ms
Execution time : 0.140 ms