explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tngh

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

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

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

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

  • Workers Planned: 1
  • Workers Launched: 1
3. 1.013 5.043 ↑ 1.2 1,216 2 / 2

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

4. 0.102 0.382 ↑ 1.2 1,216 2 / 2

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

5. 0.280 0.280 ↑ 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.024..0.280 rows=1,216 loops=2)

  • Index Cond: (c_datastoresid = 11)
  • Heap Fetches: 0
6. 3.648 3.648 ↑ 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.003..0.003 rows=1 loops=2,432)

  • Index Cond: (c_documentid = t_e20so1_document.c_documentid)
7. 0.036 8.891 ↑ 10.7 158 1

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

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

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

  • Group Key: table_1.c_docfamilyid
9. 3.226 8.788 ↑ 7.2 235 1

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

  • Workers Planned: 1
  • Workers Launched: 1
10. 0.016 5.562 ↑ 8.4 118 2 / 2

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

11. 0.012 5.076 ↑ 8.4 118 2 / 2

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

12. 5.064 5.064 ↑ 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.852..5.064 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.470 0.470 ↑ 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.004..0.004 rows=1 loops=235)

  • Index Cond: (table_0.c_documentid = c_documentid)