explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eLTw

Settings
# exclusive inclusive rows x rows loops node
1. 0.228 6,562.303 ↓ 2.0 8 1

Unique (cost=25,731.31..25,731.34 rows=4 width=12) (actual time=6,562.014..6,562.303 rows=8 loops=1)

2. 2.478 6,562.075 ↓ 323.0 1,292 1

Sort (cost=25,731.31..25,731.32 rows=4 width=12) (actual time=6,562.013..6,562.075 rows=1,292 loops=1)

  • Sort Key: (((cataloguecomponents.functiongrouplabel || ' '::text) || (cataloguecomponents.descriptionid)::text)), cataloguecomponents.id
  • Sort Method: quicksort Memory: 149kB
3. 45.035 6,559.597 ↓ 323.0 1,292 1

Nested Loop (cost=23,386.96..25,731.27 rows=4 width=12) (actual time=38.811..6,559.597 rows=1,292 loops=1)

4. 56.313 116.212 ↓ 2,031.2 36,562 1

Hash Join (cost=23,386.54..25,566.45 rows=18 width=16) (actual time=38.069..116.212 rows=36,562 loops=1)

  • Hash Cond: (virtualtoshared.levels[1] = cataloguecomponents.id)
5. 22.198 22.198 ↑ 1.0 36,562 1

Seq Scan on virtualtoshared (cost=0.00..2,042.62 rows=36,562 width=38) (actual time=0.351..22.198 rows=36,562 loops=1)

6. 0.349 37.701 ↓ 1.4 840 1

