explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KBKK

Settings
# exclusive inclusive rows x rows loops node
1. 421.474 4,269.576 ↓ 45.3 1,120,934 1

Gather (cost=230,786.17..261,026.67 rows=24,722 width=12) (actual time=1,417.642..4,269.576 rows=1,120,934 loops=1)

  • Workers Planned: 3
  • Params Evaluated: $0
  • Workers Launched: 3
2.          

Initplan (for Gather)

3. 0.008 0.020 ↑ 1.0 1 1

Aggregate (cost=11.00..11.01 rows=1 width=4) (actual time=0.020..0.020 rows=1 loops=1)

4. 0.012 0.012 ↑ 20.0 4 1

Seq Scan on temp_refinesearch_gqkuzf2d4wstopgh2f0lf1yj refine_search (cost=0.00..10.80 rows=80 width=4) (actual time=0.011..0.012 rows=4 loops=1)

5. 79.525 3,848.082 ↓ 35.1 280,234 4 / 4

Hash Join (cost=229,775.16..257,543.46 rows=7,975 width=12) (actual time=1,427.627..3,848.082 rows=280,234 loops=4)

  • Hash Cond: (table_1.c_doctype = table_0.c_enumid)
6. 103.430 3,768.525 ↓ 35.1 280,234 4 / 4

Nested Loop (cost=229,774.05..257,432.69 rows=7,975 width=12) (actual time=1,427.549..3,768.525 rows=280,234 loops=4)

7. 0.000 2,824.395 ↓ 35.1 280,234 4 / 4

Nested Loop (cost=229,773.62..253,225.72 rows=7,975 width=24) (actual time=1,427.503..2,824.395 rows=280,234 loops=4)

8. 170.447 1,989.490 ↓ 35.1 280,234 4 / 4

Merge Join (cost=229,773.19..249,503.48 rows=7,975 width=16) (actual time=1,427.407..1,989.490 rows=280,234 loops=4)

  • Merge Cond: (temp_drilldown_gqkuzf2d4wstopgh2f0lf1yj."_PKID" = doc.c_documentid)
9. 157.400 306.551 ↓ 35.1 280,234 4 / 4

Sort (cost=44,690.72..44,710.66 rows=7,975 width=8) (actual time=254.712..306.551 rows=280,234 loops=4)

  • Sort Key: temp_drilldown_gqkuzf2d4wstopgh2f0lf1yj."_PKID
  • Sort Method: external merge Disk: 5160kB
  • Worker 0: Sort Method: external merge Disk: 5000kB
  • Worker 1: Sort Method: external merge Disk: 4824kB
  • Worker 2: Sort Method: external merge Disk: 4864kB
10. 149.151 149.151 ↓ 35.1 280,234 4 / 4

Parallel Seq Scan on temp_drilldown_gqkuzf2d4wstopgh2f0lf1yj (cost=0.00..44,173.89 rows=7,975 width=8) (actual time=100.603..149.151 rows=280,234 loops=4)

  • Filter: (c_level = $0)
  • Rows Removed by Filter: 840700
11. 177.352 1,512.492 ↓ 1.0 1,120,832 4 / 4

Unique (cost=185,082.48..190,685.52 rows=1,120,609 width=8) (actual time=1,172.669..1,512.492 rows=1,120,832 loops=4)

12. 641.798 1,335.140 ↓ 1.0 1,120,832 4 / 4

Sort (cost=185,082.48..187,884.00 rows=1,120,609 width=8) (actual time=1,172.658..1,335.140 rows=1,120,832 loops=4)

  • Sort Key: doc.c_documentid
  • Sort Method: external merge Disk: 19752kB
  • Worker 0: Sort Method: external merge Disk: 19752kB
  • Worker 1: Sort Method: external merge Disk: 19752kB
  • Worker 2: Sort Method: external merge Disk: 19752kB
13. 217.759 693.342 ↓ 1.0 1,120,936 4 / 4

Hash Join (cost=2.12..54,534.71 rows=1,120,609 width=8) (actual time=0.127..693.342 rows=1,120,936 loops=4)

  • Hash Cond: (doc.c_datasetid = dataset.c_datasetsid)
14. 88.601 475.551 ↓ 1.0 1,120,936 4 / 4

Append (cost=0.00..51,341.66 rows=1,120,609 width=16) (actual time=0.041..475.551 rows=1,120,936 loops=4)

15. 386.950 386.950 ↓ 1.0 1,120,936 4 / 4

Seq Scan on t_e20so1_document_datastore_16 doc (cost=0.00..45,738.61 rows=1,120,609 width=16) (actual time=0.040..386.950 rows=1,120,936 loops=4)

  • Filter: (c_datastoresid = 16)
16. 0.011 0.032 ↑ 1.0 50 4 / 4

Hash (cost=1.50..1.50 rows=50 width=8) (actual time=0.031..0.032 rows=50 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
17. 0.021 0.021 ↑ 1.0 50 4 / 4

Seq Scan on t_e20so1_datasets dataset (cost=0.00..1.50 rows=50 width=8) (actual time=0.014..0.021 rows=50 loops=4)

18. 280.234 840.701 ↑ 1.0 1 1,120,934 / 4

Append (cost=0.43..0.46 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=1,120,934)

19. 560.467 560.467 ↑ 1.0 1 1,120,934 / 4

Index Only Scan using t_e20so1_document_datastore_16_pkey on t_e20so1_document_datastore_16 document (cost=0.43..0.45 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,120,934)

  • Index Cond: ((c_documentid = doc.c_documentid) AND (c_datastoresid = 16))
  • Heap Fetches: 0
20. 840.701 840.701 ↑ 1.0 1 1,120,934 / 4

Index Scan using t_e20so1_document_property_c_documentid_idx on t_e20so1_document_property table_1 (cost=0.43..0.53 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=1,120,934)

  • Index Cond: (c_documentid = doc.c_documentid)
21. 0.006 0.032 ↑ 1.0 5 4 / 4

Hash (cost=1.05..1.05 rows=5 width=4) (actual time=0.032..0.032 rows=5 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
22. 0.026 0.026 ↑ 1.0 5 4 / 4

Seq Scan on t_e20so1_filetype table_0 (cost=0.00..1.05 rows=5 width=4) (actual time=0.024..0.026 rows=5 loops=4)

Planning time : 3.811 ms