explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IKGP

Settings
# exclusive inclusive rows x rows loops node
1. 0.878 4.525 ↓ 4.6 1,768 1

HashAggregate (cost=72.45..76.31 rows=386 width=8) (actual time=4.201..4.525 rows=1,768 loops=1)

  • Group Key: table_0_2.c_documentid
2. 1.949 3.647 ↓ 4.6 1,768 1

Hash Left Join (cost=2.31..71.48 rows=386 width=8) (actual time=0.063..3.647 rows=1,768 loops=1)

  • Hash Cond: (table_0_2.c_datasetid = table_0_1.c_datasetsid)
  • Filter: (NOT (SubPlan 1))
  • Rows Removed by Filter: 270
3. 0.224 1.677 ↓ 2.6 2,038 1

Nested Loop (cost=0.28..67.00 rows=772 width=16) (actual time=0.033..1.677 rows=2,038 loops=1)

4. 0.015 0.015 ↑ 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.015 rows=1 loops=1)

  • Filter: (lower((c_custodianname)::text) = 'no custodian'::text)
  • Rows Removed by Filter: 2
5. 0.296 1.438 ↓ 2.6 2,038 1

Append (cost=0.28..58.24 rows=772 width=24) (actual time=0.020..1.438 rows=2,038 loops=1)

6. 1.142 1.142 ↓ 2.6 2,038 1

Index Scan using t_e20so1_document_datastore_11_c_custodianid_idx on t_e20so1_document_datastore_11 table_0_2 (cost=0.28..54.38 rows=772 width=24) (actual time=0.018..1.142 rows=2,038 loops=1)

  • Index Cond: (c_custodianid = table_0.c_custodianid)
  • Filter: ((c_docoriginalid IS NULL) AND (c_datastoresid = 11))
7. 0.010 0.021 ↓ 1.1 50 1

Hash (cost=1.46..1.46 rows=46 width=16) (actual time=0.021..0.021 rows=50 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
8. 0.011 0.011 ↓ 1.1 50 1

Seq Scan on t_e20so1_datasets table_0_1 (cost=0.00..1.46 rows=46 width=16) (actual time=0.004..0.011 rows=50 loops=1)

9.          

SubPlan (for Hash Left Join)

10. 0.000 0.000 ↓ 0.0 0 2,038

Result (cost=0.01..0.01 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=2,038)

  • One-Time Filter: (lower((table_0_1.c_datasetname)::text) = 'ds00001'::text)