explain.depesz.com

PostgreSQL's explain analyze made readable

Result: elCD : Documents With Family - Advanced Search

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 16.166 ↓ 78.3 235 1

Hash Join (cost=5,343.64..9,252.30 rows=3 width=8) (actual time=12.225..16.166 rows=235 loops=1)

  • Hash Cond: (t_e20so1_document_property.c_docfamilyid = table_1.c_docfamilyid)
2. 1.387 7.950 ↑ 1.0 2,432 1

Gather (cost=1,000.71..4,902.99 rows=2,432 width=16) (actual time=0.705..7.950 rows=2,432 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 0.072 6.563 ↑ 1.2 1,216 2 / 2

Nested Loop (cost=0.71..3,659.79 rows=1,431 width=16) (actual time=0.070..6.563 rows=1,216 loops=2)

4. 0.122 0.411 ↑ 1.2 1,216 2 / 2

Parallel Append (cost=0.28..66.38 rows=1,431 width=8) (actual time=0.024..0.411 rows=1,216 loops=2)

5. 0.289 0.289 ↑ 1.2 1,216 2 / 2

Parallel Index Only Scan using t_e20so1_document_datastore_11_pkey on t_e20so1_document_datastore_11 t_e20so1_document (cost=0.28..59.23 rows=1,431 width=8) (actual time=0.023..0.289 rows=1,216 loops=2)

  • Index Cond: (c_datastoresid = 11)
  • Heap Fetches: 0
6. 6.080 6.080 ↑ 1.0 1 2,432 / 2

Index Scan using "UQ_6254444f-e5fc-4e42-a793-f9ff24a78adc" on t_e20so1_document_property (cost=0.43..2.51 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=2,432)

  • Index Cond: (c_documentid = t_e20so1_document.c_documentid)
7. 0.055 11.440 ↑ 10.7 158 1

Hash (cost=4,321.89..4,321.89 rows=1,683 width=8) (actual time=11.440..11.440 rows=158 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 23kB
8. 0.099 11.385 ↑ 10.7 158 1

HashAggregate (cost=4,288.23..4,305.06 rows=1,683 width=8) (actual time=11.328..11.385 rows=158 loops=1)

  • Group Key: table_1.c_docfamilyid
9. 3.783 11.286 ↑ 7.2 235 1

Gather (cost=1,000.43..4,284.02 rows=1,683 width=8) (actual time=2.901..11.286 rows=235 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
10. 0.020 7.503 ↑ 8.4 118 2 / 2

Nested Loop Left Join (cost=0.43..3,115.72 rows=990 width=8) (actual time=0.977..7.503 rows=118 loops=2)

11. 0.015 6.778 ↑ 8.4 118 2 / 2

Parallel Append (cost=0.00..591.64 rows=990 width=8) (actual time=0.930..6.778 rows=118 loops=2)

12. 6.763 6.763 ↑ 8.4 118 2 / 2

Parallel Seq Scan on t_e20so1_document_datastore_11 table_0 (cost=0.00..586.69 rows=990 width=8) (actual time=0.929..6.763 rows=118 loops=2)

  • Filter: ((c_docoriginalid IS NULL) AND (c_datastoresid = 11) AND (lower((c_docdisplayid)::text) = ANY ('{rev00023,rev00023_red,rev00024,rev00024_red,rev00025,rev00025_red,rev00026,rev00026_red,rev00027,rev00028,rev00029,rev00030,rev00031,rev00032,rev00033,rev00034,rev00035,rev00036,rev00037,rev00038,rev00039,rev00040,rev00041,rev00042,rev00043,rev00044,rev00045,rev00046,rev00047,rev00048,rev00049,rev00050,rev00051,rev00052,rev00053,rev00054,rev00055,rev00056,rev00057,rev00058,rev00059,rev00060,rev00061,rev00062,rev00063,rev00064,rev00065,rev00066,rev00067,rev00068,rev00069,rev00070,rev00071,rev00072,rev00073,rev00074,rev00075,rev00076,rev00077,rev00078,rev00079,rev00081,rev00082,rev00080,rev00083,rev00084,rev00085,rev00086,rev00087,rev00088,rev00089,rev00090,rev00091,rev00092,rev00093,rev00094,rev00095,rev00096,rev00097,rev00098,rev00099,rev00100,rev00101,rev00102,rev00103,rev00104,rev00105,rev00106,rev00107,rev00108,rev00110,rev00111,rev00112,rev00113,rev00114,rev00115,rev00116,rev00117,rev00118,rev00119,rev00120,rev00121,rev00122,rev00123,rev00124,rev00125,rev00126,rev00127,rev00128,rev00129,rev00130,rev00131,rev00132,rev00133,rev00134,rev00135,rev00136,rev00137,rev00138,rev00140,rev00139,rev00141,rev00142,rev00143,rev00144,rev00145,rev00146,rev00147,rev00148,rev00149,rev00150,rev00151,rev00152,rev00153,rev00154,rev00155,rev00156,rev00157,rev00158,rev00159,rev00160,rev00161,rev00162,rev00163,rev00164,rev00165,rev00166,rev00167,rev00168,rev00170,rev00171,rev00172,rev00173,rev00174,rev00175,rev00176,rev00169,rev00177,rev00178,rev00179,rev00180,rev00181,rev00182,rev00183,rev00184,rev00185,rev00186,rev00187,rev00188,rev00189,rev00190,rev00191,rev00192,rev00193,rev00194,rev00195,rev00196,rev00197,rev00198,rev00200,rev00201,rev00199,rev00202,rev00203,rev00204,rev00205,rev00206,rev00207,rev00208,rev00209,rev00210,rev00211,rev00212,rev00213,rev00214,rev00215,rev00216,rev00217,rev00218,rev00219,rev00220,rev00221,rev00222,rev00223,rev00224,rev00225,rev00226,rev00227,rev00228,rev00229,rev00230,rev00231,rev00232,rev00233,rev00234,rev00235,rev00236,rev00237,rev00238,rev00239,rev00240,rev00241,rev00242,rev00243,rev00244,rev00245,rev00246,rev00247,rev00248,rev00249,rev00250,rev00251,rev00252,rev00253,rev00254}'::text[])))
  • Rows Removed by Filter: 1,098
13. 0.705 0.705 ↑ 1.0 1 235 / 2

Index Scan using "UQ_6254444f-e5fc-4e42-a793-f9ff24a78adc" on t_e20so1_document_property table_1 (cost=0.43..2.55 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=235)

  • Index Cond: (table_0.c_documentid = c_documentid)