explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ydox

Settings

Optimization(s) for this plan:

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

Limit (cost=22,756.28..22,760.28 rows=200 width=49) (actual time=48.512..48.611 rows=100 loops=1)

  • Buffers: shared hit=19,220
2. 0.102 48.598 ↑ 44.0 100 1

GroupAggregate (cost=22,756.28..22,844.38 rows=4,405 width=49) (actual time=48.51..48.598 rows=100 loops=1)

  • Group Key: ec.c_exportname, d_5.c_docdisplayid
  • Buffers: shared hit=19,220
3. 0.000 48.496 ↑ 44.0 100 1

Sort (cost=22,756.28..22,767.3 rows=4,405 width=49) (actual time=48.489..48.496 rows=100 loops=1)

  • Sort Key: ec.c_exportname, d_5.c_docdisplayid
  • Sort Method: quicksort Memory: 32kB
  • Buffers: shared hit=19,220
4. 22.110 54.246 ↑ 44.0 100 1

Gather (cost=19,324.54..22,489.67 rows=4,405 width=49) (actual time=42.561..54.246 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=19,220
5. 0.027 32.136 ↑ 55.6 33 3 / 3

Nested Loop (cost=18,324.54..21,049.17 rows=1,835 width=49) (actual time=28.479..32.136 rows=33 loops=3)

  • Buffers: shared hit=19,220
6. 2.664 32.009 ↑ 55.6 33 3 / 3

Hash Join (cost=18,324.12..20,172.39 rows=1,835 width=49) (actual time=28.446..32.009 rows=33 loops=3)

  • Buffers: shared hit=18,818
7. 1.971 8.051 ↑ 1.3 21,998 3 / 3

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

  • Buffers: shared hit=1,177
8. 5.143 5.143 ↑ 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.034..5.143 rows=18,228 loops=3)

  • Heap Fetches: 55
  • Buffers: shared hit=776
9. 0.885 0.885 ↑ 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.048..1.327 rows=5,266 loops=2)

  • Heap Fetches: 1,574
  • Buffers: shared hit=387
10. 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
11. 0.019 0.019 ↓ 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.017..0.058 rows=294 loops=1)

  • Buffers: shared hit=5
12. 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.001 rows=0 loops=1)

13. 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 rows=0 loops=1)

14. 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
15. 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.004..0.011 rows=27 loops=1)

  • Buffers: shared hit=1
16. 0.090 21.294 ↑ 55.6 33 3 / 3

Hash (cost=18,300.9..18,300.9 rows=1,835 width=43) (actual time=21.294..21.294 rows=33 loops=3)

  • Buffers: shared hit=17,581
17. 2.148 21.204 ↑ 55.6 33 3 / 3

Hash Join (cost=394.74..18,300.9 rows=1,835 width=43) (actual time=1.187..21.204 rows=33 loops=3)

  • Buffers: shared hit=17,581
18. 18.264 18.264 ↑ 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.023..18.264 rows=17,915 loops=3)

  • Filter: (a.importtype_cp = 2)
  • Buffers: shared hit=17,160
19. 0.061 0.792 ↑ 19.9 221 3 / 3

Hash (cost=339.68..339.68 rows=4,405 width=35) (actual time=0.792..0.792 rows=221 loops=3)

  • Buffers: shared hit=421
20. 0.048 0.731 ↑ 19.9 221 3 / 3

Nested Loop (cost=0.28..339.68 rows=4,405 width=35) (actual time=0.103..0.731 rows=221 loops=3)

  • Buffers: shared hit=421
21. 0.111 0.111 ↓ 1.1 11 3 / 3

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

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

Append (cost=0.28..26.99 rows=587 width=24) (actual time=0.015..0.052 rows=20 loops=33)

  • Buffers: shared hit=391
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.015..0.024 rows=20 loops=33)

  • Index Cond: (db.c_fieldid = ec.c_exportdoclablesid)
  • Heap Fetches: 645
  • Buffers: shared hit=125
24. 0.011 0.011 ↓ 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.15..1.45 rows=5 width=24) (actual time=0.001..0.001 rows=0 loops=33)

  • Index Cond: (db_1.c_fieldid = ec.c_exportdoclablesid)
  • Buffers: shared hit=33
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.011 0.011 ↓ 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.001..0.001 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.165 0.165 ↓ 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.015..0.015 rows=0 loops=33)

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

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

  • Index Cond: (d_5.c_documentid = p.c_documentid)
  • Buffers: shared hit=402
Planning time : 8.05 ms
Execution time : 55.079 ms