Hash (cost=23,379.21..23,379.21 rows=586 width=12) (actual time=37.701..37.701 rows=840 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 44kB
7. 37.352 37.352 ↓ 1.4 840 1

Index Scan using ix_cataloguecomponents_id on cataloguecomponents (cost=0.43..23,379.21 rows=586 width=12) (actual time=0.018..37.352 rows=840 loops=1)

  • Index Cond: (typeid = 2)
8. 6,398.350 6,398.350 ↓ 0.0 0 36,562

Index Scan using componentconditions_fkcataloguecomponent_idx on componentconditions (cost=0.42..9.14 rows=1 width=4) (actual time=0.170..0.175 rows=0 loops=36,562)

  • Index Cond: (fkcataloguecomponent = virtualtoshared.fkcataloguecomponent)
  • Filter: (fkprofile = ANY ('{0b00c8af802065cc,0b00c8af802065cd,0b00c8af802065e0,0b00c8af802065fe,0b00c8af80206603,0b00c8af80206624,0b00c8af80206638,0b00c8af80206694,0b00c8af80206699,0b00c8af802066a4,0b00c8af802066cd,0b00c8af802066da,0b00c8af802067a1,0b00c8af802068f6,0b00c8af802068f7,0b00c8af80206908,0b00c8af80206910,0b00c8af80209576,0b00c8af80209577,0b00c8af80209581,0b00c8af8020958b,0b00c8af80209592,0b00c8af80209593,0b00c8af80209599,0b00c8af802095ad,0b00c8af802095ae,0b00c8af802095b1,0b00c8af802095b2,0b00c8af802095bb,0b00c8af802095d3,0b00c8af802095d5,0b00c8af802095d9,0b00c8af802095e6,0b00c8af80209607,0b00c8af8020960b,0b00c8af80209616,0b00c8af8020bcab,0b00c8af8020bcae,0b00c8af8020bcaf,0b00c8af8020bcbe,0b00c8af8020bcde,0b00c8af8020e97f,0b00c8af8020ec86,0b00c8af8020ec8c,0b00c8af8020ec9e,0b00c8af8020ed3e,0b00c8af8020ed4e,0b00c8af8020ed52,0b00c8af80454429,0b00c8af8045442a,0b00c8af80454465,0b00c8af80454466,0b00c8af8045449a,0b00c8af80454531,0b00c8af80454532,0b00c8af80454533,0b00c8af80454534,0b00c8af80454542,0b00c8af80454572,0b00c8af80454573,0b00c8af80454574,0b00c8af80454575,0b00c8af80454582,0b00c8af8045458c,0b00c8af804545b3,0b00c8af804545bc,0b00c8af804545e9,0b00c8af804545f2,0b00c8af804545fb,0b00c8af80454604,0b00c8af8045461a,0b00c8af8045461c,0b00c8af804cb2d2,0b00c8af804cb31f,0b00c8af804cb323,0b00c8af804cb429,0b00c8af804cb42c,0b00c8af804cb42f,0b00c8af804cb432,0b00c8af804ddf99,0b00c8af804de137,0b00c8af804de13a,0b00c8af804dfc3c,0b00c8af804dfcb3,0b00c8af804e3313,0b00c8af804e3322,0b00c8af804e3334,0b00c8af804e3349,0b00c8af804e335c,0b00c8af804e336e,0b00c8af804e51f6,0b00c8af81b047bd,0b00c8af81b047c9,0b00c8af81b047d3,0b00c8af81b047de,0b00c8af81b04811,0b00c8af81b0481d,0b00c8af81b04827,0b00c8af81b04832,0b00c8af81b0483d,0b00c8af81b04849,0b00c8af81b04855,0b00c8af81b04869,0b00c8af81b04873,0b00c8af81b0487b,0b00c8af81b04885,0b00c8af81b04893,0b00c8af81b0489b,0b00c8af81b048aa,0b00c8af81b048b5,0b00c8af81b048be,0b00c8af81b048ca,0b00c8af81b048d4,0b00c8af81b048e0,0b00c8af81b048ea,0b00c8af81b048fa,0b00c8af81b04906,0b00c8af81b0490e,0b00c8af81b04919,0b00c8af81b04926,0b00c8af81b04930,0b00c8af81b0493c,0b00c8af81b0494a,0b00c8af81b04953,0b00c8af81b0495e,0b00c8af81b0497d,0b00c8af81b04989,0b00c8af81b04995,0b00c8af81b0499e,0b00c8af81b049aa,0b00c8af81b049c5,0b00c8af81b049d2,0b00c8af81b049df,0b00c8af81b049e9,0b00c8af81b049f4,0b00c8af81b049fa,0b00c8af81b04a04,0b00c8af81b04a14,0b00c8af81b04a20,0b00c8af81b04a2b,0b00c8af81b04a31,0b00c8af81b04a3e,0b00c8af81b04a4a,0b00c8af81b04a54,0b00c8af81d0fc83,0b00c8af81d0fc86,0b00c8af81d0fc87,0b00c8af81d0fc8a,0b00c8af81d0fc8b,0b00c8af81d0fc8e,0b00c8af81d0fc8f,0b00c8af81d0fc92,0b00c8af81d0fc93,0b00c8af81d0fc96,0b00c8af81d0fc97,0b00c8af81d0fc9a,0b00c8af81d0fc9b,0b00c8af81d0fc9e,0b00c8af81d0fc9f,0b00c8af81d0fca2,0b00c8af81d0fca3,0b00c8af81d0fca6,0b00c8af81d0fca7,0b00c8af81d0fcaa,0b00c8af81d0fcab,0b00c8af81d0fcae,0b00c8af81d0fcaf,0b00c8af81d0fcb2,0b00c8af81d0fcb3,0b00c8af81d0fcb6,0b00c8af81d0fcb7,0b00c8af81d0fcba,0b00c8af81d0fcbb,0b00c8af81d0fcbe,0b00c8af81d0fcbf,0b00c8af81d0fcc2,0b00c8af81d0fcc3,0b00c8af81d0fcc6,0b00c8af81d0fcc7,0b00c8af81d0fcca,0b00c8af81d0fccb,0b00c8af81d0fcce,0b00c8af81d0fccf,0b00c8af81d0fcd2,0b00c8af81d0fcd3,0b00c8af81d0fcd6,0b00c8af81d0fcd7,0b00c8af81d0fcda,0b00c8af81d0fcdb,0b00c8af81d0fcde,0b00c8af81d0fcdf,0b00c8af81d0fce2,0b00c8af81d0fce4,0b00c8af81d0fce7,0b00c8af81d0fce8,0b00c8af81d0fceb,0b00c8af81d0fcec,0b00c8af81d0fcef,0b00c8af81d0fcf0,0b00c8af81d0fcf3,0b00c8af81d0fcf5,0b00c8af81d0fcf8,0b00c8af81d0fcf9,0b00c8af81d0fcfc,0b00c8af81d0fcfd,0b00c8af81d0fd00,0b00c8af81d0fd01,0b00c8af81d0fd04,0b00c8af81d0fd05,0b00c8af81d0fd08,0b00c8af81d0fd09,0b00c8af81d0fd0c,0b00c8af81d0fd0d,0b00c8af81d0fd10,0b00c8af81d0fd11,0b00c8af81d0fd14,0b00c8af81d0fd19,0b00c8af81d0fd1c,0b00c8af81d0fd1d,0b00c8af81d0fd20,0b00c8af81d0fd21,0b00c8af81d0fd24,0b00c8af81d0fd25,0b00c8af81d0fd28,0b00c8af81d0fd29,0b00c8af81d0fd2c,0b00c8af81d0fd2d,0b00c8af81d0fd30,0b00c8af81d0fd31,0b00c8af81d0fd34,0b00c8af81d0fd35,0b00c8af81d0fd38,0b00c8af81d0fd3d,0b00c8af81d0fd40,0b00c8af81d0fd41,0b00c8af81d0fd44,0b00c8af81d0fd46,0b00c8af81d0fd49,0b00c8af81d0fd4a,0b00c8af81d0fd4d,0b00c8af81d0fd4e,0b00c8af81d0fd51,0b00c8af81d0fd52,0b00c8af81d0fd55,0b00c8af81d0fd56,0b00c8af81d0fd59,0b00c8af81d0fd5a,0b00c8af81d0fd5d,0b00c8af81d0fd5e,0b00c8af81d0fd61,0b00c8af81d0fd62,0b00c8af81d0fd65,0b00c8af81d0fd66,0b00c8af81d0fd69,0b00c8af81d0fd6a,0b00c8af81d0fd6d,0b00c8af81d0fd6e,0b00c8af81d0fd71,0b00c8af81d0fd72,0b00c8af81d0fd75,0b00c8af81d0fd76,0b00c8af81d0fd79,0b00c8af81d0fd7a,0b00c8af81d0fd7d,0b00c8af81d0fd7e,0b00c8af81d0fd81,0b00c8af81d0fd82,0b00c8af81d0fd85,0b00c8af81d0fd86,0b00c8af81d0fd89,0b00c8af81d0fd8a,0b00c8af81d0fd8d,0b00c8af81d0fd8e,0b00c8af81d0fd91,0b00c8af81d0fd92,0b00c8af81d0fd95,0b00c8af81d0fd96,0b00c8af81d0fd99,0b00c8af81d0fd9b,0b00c8af81d0fd9e,0c00c8af80205920}'::text[]))
  • Rows Removed by Filter: 13