explain.depesz.com

PostgreSQL's explain analyze made readable

Result: osAo

Settings
# exclusive inclusive rows x rows loops node
1. 0.285 131.308 ↓ 4.6 1,768 1

Unique (cost=55,013.31..55,015.24 rows=386 width=8) (actual time=130.914..131.308 rows=1,768 loops=1)

2. 0.553 131.023 ↓ 4.6 1,768 1

Sort (cost=55,013.31..55,014.28 rows=386 width=8) (actual time=130.913..131.023 rows=1,768 loops=1)

  • Sort Key: table_0_1.c_documentid
  • Sort Method: quicksort Memory: 131kB
3. 0.189 130.470 ↓ 4.6 1,768 1

Nested Loop (cost=0.28..54,996.73 rows=386 width=8) (actual time=0.050..130.470 rows=1,768 loops=1)

4. 0.016 0.016 ↑ 1.0 1 1

Seq Scan on t_e20so1_custodian table_0 (cost=0.00..1.04 rows=1 width=8) (actual time=0.012..0.016 rows=1 loops=1)

  • Filter: (lower((c_custodianname)::text) = 'no custodian'::text)
  • Rows Removed by Filter: 2
5. 0.147 130.265 ↓ 4.6 1,768 1

Append (cost=0.28..54,991.83 rows=386 width=16) (actual time=0.037..130.265 rows=1,768 loops=1)

6. 20.066 130.118 ↓ 4.6 1,768 1

Index Scan using t_e20so1_document_datastore_11_c_custodianid_idx on t_e20so1_document_datastore_11 table_0_1 (cost=0.28..54,989.90 rows=386 width=16) (actual time=0.036..130.118 rows=1,768 loops=1)

  • Index Cond: (c_custodianid = table_0.c_custodianid)
  • Filter: ((c_docoriginalid IS NULL) AND (c_datastoresid = 11) AND (NOT (SubPlan 1)))
  • Rows Removed by Filter: 270
7.          

SubPlan (for Index Scan)

8. 26.422 110.052 ↑ 17.3 134 2,038

Nested Loop (cost=0.00..136.52 rows=2,317 width=8) (actual time=0.006..0.054 rows=134 loops=2,038)

9. 10.190 10.190 ↓ 0.0 0 2,038

Seq Scan on t_e20so1_datasets table_1 (cost=0.00..1.81 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=2,038)

  • Filter: ((c_datasetsid = table_0_1.c_datasetid) AND (lower((c_datasetname)::text) = 'ds00001'::text))
  • Rows Removed by Filter: 43
10. 20.790 73.440 ↑ 2.3 1,012 270

Append (cost=0.00..111.55 rows=2,317 width=8) (actual time=0.001..0.272 rows=1,012 loops=270)

11. 52.650 52.650 ↑ 2.3 1,012 270

Seq Scan on t_e20so1_document_datastore_11 table_0_2 (cost=0.00..99.96 rows=2,317 width=8) (actual time=0.001..0.195 rows=1,012 loops=270)

  • Filter: ((c_docoriginalid IS NULL) AND (c_datastoresid = 11))