explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ppn4 : Optimization for: plan #Ydox

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.013 63.394 ↑ 2.0 100 1

Limit (cost=22,976.32..22,980.32 rows=200 width=49) (actual time=63.294..63.394 rows=100 loops=1)

  • Buffers: shared hit=19,288
2. 0.120 63.381 ↑ 49.6 100 1

GroupAggregate (cost=22,976.32..23,075.46 rows=4,957 width=49) (actual time=63.291..63.381 rows=100 loops=1)

  • Group Key: ec.c_exportname, d_5.c_docdisplayid
  • Buffers: shared hit=19,288
3. 0.000 63.261 ↑ 49.6 100 1

Sort (cost=22,976.32..22,988.71 rows=4,957 width=49) (actual time=63.254..63.261 rows=100 loops=1)

  • Sort Key: ec.c_exportname, d_5.c_docdisplayid
  • Sort Method: quicksort Memory: 32kB
  • Buffers: shared hit=19,288
4. 19.615 70.266 ↑ 49.6 100 1

Gather (cost=19,201.6..22,672.07 rows=4,957 width=49) (actual time=62.668..70.266 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=19,288
5. 0.014 50.651 ↑ 62.6 33 3 / 3

Nested Loop (cost=18,201.6..21,176.37 rows=2,065 width=49) (actual time=43.336..50.651 rows=33 loops=3)

  • Buffers: shared hit=19,288
6. 2.573 50.504 ↑ 56.8 33 3 / 3

Hash Join (cost=18,201.18..20,265.82 rows=1,874 width=49) (actual time=43.288..50.504 rows=33 loops=3)

  • Buffers: shared hit=18,885
7. 10.142 46.990 ↑ 1.3 17,915 3 / 3

Hash Join (cost=17,720.14..19,654.06 rows=22,394 width=30) (actual time=31.702..46.99 rows=17,915 loops=3)

  • Buffers: shared hit=18,369
8. 2.078 8.184 ↑ 1.3 21,998 3 / 3

Append (cost=0.29..1,737.71 rows=27,518 width=22) (actual time=0.057..8.184 rows=21,998 loops=3)

  • Buffers: shared hit=1,209
9. 5.097 5.097 ↑ 1.2 18,228 3 / 3

Index Only Scan using t_e20so1_document_datastore_15_c_docdisplayid_c_documentid_idx on t_e20so1_document_datastore_15 d_5 (cost=0.41..1,349.78 rows=22,785 width=20) (actual time=0.04..5.097 rows=18,228 loops=3)

  • Heap Fetches: 55
  • Buffers: shared hit=776
10. 0.955 0.955 ↑ 1.2 5,266 2 / 3

Index Only Scan using t_e20so1_document_datastore_11_c_docdisplayid_c_documentid_idx on t_e20so1_document_datastore_11 d_1 (cost=0.29..206.12 rows=6,191 width=31) (actual time=0.06..1.433 rows=5,266 loops=2)

  • Heap Fetches: 1,726
  • Buffers: shared hit=419
11. 0.025 0.025 ↓ 1.7 420 1 / 3

Index Only Scan using t_e20so1_document_datastore_14_c_docdisplayid_c_documentid_idx on t_e20so1_document_datastore_14 d_4 (cost=0.27..12.54 rows=247 width=22) (actual time=0.009..0.076 rows=420 loops=1)

  • Buffers: shared hit=7
12. 0.020 0.020 ↓ 1.7 294 1 / 3

Index Only Scan using t_e20so1_document_datastore_16_c_docdisplayid_c_documentid_idx on t_e20so1_document_datastore_16 d_6 (cost=0.27..8.97 rows=173 width=32) (actual time=0.019..0.061 rows=294 loops=1)

  • Buffers: shared hit=5
13. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on t_e20so1_document_datastore_12 d_2 (cost=0..10.18 rows=18 width=226) (actual time=0..0 rows=0 loops=1)

14. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on t_e20so1_document_datastore_default d_7 (cost=0..10.18 rows=18 width=226) (actual time=0..0.001 rows=0 loops=1)

15. 0.003 0.003 ↓ 1.9 35 1 / 3

Seq Scan on t_e20so1_document_datastore_13 d_3 (cost=0..1.18 rows=18 width=20) (actual time=0.005..0.01 rows=35 loops=1)

  • Buffers: shared hit=1
16. 0.004 0.004 ↓ 1.7 27 1 / 3

Seq Scan on t_e20so1_document_datastore_1 d (cost=0..1.16 rows=16 width=26) (actual time=0.006..0.013 rows=27 loops=1)

  • Buffers: shared hit=1
17. 5.818 28.664 ↑ 1.3 17,915 3 / 3

Hash (cost=17,439.93..17,439.93 rows=22,394 width=8) (actual time=28.663..28.664 rows=17,915 loops=3)

  • Buffers: shared hit=17,160
18. 22.846 22.846 ↑ 1.3 17,915 3 / 3

Seq Scan on temp_dat_08052020062023_72074 a (cost=0..17,439.93 rows=22,394 width=8) (actual time=0.276..22.846 rows=17,915 loops=3)

  • Filter: (a.importtype_cp = 2)
  • Buffers: shared hit=17,160
19. 0.077 0.941 ↑ 20.8 221 3 / 3

Hash (cost=423.57..423.57 rows=4,598 width=35) (actual time=0.941..0.941 rows=221 loops=3)

  • Buffers: shared hit=456
20. 0.055 0.864 ↑ 20.8 221 3 / 3

Nested Loop (cost=0.28..423.57 rows=4,598 width=35) (actual time=0.11..0.864 rows=221 loops=3)

  • Buffers: shared hit=456
21. 0.116 0.116 ↓ 1.1 11 3 / 3

Seq Scan on t_e20so1_exportconfig ec (cost=0..11.09 rows=10 width=43) (actual time=0.039..0.116 rows=11 loops=3)

  • Filter: (ec.c_exporttype = 2)
  • Buffers: shared hit=30
22. 0.066 0.693 ↑ 29.7 20 33 / 3

Append (cost=0.28..35.31 rows=594 width=24) (actual time=0.015..0.063 rows=20 loops=33)

  • Buffers: shared hit=426
23. 0.264 0.264 ↓ 2.0 20 33 / 3

Index Only Scan using "UQ_83a9a5dc-5667-4aeb-92f4-efa3d9184431" on t_e20so1_document_boolean db (cost=0.28..1.87 rows=10 width=24) (actual time=0.014..0.024 rows=20 loops=33)

  • Index Cond: (db.c_fieldid = ec.c_exportdoclablesid)
  • Heap Fetches: 645
  • Buffers: shared hit=125
24. 0.132 0.132 ↓ 0.0 0 33 / 3

Index Scan using t_e20so1_document_bool_batches_fieldid_idx on t_e20so1_document_boolean_batches db_1 (cost=0.29..9.73 rows=12 width=24) (actual time=0.012..0.012 rows=0 loops=33)

  • Index Cond: (db_1.c_fieldid = ec.c_exportdoclablesid)
  • Buffers: shared hit=68
25. 0.022 0.022 ↓ 0.0 0 33 / 3

Index Scan using t_e20so1_document_bool_customfields_fieldid_idx on t_e20so1_document_boolean_customfields db_2 (cost=0.15..1.45 rows=5 width=24) (actual time=0.002..0.002 rows=0 loops=33)

  • Index Cond: (db_2.c_fieldid = ec.c_exportdoclablesid)
  • Buffers: shared hit=33
26. 0.022 0.022 ↓ 0.0 0 33 / 3

Index Scan using t_e20so1_document_bool_datasets_fieldid_idx on t_e20so1_document_boolean_datasets db_3 (cost=0.15..1.45 rows=5 width=24) (actual time=0.002..0.002 rows=0 loops=33)

  • Index Cond: (db_3.c_fieldid = ec.c_exportdoclablesid)
  • Buffers: shared hit=33
27. 0.022 0.022 ↓ 0.0 0 33 / 3

Index Scan using t_e20so1_document_bool_edoc_fieldid_idx on t_e20so1_document_boolean_edoc db_4 (cost=0.15..1.45 rows=5 width=24) (actual time=0.002..0.002 rows=0 loops=33)

  • Index Cond: (db_4.c_fieldid = ec.c_exportdoclablesid)
  • Buffers: shared hit=33
28. 0.011 0.011 ↓ 0.0 0 33 / 3

Index Scan using t_e20so1_document_bool_email_fieldid_idx on t_e20so1_document_boolean_email db_5 (cost=0.15..1.45 rows=5 width=24) (actual time=0.001..0.001 rows=0 loops=33)

  • Index Cond: (db_5.c_fieldid = ec.c_exportdoclablesid)
  • Buffers: shared hit=33
29. 0.154 0.154 ↓ 0.0 0 33 / 3

Index Only Scan using uc_unique_t_e20so1_document_boolean_folders on t_e20so1_document_boolean_folders db_6 (cost=0.42..14.94 rows=552 width=24) (actual time=0.014..0.014 rows=0 loops=33)

  • Index Cond: (db_6.c_fieldid = ec.c_exportdoclablesid)
  • Buffers: shared hit=101
30. 0.133 0.133 ↑ 1.0 1 100 / 3

Index Scan using t_e20so1_pages_c_documentid_idx on t_e20so1_pages p (cost=0.41..0.48 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=100)

  • Index Cond: (a.documentid_cp = p.c_documentid)
  • Buffers: shared hit=403
Planning time : 10.238 ms
Execution time : 71.236 ms