explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uRre

Settings
# exclusive inclusive rows x rows loops node
1. 34.400 1,932.901 ↓ 9.0 271,281 1

Unique (cost=1,224,716.15..1,229,068.35 rows=30,200 width=20) (actual time=1,871.092..1,932.901 rows=271,281 loops=1)

2. 189.038 1,898.501 ↑ 2.1 271,281 1

Sort (cost=1,224,716.15..1,226,166.88 rows=580,293 width=20) (actual time=1,871.091..1,898.501 rows=271,281 loops=1)

  • Sort Key: map.eid, ((cap.pricingdate)::date)
  • Sort Method: external sort Disk: 9,024kB
3. 25.945 1,709.463 ↑ 2.1 271,281 1

Nested Loop (cost=0.99..1,157,259.98 rows=580,293 width=20) (actual time=0.057..1,709.463 rows=271,281 loops=1)

4. 0.925 0.925 ↑ 1.0 151 1

Index Scan using fundmapping_ciqvw2_ventype_eid_startdate_idx1 on fundmapping_ciqvw2 map (cost=0.42..904.57 rows=151 width=12) (actual time=0.008..0.925 rows=151 loops=1)

  • Index Cond: ((ventype = 10) AND (eid = ANY ('{1002585895,1002585937,1002586016,1002586068,1002586084,1002586086,1002586108,1002586118,1002586130,1002586152,1002586220,1002586256,1002586284,1002586352,1002586481,1002586493,1002586505,1002586511,1002586525,1002586533,1002586546,1002586639,1002586674,1002586712,1002586822,1002586908,1002586910,1002586934,1002586956,1002586980,1002587004,1002587089,1002587209,1002587243,1002587271,1002587289,1002587351,1002587376,1002587390,1002587400,1002587418,1002587460,1002587464,1002587485,1002587542,1002587574,1002587580,1002587584,1002587606,1002587764,1002587766,1002587782,1002587810,1002587812,1002587814,1002587881,1002587917,1002587927,1002587931,1002587935,1002588065,1002588077,1002588127,1002588150,1002588162,1002588168,1002588186,1002588226,1002588294,1002588332,1002588350,1002588354,1002588450,1002588570,1002588620,1002588654,1002588666,1002588728,1002588734,1002588872,1002588913,1002588933,1002589073,1002589179,1002589259,1002589313,1002589323,1002589349,1002589393,1002589421,1002589547,1002589563,1002589715,1002589719,1002589815,1002589819,1002589833,1002589895,1002589899,1002589911,1002590118,1002590120,1002590146,1002590194,1002590230,1002590254,1002590296,1002590412,1002590432,1002590446,1002590476,1002590635,1002590661,1002590745,1002590819,1002590919,1002590925,1002590929,1002591021,1002591035,1002591063,1002591215,1002591221,1002591283,1002591307,1002591415,1002591543,1002591545,1002591577,1002591583,1002591741,1002591775,1002591819,1002591829,1002591853,1002591859,1002591887,1002591945,1002591989,1002592032,1002592046,1002592064,1002592140,1002592212,1002592293,1002592417,1002592423,1002592567,1002592597,1002592659,1002592661}'::bigint[])))
5. 1,682.593 1,682.593 ↑ 2.1 1,797 151

Index Scan using ciqmarketcap_pkey on ciqmarketcap cap (cost=0.57..7,581.12 rows=3,843 width=20) (actual time=1.532..11.143 rows=1,797 loops=151)

  • Index Cond: ((companyid = map.vencode) AND (pricingdate >= '2005-09-01 00:00:00'::timestamp without time zone) AND (pricingdate <= '2010-08-31 00:00:00'::timestamp without time zone))
Planning time : 1.006 ms
Execution time : 1,944.985 ms